The Manning Company has financial statements as shown next, which are representa
ID: 2813673 • Letter: T
Question
The Manning Company has financial statements as shown next, which are representative of the company’s historical average.
The firm is expecting a 40 percent increase in sales next year, and management is concerned about the company’s need for external funds. The increase in sales is expected to be carried out without any expansion of fixed assets, but rather through more efficient asset utilization in the existing store. Among liabilities, only current liabilities vary directly with sales.
Using the percent-of-sales method, determine whether the company has external financing needs, or a surplus of funds. (Hint: A profit margin and payout ratio must be found from the income statement.) (Do not round intermediate calculations.)
Income Statement Sales $ 270,000 Expenses 203,400 Earnings before interest and taxes $ 66,600 Interest 7,700 Earnings before taxes $ 58,900 Taxes 15,700 Earnings after taxes $ 43,200 Dividends $ 17,280Explanation / Answer
Profit Margin Ratio
= [Net profit After Tax / Sales] x 100
= [$43,200 / 270,000] x 100
= 16%
Dividend Payout Ratio
= [Dividend Paid / Net Profit After Tax] x 100
= [$17,280 / 43,200] x 100
= 40%
Current Sales = $270,000
Expected New Sales = $270,000 x 1.40 = $378,000
Changes in sales = $378,000 – 270,000 = $108,000
External Financing Needed [EFN]
External Financing Needed [EFN] = [(Current Assets/Sales)x Changes in Sales] - [(Current Liabilities/Sales)x Changes in Sales] – [(New SalesxProfit Margin) x (1-Dividend payout]
= [($148,500/270,000)x108,000] - [($35,100/270,000)x108,000] - [($378,000 x 0.16) x (1-0.40)]
= $59,400 – 14,040 – 36,288
= $9,072
“ Hence, The External Financing Needed [EFN] = $9,072”
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.