Question

On January 1, 2021, the general ledger of Parts Unlimited includes the following account balances:

Accounts	Debit			Credit
Cash	$	176,400
Accounts Receivable		26,400
Inventory		51,800
Land		354,000
Equipment		380,500
Accumulated depreciation				$	186,000
Accounts Payable					28,800
Common stock					534,000
Retained Earnings					240,300
Totals	$	989,100		$	989,100

From January 1 to December 31, the following summary transactions occurred:

1. Purchased inventory on account, $339,800.
2. Sold inventory on account, $621,200. The inventory cost $356,600.
3. Received cash from customers on account, $572,700.
4. Paid cash on account, $342,500.
5. Paid cash for salaries, $108,700, and for utilities, $66,700.

In addition, Parts Unlimited had the following transactions during the year:

April		1		Purchased equipment for $109,000 using a note payable, due in 12 months plus 8% interest. The company also paid cash of $4,600 for freight and $5,200 for installation and testing of the equipment. The equipment has an estimated residual value of $16,800 and a ten-year service life.
June		30		Purchased a patent for $54,000 from a third-party marketing company related to the packaging of the company’s products. The patent has a 20-year useful life, after which it is expected to have no value.
October		1		Sold equipment for $45,600. The equipment cost $74,700 and had accumulated depreciation of $51,400 at the beginning of the year. Additional depreciation for 2021 up to the point of the sale is $9,900. (Hint: Total accumulated depreciation equals the amount at the beginning of the year plus the amount recorded for the current year.)
November		15		Several older pieces of equipment were improved by replacing major components at a cost of $68,100. These improvements are expected to enhance the equipment’s operating capabilities. [Record this transaction using Alternative 2—capitalization of new cost.]

Year-end adjusting entries:

1. Depreciation on the equipment purchased on April 1, 2021, calculated using the straight-line method.
2. Depreciation on the remaining equipment, $35,500.
3. Amortization of the patent purchased on June 30, 2021, using the straight-line method.
4. Accrued interest payable on the note payable.
5. Equipment with an original cost of $80,800 had the following related information at the end of the year: accumulated depreciation of $51,500, expected cash flows of $29,700, and a fair value of $17,800.
6. Accrued income taxes at the end of the year are $26,600.

1.Record each of the transactions listed above in the ‘General Journal’ tab (these are shown as items 1–11) assuming a perpetual FIFO inventory system. Review the ‘General Ledger’ and the ‘Trial Balance’ tabs to see the effect of the transactions on the account balances.

2. Record adjusting entries on December 31 in the ‘General Journal’ tab (these are shown as items 12–17).

3. Review the adjusted ‘Trial Balance’ as of December 31, 2021, in the ‘Trial Balance’ tab.

4. Prepare a multiple-step income statement for the period ended December 31, 2021, in the ‘Income Statement’ tab.

5. Prepare a classified balance sheet as of December 31, 2021, in the ‘Balance Sheet’ tab.

6. Record closing entries in the ‘General Journal’ tab (these are shown as items 18–19).

7. Using the information from the requirements above, complete the ‘Analysis’ tab.1.

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