Additional Funds Needed (AFN) Calculator
Calculate the Additional Funds Needed (AFN) for a company to support projected sales growth using the percent-of-sales forecasting method.
How to use this tool
- Enter spontaneous assets (a*), current sales (s₀), projected sales (s₁), spontaneous liabilities (l*), net profit margin (m) and dividend payout ratio (d) in the fields above.
- Results update instantly as you type — or click Calculate.
- Read your additional funds needed (afn) and the full breakdown beneath it.
⚠ This tool provides general estimates for education only and is not financial, tax or legal advice. Figures may not reflect your situation — verify with a qualified professional.
Formula
AFN = (A*/S₀)×ΔS − (L*/S₀)×ΔS − M×S₁×(1−d)
Where: A* = spontaneous assets, S₀ = current sales, ΔS = projected increase in sales, L* = spontaneous liabilities, M = net profit margin, S₁ = projected sales, d = dividend payout ratio.
How it works
The AFN (Additional Funds Needed) formula, also called External Financing Needed (EFN), uses the percent-of-sales method to estimate how much external capital a firm must raise to support a projected increase in sales. It assumes that spontaneous assets (e.g., receivables, inventory) and spontaneous liabilities (e.g., accounts payable, accruals) scale proportionally with sales. Internally generated retained earnings reduce the external funding requirement.
Worked example
Company Projecting 20% Sales Growth
- Change in sales: ΔS = $1,200,000 − $1,000,000 = $200,000
- Required asset increase: ($500,000 / $1,000,000) × $200,000 = $100,000
- Spontaneous financing increase: ($200,000 / $1,000,000) × $200,000 = $40,000
- Addition to retained earnings: 5% × $1,200,000 × (1 − 40%) = $36,000
- AFN = $100,000 − $40,000 − $36,000 = $24,000
AFN = $24,000 in external financing required
Common mistakes to avoid
- Treating all assets as spontaneous (tied to sales) when some are fixed — only assets that increase proportionally with sales (current assets, variable operating assets) belong in A*; fixed assets require a separate step-cost analysis.
- Forgetting to subtract spontaneous liabilities — accounts payable and accrued expenses rise automatically with sales and provide free financing; omitting L* from the formula overstates the additional funds needed.
- Using projected sales (S1) where the formula requires the change in sales (delta S) — the first two terms scale by delta S, not total S1; using S1 inflates the asset and liability requirements dramatically.
Key terms
- Spontaneous Assets
- Assets that rise automatically with sales, such as accounts receivable and inventory, without requiring a discrete financing decision.
- Spontaneous Liabilities
- Liabilities that increase automatically with sales, such as accounts payable and accrued wages, providing automatic financing.
- Percent-of-Sales Method
- A financial forecasting technique that assumes key balance sheet items remain a constant percentage of sales as the firm grows.
- Dividend Payout Ratio
- The proportion of net income paid out as dividends; the remainder (retention ratio = 1 − d) is added to retained earnings.
- External Financing Needed (EFN)
- Another name for AFN; the amount of funds that must be raised from external sources (debt or equity) to fund projected growth.
Frequently asked questions
- What does a negative AFN result mean?
- A negative AFN means the company generates more internal financing from retained earnings and spontaneous liabilities than it needs to support the projected sales increase. The surplus can be used to pay down debt, increase dividends, or build cash reserves.
- What is meant by the retention ratio (1-d) in the formula?
- The retention ratio is the share of net income reinvested in the business rather than paid as dividends. If a company pays out 40% of earnings as dividends, d = 0.40 and the retention ratio is 0.60. A higher retention ratio reduces AFN because more profit is available for internal financing.
- Is the AFN formula suitable for companies with non-linear cost structures?
- The percent-of-sales method assumes a linear relationship between sales and spontaneous assets/liabilities. Companies with significant economies of scale, step-fixed costs, or lumpy capital expenditures will find the AFN formula less accurate; a detailed pro-forma financial model is more appropriate in those cases.