Additional Funds Needed (AFN) Calculator
The Additional Funds Needed (AFN) calculator estimates how much external financing a business must raise to support a planned sales increase. Enter your current and projected sales, the assets and liabilities that move with revenue, your expected profit margin, and your dividend payout ratio. The calculator applies the standard AFN equation from corporate finance, breaks down each component, and shows a funding gap chart so you can see exactly where the shortfall or surplus comes from.
Formula
Worked example
A company with $5 M in current sales projects $6.5 M next year. Spontaneous assets are $3.5 M, spontaneous liabilities $700 K, profit margin 8%, payout ratio 30%. Capital intensity ratio = 3.5 / 5 = 0.70. Asset increase = 0.70 x $1.5 M = $1.05 M. Liability increase = (0.7 / 5) x $1.5 M = $210 K. Net income = 8% x $6.5 M = $520 K. Retained earnings = $520 K x 70% = $364 K. AFN = $1,050,000 - $210,000 - $364,000 = $476,000.
What is Additional Funds Needed (AFN)?
Additional Funds Needed (AFN) is the amount of external capital a company must raise to support a planned increase in sales. When a business grows, its assets - cash, receivables, inventory - must grow with it. Part of that growth is financed automatically: suppliers extend more credit as purchases rise, and accrued wages and taxes also increase with output. Part is funded internally by the net income the business retains after paying dividends. Whatever asset growth is not covered by those two spontaneous sources is the AFN: the gap that must be filled by borrowing or issuing equity. A positive AFN means the company must go to capital markets; a negative AFN means internal cash generation exceeds the growth it needs to fund, leaving a surplus to deploy or return to shareholders.
The AFN equation and its components
The standard textbook formula is: AFN = (A*/S0) x dS - (L*/S0) x dS - M x S1 x RR. The capital intensity ratio A*/S0 measures how many dollars in spontaneous assets are required per dollar of current sales - a high ratio signals an asset-heavy business where growth is expensive to fund. L*/S0 is the spontaneous liabilities ratio: accounts payable and accruals that rise automatically with volume. dS is the absolute increase in sales (S1 - S0). M is the net profit margin applied to projected sales to get projected net income. RR is the retention ratio (1 minus the dividend payout ratio), the fraction of profit kept in the business. Multiplying projected net income by RR gives the incremental retained earnings that reduce the financing gap.
How to use this calculator
Enter your current sales and the sales you plan to achieve. For spontaneous assets, include all current assets that scale with revenue: cash balances you must maintain, trade receivables at your normal collection days, and inventory at your typical turnover ratio. Exclude fixed assets with spare capacity - only assets that will actually grow with the planned sales increase belong here. For spontaneous liabilities, include accounts payable to suppliers, accrued wages, and accrued taxes; exclude all debt that requires a conscious financing decision. Enter the profit margin you expect on projected sales and the fraction you intend to pay out as dividends. The calculator returns the AFN, breaks down each component, and charts how the financing gap changes across a range of growth rates so you can stress-test the plan.
Interpreting your result and common strategies
A positive AFN requires a financing decision before growth can proceed: options include a bank term loan, a revolving credit facility, a bond issuance, or equity capital from investors. Compare the after-tax cost of debt against the dilution cost of equity, and consider the resulting leverage ratio. A negative AFN is a surplus signal - the company is internally generating more cash than the growth plan consumes, which is typically a sign of high margins, low capital intensity, or slow planned growth. Managers can use the surplus to repay debt, increase dividends, or accelerate growth further. Several levers directly cut AFN: improving the profit margin raises retained earnings per dollar of sales; cutting the dividend payout ratio redirects more earnings back into the business; negotiating longer payment terms with suppliers increases spontaneous liabilities and reduces the gap; and stretching receivable collection or tightening inventory reduces the asset-to-sales ratio.
AFN sensitivity: effect of key drivers
| Driver | Change | Effect on AFN | Why |
|---|---|---|---|
| Profit margin (M) | Increases | Falls | More net income - more retained earnings |
| Dividend payout ratio | Increases | Rises | Less earnings retained internally |
| Capital intensity (A*/S0) | Increases | Rises | More assets required per dollar of growth |
| Spontaneous liabilities (L*/S0) | Increases | Falls | More automatic financing from suppliers |
| Sales growth rate | Increases | Usually rises | Asset needs grow faster than retained earnings |
| Retention ratio (RR) | Increases | Falls | More profit ploughed back into the business |
How changing each variable by a moderate amount affects the direction of AFN, holding all others constant.
Frequently asked questions
What does a negative AFN mean?
A negative AFN means the company will generate more funds internally - through retained earnings and spontaneous liabilities - than it needs to finance its planned asset growth. In other words, the business is self-funding its expansion and will have surplus cash left over. This surplus can be returned to shareholders as special dividends, used to repay existing debt, invested in opportunities beyond the base plan, or held as a liquidity buffer.
What are spontaneous assets and liabilities?
Spontaneous assets are those that grow proportionally with sales without a specific management decision - primarily cash, accounts receivable, and inventory. Spontaneous liabilities are obligations that rise automatically when production and purchasing increase - mainly accounts payable, accrued wages, and accrued taxes. Both are expressed as a ratio to current sales (their "ratio to sales") and then multiplied by the planned increase in sales to estimate how much they will change. Bank loans, bonds, and equity are not spontaneous because they require an explicit financing decision.
Does AFN assume the company is operating at full capacity?
Yes, the basic AFN formula assumes that all spontaneous assets are already at full utilization, so any sales increase requires a proportional asset increase. If the company has excess capacity in property, plant, or equipment, those fixed assets will not need to grow and the required asset increase - and therefore the AFN - will be smaller. In that case, use only the truly constrained assets in the A* figure and exclude capacity that can absorb growth without new investment.
How is AFN different from a cash flow forecast?
AFN is a top-down planning shortcut that uses ratios to estimate the financing gap for a single future period - typically one year - without building a full financial model. A detailed cash flow forecast models individual cash receipts and disbursements period by period and is far more precise. AFN is best used in early-stage planning to size the financing need quickly and identify the biggest levers before committing to a detailed model.
What profit margin should I use in the formula?
Use the net profit margin you expect on your projected sales figure - that is, net income after tax and interest divided by projected revenue. If your margin is expected to change as you scale (for example, because fixed costs spread over a larger base), use the forward-looking margin rather than the historical one. A margin that is too optimistic will understate AFN and can lead to an underfunded growth plan.
Can AFN be used for multi-year planning?
The basic formula covers one planning period. For multi-year projections, apply it year by year, updating S0 to the prior year projected sales and recalculating the ratios if the balance-sheet structure changes. Note that AFN raised in one year often has its own interest or dividend cost, which affects the profit margin in subsequent years - a refinement called the "circular" or "iterative" AFN approach that is best handled in a full financial model.