Question

Required information

[The following information applies to the questions displayed below.]

Wiset Company completes these transactions during April of the current year (the terms of all its credit sales are 2/10, n/30).

Apr.		2			Purchased $15,500 of merchandise on credit from Noth Company, invoice dated April 2, terms 2/10, n/60.
		3		(a)	Sold merchandise on credit to Page Alistair, Invoice No. 760, for $6,000 (cost is $3,000).
		3		(b)	Purchased $1,510 of office supplies on credit from Custer, Inc. Invoice dated April 2, terms n/10 EOM.
		4			Issued Check No. 587 to World View for advertising expense, $909.
		5			Sold merchandise on credit to Paula Kohr, Invoice No. 761, for $8,100 (cost is $7,600).
		6			Received an $85 credit memorandum from Custer, Inc., for the return of some of the office supplies received on April 3.
		9			Purchased $10,210 of store equipment on credit from Hal’s Supply, invoice dated April 9, terms n/10 EOM.
		11			Sold merchandise on credit to Nic Nelson, Invoice No. 762, for $11,900 (cost is $6,400).
		12			Issued Check No. 588 to Noth Company in payment of its April 2 invoice less the discount.
		13		(a)	Received payment from Page Alistair for the April 3 sale less the discount.
		13		(b)	Sold $10,200 of merchandise on credit to Page Alistair (cost is $4,700), Invoice No. 763.
		14			Received payment from Paula Kohr for the April 5 sale less the discount.
		16		(a)	Issued Check No. 589, payable to Payroll, in payment of sales salaries expense for the first half of the month, $9,000. Cashed the check and paid employees.
		16		(b)	Cash sales for the first half of the month are $58,780 (cost is $37,100). (Cash sales are recorded daily from cash register data but are recorded only twice in this problem to reduce repetitive entries.)
		17			Purchased $12,000 of merchandise on credit from Grant Company, invoice dated April 17, terms 2/10, n/30.
		18			Borrowed $71,000 cash from First State Bank by signing a long-term note payable.
		20		(a)	Received payment from Nic Nelson for the April 11 sale less the discount.
		20		(b)	Purchased $1,180 of store supplies on credit from Hal’s Supply, invoice dated April 19, terms n/10 EOM.
		23		(a)	Received a $800 credit memorandum from Grant Company for the return of defective merchandise received on April 17.
		23		(b)	Received payment from Page Alistair for the April 13 sale less the discount.
		25			Purchased $11,360 of merchandise on credit from Noth Company, invoice dated April 24, terms 2/10, n/60.
		26			Issued Check No. 590 to Grant Company in payment of its April 17 invoice less the return and the discount.
		27		(a)	Sold $3,310 of merchandise on credit to Paula Kohr, Invoice No. 764 (cost is $2,530).
		27		(b)	Sold $6,400 of merchandise on credit to Nic Nelson, Invoice No. 765 (cost is $5,375).
		30		(a)	Issued Check No. 591, payable to Payroll, in payment of the sales salaries expense for the last half of the month, $9,000.
		30		(b)	Cash sales for the last half of the month are $72,200 (cost is $60,600).

Assume that Wiset Co. uses the perpetual inventory system.

2 & 3. Enter the March 31 balances for Cash ($90,000), Inventory ($153,000), Long-Term Notes Payable ($143,000), and B. Wiset, Capital ($100,000). Post the total amounts from the journal in the following general ledger accounts and in the accounts receivable subsidiary ledger accounts for Paula Kohr, Page Alistair, and Nic Nelson.

GENERAL LEDGER Cash Accounts Receivable Date Debit Credit Balance Date Debit Credit Balance Mar. 31 Inventory Long-Term Notes Payable Date Debit Credit Balance Date Debit Credit Balance Mar. 31 Mar. 31 B. Wiset, Capital Sales Date Debit Credit Balance Date Debit Credit Balance Mar. 31 Sales Discounts Cost of Goods Sold Date Debit Credit Balance Date Debit Credit Balance ACCOUNTS RECEIVABLE LEDGER Page Alistair Paula Kohr Date Debit Credit Balance Date Debit Credit Balance Nic Nelson Date Debit Credit Balance

Answer 1

To solve this question just input those variables which are to be used in logistic regression, as the question talks about using two variables only that is total loans and leases to total assets & total expenses/ total assets, so we will not input total cap/assets as an input variable in our excel, here we go

As one can see, we have taken only two variables , total exp/assets and total lns & leases/ assets in calculation, follwing steps have been followed to construct the above table

1. Assume logit= b0+ b1* independent variable1+ b2* independent variable 2 , take values of b0=0.1, b1=0.1, b2=0.1, note that these values of b0, b1 and b2 are just taken for calculation, one could assume any values here for bo , b1 and b2

2. Calculate exponential of logit in the next column by using exp (value in previous column)

3. Calculate probability by using formula, probability= exp (logit)/ { 1+ exp(logit)} in the next column

4. In next column, calculate log likelihood by using formula : financial condition value (i.e. 1 or 0) * LN( probability calculated in previous column) + (1- financial condition value)* LN( 1- probability calculated in previous column)

5. take the total of the column values of log likelihood

6. use solver function in excel to change this total by putting max value of 0 and changing the variable cells containing assumed values of b0, b1 and b2 , by clicking on solve, you will get actual values of b0, b1 and b2

which comes out to be b0=-14.72, b1=89.83, b2= 8.37

therefore you will get logit as

-14.72+ 89.83* Total exp/assets+8.37*Total lns & lsses/ assets

With values given in the question as total exp/ assets= 0.11 and total loans & leases/ assets= 0.6 , we get

logit as -14.72+ 89.83* 0.11+ 8.37*0.6= 0.1833

exp (logit) = 1.20

Probability= 0.546

Loglikelihood= 1*LN(0.546)+0*LN(1-0.546)= LN(0.546)= -0.605