AFN Calculator (Additional Funds Needed)
Calculate Additional Funds Needed for revenue growth from sales-to-asset ratios, profit margin, and retention.
Standard corporate finance forecasting tool.
AFN tells you how much new capital a company needs to fund a sales increase. Growing the top line means more inventory, more receivables, more equipment — and that does not come free. The AFN formula spits out how much external financing you have to raise on top of what retained earnings provide.
The formula:
AFN = (A/S) × ΔS - (L/S) × ΔS - PM × S₁ × b
Where:
- A/S = Total assets / current sales (the assets-to-sales ratio)
- L/S = Spontaneous liabilities (accounts payable, accrued expenses) / current sales
- ΔS = Change in sales (S₁ - S₀)
- PM = Net profit margin
- S₁ = Forecast sales next period
- b = Retention ratio (1 - dividend payout ratio)
Reading each piece.
- (A/S) × ΔS is the asset growth required. If you currently use $0.80 of assets for every $1 of sales, growing sales by $10M needs $8M of new assets.
- (L/S) × ΔS is the spontaneous financing — payables and accruals that grow naturally with sales without you raising debt. Subtract because it is “free.”
- PM × S₁ × b is the retained earnings the company will generate from next period’s sales. Subtract because that is internal funding.
Result interpretation.
- AFN positive: external financing required. The bigger the number, the larger the bond issuance, equity raise, or credit-line draw needed.
- AFN negative: internal funding exceeds growth needs. The company throws off more cash than the growth absorbs — a “self-funding” growth profile, characteristic of low-asset-intensity businesses.
Where the formula falls down.
- Assumes asset/liability ratios stay constant. Fine for short-term forecasting; bad for businesses entering a new asset-intensity regime (e.g., adding a factory).
- Assumes spontaneous liabilities grow proportionally. Some businesses have lumpy payable cycles.
- Does not account for capacity utilization. If existing assets are at 60% utilization, you can grow without buying more — AFN over-estimates need.
- Long-term forecasting needs full pro-forma financials, not just AFN.
Worked example. A retailer:
- Current sales: $100M, projected $130M (ΔS = $30M)
- Total assets: $80M (A/S = 0.80)
- Spontaneous liabilities: $20M (L/S = 0.20)
- Profit margin: 5%
- Retention ratio: 60% (40% paid as dividends)
AFN = (0.80 × 30M) - (0.20 × 30M) - (0.05 × 130M × 0.60) AFN = 24M - 6M - 3.9M = $14.1M needed externally
That $14.1M will come from new debt, equity, or some combo — and the CFO has to plan for it before the growth happens, not after.
The high-PM, low-asset-intensity dream. Software firms with PM of 25% and A/S of 0.20 often produce negative AFN at any growth rate — they fund themselves entirely from earnings. That is why SaaS valuation multiples are higher than industrial multiples on the same revenue.