A firm has the following balance sheet:
Cash $ 20 Accounts payable $ 20
Accounts receivable 20 Notes payable 40
Inventory 20 Long-term debt 80
Fixed assets 180 Common stock 80
Retained earnings 20
Total assets $240 Total liabilities & Equity $240
Sales for the year just ended were $400, and fixed assets were used at 80 percent of capacity. Current assets and accounts payable vary directly with sales. Sales are expected to grow by 5 percent next year, the expected net profit margin is 5 percent, and the dividend payout ratio is 60 percent.
How much additional funds (AFN) will be needed next year, if any?© BrainMass Inc. brainmass.com June 3, 2020, 8:40 pm ad1c9bdddf
How much additional funds (AFN) will be needed next year, if any?
Revenue 400.00 420.00
Net Income 20.00 21.00 (5% of Sales)
Dividends 12.00 12.60 (60% of Dividends)
Retained Earnings 8.00 8.40
Current Assets 60.00 63.00
Fixed Assets 180.00 180.00
This solution calculates the retained earnings, external funds required and the new level of debt with step-by-step calculations enclosed in an Excel file. Brief calculations are included for further understanding.