4-9A (Financial forecasting-discretionary financing needed) The most recent bala
ID: 2757025 • Letter: 4
Question
4-9A (Financial forecasting-discretionary financing needed) The most recent balance sheet for the Armadillo Dog Biscuit Co. is shown in the following table. The company is about to embark on an advertising campaign, which is expected to raise sales from the current level of $5 million to $7 million by the end of next year. The firm is currently operating at full capacity and will have to increase its investment in both current and fixed assets to support the projected level of new sales. In fact, the firm estimates that both categories of assets will rise in direct proportion to the projected increase in sales.
Armadillo Dog Biscuit Co., Inc. ($ millions)
PRESENT LEVEL PERCENT OF SALES PROJECTED LEVEL
Current assets $2.0 ? % $ ?
Net fixed assets 3.0
• Total $5.0
Accounts payable $0.5
Accrued expenses 0.5
Notes payable – 0
• Current liabilities $1.0
Long-term debt $2.0
Common stock 0.5
Retained earnings 1.5
Common equity $2.0
• Total $5.0
The firm’s net profits were 6 percent of current year’s sales but are expected to rise to 7 percent of next year’s sales. To help support its anticipated growth in asset needs next year, the firm has suspended plans to pay cash dividends to its stockholders. In past years, a $1.50 per share dividend has been paid annually.
Armadillo’s payables and accrued expenses are expected to vary directly with sales. In addition, notes payable will be used to supply the funds that are needed to finance next year’s operations and that are not forthcoming from other sources.
1. Fill in the table and project the firm’s needs for discretionary financing. Use notes payable as the balancing entry for future discretionary financing needed.
2. Compare Armadillo’s current ratio and debt ratio (total liabilities/total assets) before the growth in sales and after. What was the effect of the expanded sales on these two dimensions of Armadillo’s financial condition?
3. What difference, if any, would have resulted if Armadillo’s sales had risen to $6 million in one year and $7 million only after two years? Discuss only; no calculations are required.
Explanation / Answer
Present Sales 5 Projected Sales 7 Armadillo Dog Biscuit Co., Inc. ($ millions) 1) PRESENT LEVEL PERCENT OF SALES PROJECTED LEVEL= PERCENT OF SALES*7 million(for Assets&Current Liabs) Current assets 2 40.00% 2.8 Net fixed assets 3 60.00% 4.2 • Total 5 100.00% 7 Accounts payable 0.5 10.00% 0.7 Accrued expenses 0.5 10.00% 0.7 Notes payable – 0 0.00% 1.11 • Current liabilities 1 20.00% 2.51 Long-term debt 2 40.00% 2 LT Debt and Common stock remains same Common stock 0.5 10.00% 0.5 As only source of financing is notes payable Retained earnings 1.5 30.00% 1.99 (=1.5+7*0.07),Addn to RE=7%*Projected Sales Common equity 2 40.00% 2.49 whole of earnings of 7*.07 is retained • Total 5 100.00% 7 Additional Funds(AFN) 1.11 AFN=Total Assets Projected-Total Liabs&Equity Projected (AFN=7-5.59=$1.11 million) 2) Curent ratio 2 1.12 (Current Assets/Current Liabilities) Debt ratio 60.00% 64.43% (total liabilities/total assets) The Current ratio has decreased while the Debt ratio has increased due to increased financing needed,is the effect of the expanded sales. 3)The additional financing required would have reduced due to decrease in the asssets required with reduced sales as assets increase in proportion to sales. The current ratio would have reduced due to need of additional financing and Debt ratio would also have reduced.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.