Explore BrainMass
Share

# External funding needed (EFN)

Company A forecasts that sales next year will be \$5,600. If I assume long-term debt remains constant, what is the value for external funds needed (EFN)? I have the financial statement in for below:

Income statement

Sales
Cost of sales
Depreciation
Interest
Tax (35%) \$5,000
3,500
800
200
175
Net income
Dividends \$ 325
130

Balance sheet

Current assets
Net fixed assets \$ 850
3,275 Current liabilities
Long term debt
Equity \$ 320
1,330
2,475
Total \$4,125 \$4,125

As an extension, If I assume that Company A has sufficient excess capacity to support a sales level of \$5,300 with no new fixed assets, what would my EFN for projected sales of \$5,600 be?

Continuing the previous problem, Company A believes that an industry slowdown is possible over the next year. In this case, sales growth will be 4%. What is the EFN?

#### Solution Preview

EFN = Increase in assets - Increase in current liabilities (spontaneous) - Increase in retained earnings
Assets and current liabilities are supposed to increase in the same percentage as sales.
Percentage increase in sales is (5,600-5,000)/5,000 = 12%
Total assets = 4,125
Increase in assets = 4,125X12% = 495
Increase in current liabilities = 320X12% = 38.40
Current net income percentage = 325/5,000 = 6.5%
Payout ratio = ...

#### Solution Summary

The solution explains how to determine the amount of external funding needed (EFN).

\$2.19