Finance

AFN Calculator (Additional Funds Needed)

Estimate external financing needed to support sales growth using the percent-of-sales method.

% of earnings retained (not paid as dividends)
AFN Formula:
AFN = (A*/S₀)×ΔS − (L*/S₀)×ΔS − PM×S₁×b
Where A* = assets tied to sales, L* = spontaneous liabilities
ΔS = S₁ − S₀, PM = profit margin, b = retention ratio

Most early-stage business failures aren't caused by bad products — they're caused by growing faster than the balance sheet can fund. A 25% sales increase often requires a 25% bigger inventory pile, a 25% larger receivables book, and the wages to produce all of it, paid before the new revenue is collected. The AFN equation is the back-of-the-envelope tool the CFO should run before the CEO calls the bank.

Three pieces of the AFN equation

Strip away the textbook notation and the formula is simply: what new assets do I need, minus what grows for free, minus what I'll earn along the way.

  • Required asset increase: (Assets / Current Sales) × Δ Sales. Captures the receivables, inventory, and operating capital that has to grow.
  • Spontaneous liability increase: (Spontaneous Liabilities / Current Sales) × Δ Sales. Captures accounts payable and accrued wages that grow automatically as activity scales.
  • Retained earnings: Profit Margin × Projected Sales × Retention Ratio. Internal financing from operations, after dividends.

Walkthrough: a $10M business planning 20% growth

  • S₀ = $10M, S₁ = $12M, ΔS = $2M (20%)
  • Asset intensity = 5.0M / 10.0M = 50% → asset increase = $1.0M
  • Spontaneous liability ratio = 1.5M / 10.0M = 15% → liability increase = $0.3M
  • Retained earnings = 8% × $12M × 60% = $0.576M
  • AFN = $1.0M − $0.3M − $0.576M = $124K

That $124K is the gap the business has to close — either a draw on a working-capital line of credit, a small equipment loan, or by tightening collections to shrink the asset side.

The sustainable growth rate: AFN's twin

If you set AFN = 0 and solve for growth, you get the sustainable growth rate (SGR) — the pace at which the business can grow without raising new external capital or changing dividend policy. The Higgins shortcut: SGR ≈ ROE × b. A 15% ROE with 60% retention sustains roughly 9% growth indefinitely. Anything faster requires either tapping the credit markets or accepting changes to leverage.

Five levers that shrink AFN

  1. Tighten DSO. Every day shaved off receivables permanently reduces required assets.
  2. Increase inventory turns. JIT, ABC analysis, or SKU rationalization reduces asset intensity.
  3. Negotiate longer payables. Higher spontaneous liabilities = lower AFN.
  4. Raise profit margin. Even 100 bps of margin improvement multiplied by sales is real internal capital.
  5. Lower the dividend (raise b). Plowing more profit back is the cheapest financing available.

Where the AFN model breaks down

The percent-of-sales assumption holds only when asset utilization is roughly linear. Three classic exceptions:

  • Excess capacity. If the factory is running at 70%, scaling to 90% needs no new PP&E — true asset intensity is much lower than the balance sheet ratio.
  • Lumpy CapEx. If growth crosses a capacity threshold, you suddenly need a whole new plant. Marginal AFN spikes, then drops.
  • Margin compression at scale. Volume discounts you offer to win the next $2M of revenue may push margin down — AFN gets bigger than the linear model predicts.

For each of these cases, layer scenario analysis on top of the AFN baseline rather than treating the equation output as gospel.

FAQ

Should every line on the balance sheet vary with sales?

No — long-term debt, paid-in capital, and most fixed assets above current capacity don't. Restrict A* and L* to current operating assets and spontaneous current liabilities.

Can AFN be negative?

Yes — when retained earnings plus spontaneous liability growth exceed required asset growth. That's a sign the business is generating surplus cash and can pay down debt, buy back stock, or raise the dividend.

How does AFN differ from a full 3-statement model?

AFN is a single equation; a 3-statement model projects income statement, balance sheet, and cash flow line-by-line with feedback loops. Use AFN to size the order of magnitude, then build the detailed model to commit to a financing plan.

Does AFN account for working capital seasonality?

Not by default. For seasonal businesses, run AFN at the peak working-capital month — the financing facility has to cover the trough-to-peak swing, not the annual average.

Does AFN tell me debt vs equity?

No — it tells you the total external financing required. The debt-vs-equity split depends on your target capital structure and what the markets will give you.

What if my retention ratio is 100%?

You'll minimize AFN, but you'll also disappoint income-oriented investors. The right b depends on stage: high-growth firms run 90-100%, mature dividend payers run 30-50%.

Related calculators

Sources

Educational only; not financial advice. Reviewed by Ellen Karuthers, MBA, on March 1, 2026.