Companies can estimate their need for external financing by forecasting future sales and related expenses. There are various techniques which are used to estimate or forecast the finance requirements.
The Percent-of-Sales method for Financial forecasting
The basic steps in projecting a company’s financing needs are:
- Project the company’s sales. The sales forecast is the basis for most other forecasts.
- Project additional variables, such as expenses.
- Estimate the level of investment in current and fixed assets the company will need to make to support the projected sales.
- Calculate the company’s financing needs.
An example for Percent-of-Sales
- Assume that sales for 20X1 are $20, projected sales for 20X2 are $24, net income is 5 percent of sales and the dividend payout ratio is 40%.
- Express those balance sheet items that vary directly with sales as a percentage of sales. Any item such as long-term debt that does not vary directly with sales is designated not applicable.
- Multiply these percentages by the 20X2 projected sales ($24) to obtain the projected amounts.
- Insert figures in the long-term debt, common stock and paid-in capital from 20X1 balance sheet.
- Compute 20X2 retained earnings.
Although one can forecast the additional funds required by setting up a pro forma balance sheet, it is often easier to use the formula.
External Funds Needed = Required increase in Assets – Spontaneous increase in Liabilities – Increase in retained earnings
EFN = (A/S) ΔS – (L/S) ΔS – (PM)(PS)(1-d) where
A/S = Assets that increase spontaneously with sales as a percentage of sales
L/S = Liabilities that increase spontaneously with sales as a percentage of sales
ΔS = Change in sales
PM = Profit margin on sales
PS = Projected sales
d = Dividend payout ratio
In the above example
A/S = $6/$20 = 30%
L/S = $2/$20 = 10%
ΔS = ($24 – $20) = $4
PM = 5% on sales
PS = $24
d = 40%
Substituting the above figures into the formula yields:
EFN = 0.3($4) – 0.1($4) – (0.05)($24)(1 – 0.4)
= $1.2 - $0.4 - $0.72
For more details you can visit our website at http://www.helpwithassignment.com/finance-assignment-help and http://www.helpwiththesis.com