Additional Funds Needed Calculator
A percent-of-sales estimate for one forecast year
Additional Funds Needed Calculator
On this page
What is additional funds needed?
Additional funds needed (AFN) is the modeled financing gap for a sales forecast. A positive result means the modeled asset increase exceeds growth in spontaneous liabilities and retained earnings. A negative result is a modeled financing surplus, not an error or a promise that cash will be available when needed.
How to use the calculator
- Enter current annual sales and the assets required to support those sales. Include sales-linked operating current and fixed assets; exclude assets that will not change with sales.
- Enter only spontaneous liabilities that rise with sales, such as trade payables and accrued expenses. Do not enter all current liabilities or notes payable.
- Enter expected annual sales growth, net profit margin, and the share of profit retained. Enter zero explicitly where it applies.
- Read the asset increase, spontaneous-liability increase, retained earnings, and signed AFN together.
Formula and worked examples
Forecast sales S₁ = S₀ + ΔS. AFN = (A*/S₀) × ΔS − (L*/S₀) × ΔS − M × S₁ × RR. A* is the asset base required for current sales; L* is spontaneous liabilities at current sales; M is forecast net profit margin; RR is the retained share of net income.
For current sales of $1,000,000, sales-linked assets of $500,000, spontaneous liabilities of $200,000, 10% growth, 15% margin, and 60% retention: forecast sales are $1,100,000; assets rise $50,000; liabilities rise $20,000; retained earnings add $99,000. Signed AFN is −$69,000, a modeled surplus.
With the same sales, assets, and liabilities, 20% growth, 5% margin, and 20% retention, the terms are $100,000 − $40,000 − $12,000 = $48,000 modeled external financing need.
If sales growth is zero but the margin and retention remain positive, asset and liability increases are zero while retained earnings can still make AFN negative. That follows the formula; it does not imply immediate spare cash.
Assumptions and limits
This shortcut assumes the entered assets are needed at full capacity and assets and spontaneous liabilities scale linearly with sales. It also assumes a constant forecast net margin and retention ratio. Non-spontaneous debt and equity are financing choices after estimating AFN, so the calculator does not prescribe a debt/equity split.
AFN is a period estimate, not a timed cash-flow forecast. Seasonality, capacity changes, interest on new financing, differing account growth rates, and cash collection/payment timing can change the amount or when funding is needed. Use a detailed forecast for those questions.
This educational estimate is not financial or accounting advice for a specific business.
Questions and sources
Does a negative AFN mean I can distribute the surplus?
No. It says the simplified financing terms exceed the modeled asset increase for the forecast period. Check cash timing, obligations, and your full forecast before making a financing or payout decision.
Why exclude notes payable from spontaneous liabilities?
Notes payable are a financing decision, while trade payables and accruals may rise with sales without a separate financing decision.
Related tool: Operating Asset Turnover Calculator can help compare the sales-to-operating-assets relationship. Its scope may differ from the A* asset base used here.
Method: University of Nebraska–Lincoln, Financial Planning and Forecasting Financial Statements, Chapter 12, slides 12-6–12-15 (publication date not stated; example balance sheet labeled 2002; accessed September 29, 2026). Cash timing: OpenStax, Principles of Finance §18.5 (published March 24, 2022; accessed September 29, 2026).