Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

At year-end 2016, total assets for Arrington Inc. were $1.5 million and accounts

ID: 1170187 • Letter: A

Question

At year-end 2016, total assets for Arrington Inc. were $1.5 million and accounts payable were $305,000. Sales, which in 2016 were $2.1 million, are expected to increase by 30% in 2017. Total assets and accounts payable are proportional to sales, and that relationship will be maintained; that is, they will grow at the same rate as sales. Arrington typically uses no current liabilities other than accounts payable. Common stock amounted to $365,000 in 2016, and retained earnings were $320,000. Arrington plans to sell new common stock in the amount of $140,000. The firm's profit margin on sales is 4%; 65% of earnings will be retained.

What were Arrington's total liabilities in 2016? Write out your answer completely. For example, 25 million should be entered as 25,000,000. Round your answer to the nearest cent.
$

How much new long-term debt financing will be needed in 2017? Write out your answer completely. For example, 25 million should be entered as 25,000,000. Do not round your intermediate calculations. Round your answer to the nearest cent. (Hint: AFN - New stock = New long-term debt.)
$

Explanation / Answer

Calculation of long term liability
=Total asset-Current liability-Common stock-Retained earnings
=15,00,000-305000-365000-320000
=5,10,000

Total liabilities of 2016=5,10,000+305000=815000


Long-term debt financing will be needed in 2017= AFN- New stock

Calculation of AFN

AFN=
A0* percentage increase in sales(-)L0* percentage increase in sales(-)S1*PM*b
Where,

A o = current level of assets
Lo = current level of liabilities
S1 = new level of sales
PM = profit margin
b = retention rate = 1 – payout rate

AFN=15,00,000*.30(-)815000*.30(-)2730,000*.04*.65
=450,000-244500-70980
=134520

Long-term debt financing will be needed in 2017
=134520-140,000
=-5480