EOC ROBLEMSGRADED Q Search this course 93 Forecasting Operat

EOC ROBLEMS-GRADED Q Search this course 9-3: Forecasting Operations Prob Problem 9-5 o Long-Term Financing Needed At year-end 2015, Wallace Landscaping\'s total assets were $1.3 million and its accounts payable were $365,000. Sales, which in 2015 were $2.0 million, are expected to increase by 20% in 2016. Total assets and accounts payable are proportional to sales, and that relationship wl, be martined. Walae typically use maret laban\" other than accounts payable. Common stock amounted to $365,000 in 2015, and retained earnings were $300,000. Wallace has arranged to sell $125,000 of new common stock in 2016 to meet some of its financing needs. The remainder of its financing needs will be met by issuing new long-term delst at the end of 2016. (Because the debt is added at the end of the year, there will be no additional interest expense due to the new debt.) Its net profit margin on dividends. a. What was Wallace\'s total long-term debt in 20157 Round your answer to the nearest doilar $2700oc What were Wallace\'s total liabilities in 2015? Round your answer to the nearest dollar. $6350or b. How much new long-term debt financing will be needed in 2016? (Mint: AFN-New stock New long-term debt.) Round your answer to the nearest dolar. Do not round intermediate calculations. $35920c Hide Feedback Partially Correet Check My Work (No more tries avaiable)

Solution

At year-end 2015, Wallace Landscaping’s total assets were $1.3 million and its accounts payable were $365,000. Sales, which in 2016 were $2.0 million, are expected to increase by 20% in 2016. Total Assets and accounts payable are proportional to sales, and that relationship will be maintained. Wallace typically uses no current liabilities other than accounts payable. Common stock amounted to $365,000 in 2015, and retained earnings were $300,000. Wallace has arranged to sell $125,000 of new common stock in 2016 to meet some of its financing needs. The remainder of its financing needs will be met by issuing new long-term debt at the end of 2016. (Because the debt is added at the end of the year, there will be no additional interest expense due to the new debt.) Its net profit margin on sales is 6%, and 60% of earnings will be paid out as dividends.

28

What were Wallace’s total long-term debt and total liabilities in 2015?

Balance Sheet as of December 31, 2015

Total Assets $1,300,000.00

Accounts Payable $365,000

Total Current Liabilities $365,000

Long-term debt $270,000

Total Liabilities $635,000

Common Stock $365,000

Retained Earnings $300,000

Total Common Equity $665,000

Total Liabilities & Equity $1,300,000

Income Statement for December 31, 2015

Sales $2,400,000

The total assets must equal the total liabilities and equity. Accounts payable of $365,000 is the only current liabilities. It is understandable that Wallace has a long-term debt as it is planning to issue new long-term debt at the end of 2016. The total liabilities should include the long-term debt and the total current liabilities.

Total Assets = Total Liabilities & Equity

Answer: Total long-term debt in 2016 = $900,000; Total Liabilities in 2016 = $1,255,000

a. Compute for the total liabilities:

Total liabilities = Total Liabilities & Equity ? Total Common Equity

= $1,300,000 ? $665,000

= $635,000

Total Liabilities = $635,000

b. Computing for total long-term debt:

Total long term debt = Total liabilities ? Total current liabilities

= $635,000 ? $365,000

Total long-term debt = $270000

b. How much new long-term debt financing will be needed in 2016?

AFN = (A*/S0)?S - (L*/S0)?S – PM*S1*(1 - d)

= (1,300,000/2,000,000)*$400,000 – (365,000/2,000,000)*$400,000 - 0.06($2,400,000)(1 - 0.6)

= (0.65)($400,000) - (0.1825)($400,000) - ($144,000)(0.4)

= $260,000 - $73,000 - $57,600

= $129,400.

New long-term debt = AFN- NEW STOCK

= $129,400-$125,000

= $4,400