Additional Funds Needed (AFN) Calculator
From assets, sales, spontaneous liabilities and retained earnings, estimate the external funding a company must raise to support growing sales.
Input Data
Results
At a glance:Additional Funds Needed (AFN) estimates the external funding a company must raise, after subtracting spontaneous liabilities and retained earnings from the extra assets needed to support growing sales. A positive AFN means a funding gap requiring external financing; a negative AFN means internal financing is sufficient.
Formula
AFN = (current assets ÷ current sales) × sales increase − (spontaneous liabilities ÷ current sales) × sales increase − net margin × projected sales × retention ratio.
$$AFN = \dfrac{A}{S}\Delta S - \dfrac{L}{S}\Delta S - M \times S_1 \times b$$$$A/S=\text{asset-to-sales ratio},\ L/S=\text{spontaneous-liability-to-sales ratio},\ \Delta S=\text{sales increase},\ M=\text{net margin},\ S_1=\text{projected sales},\ b=\text{retention ratio}$$How to Use
- Enter current assets, current sales and spontaneous liabilities.
- Enter the expected sales increase, net margin, projected sales and retention ratio.
- Read the additional external funding required.
AFN at assets HK$500,000, current sales HK$1,000,000, spontaneous liabilities HK$100,000, net margin 5%, retention 0.6, under different sales increases
| Sales increase | Projected sales | Additional funds needed (AFN) | Read |
|---|---|---|---|
| HK$100,000 | HK$1,100,000 | HK$7,000 | Small expansion, tiny gap |
| HK$200,000 | HK$1,200,000 | HK$44,000 | This tool's default |
| HK$400,000 | HK$1,400,000 | HK$118,000 | Bigger expansion, more external funding |
Case Studies
Case 1: Funding needed for expansion
A company has assets HK$500,000, current sales HK$1,000,000, spontaneous liabilities HK$100,000, expects sales to grow HK$200,000 to HK$1,200,000, net margin 5%, retention 0.6.
AFN = 0.5 × 200,000 − 0.1 × 200,000 − 5% × 1,200,000 × 0.6 = 100,000 − 20,000 − 36,000 = HK$44,000. About HK$44k must be raised externally (loan or equity) before expansion.
Case 2: Higher dividend vs higher retention
Continuing the example, raising retention from 0.6 to 1.0 (all retained, no dividend) increases internal financing: AFN = 100,000 − 20,000 − 5% × 1,200,000 × 1.0 = HK$20,000.
Lowering retention to 0.3 (more dividend) raises AFN to HK$62,000. Dividend policy directly affects the funding gap — fast-growing firms often cut dividends to self-fund and ease external financing pressure.
FAQ
What does a negative AFN mean?
It means you need no external funding and internal financing even has a surplus. Of the three components, the first is the 'funding need' from sales growth; the latter two (spontaneous liabilities, retained earnings) are 'naturally generated financing'. When the latter two exceed the first, AFN is negative — the company's growth is already covered by rising payables plus retained earnings, with extra cash for debt repayment, dividends or investment. This usually signals a healthy, profitable business. A large positive AFN means external financing must be arranged before expansion, or the company risks a cash crunch.
What are 'spontaneous liabilities' and why do they reduce the need?
Spontaneous liabilities grow 'naturally' with day-to-day operations and sales, without special arrangement — typically accounts payable (unpaid supplier bills) and accruals (incurred-but-unpaid wages, tax). As sales grow, more purchasing means higher payables, which is like an interest-free short-term loan from suppliers, deferring cash outflow. In the AFN formula, this spontaneous increase offsets part of the new asset need, lowering external funding. Note: actively arranged financing like bank overdrafts or long-term loans is NOT spontaneous.
What are the limits of the AFN model?
Its main limitation is assuming assets grow linearly and proportionally with sales. In reality many assets (especially plant and equipment) grow in 'steps' — within spare capacity, sales growth needs no new equipment, but once at capacity a one-off large capital expenditure makes the real need far exceed the estimate. It also assumes constant net margin and retention, which may fall during early expansion. AFN suits a quick initial estimate and direction check; real financing decisions need detailed forecasts, cash-flow statements and capex plans.
How is AFN different from a cash-flow forecast?
AFN is a quick estimate using average ratios (asset/sales, liability/sales) to roughly gauge external funding — few inputs, fast, good for early planning. A cash-flow forecast lists expected inflows and outflows month by quarter (collections, payments, capex, repayments), far more detailed, showing the timing and size of any gap — the basis for actual financing. They complement: AFN first judges 'roughly short or not, by how much'; cash-flow forecast then confirms 'when and how to fill it'. Major financing should not rely on AFN alone.
Why is the linear asset-growth assumption inaccurate?
AFN assumes assets (especially fixed assets) grow linearly with sales, but fixed assets often grow in steps. With spare capacity, sales growth needs no equipment, so real need is below estimate; near capacity, a one-off capex (new line, expanded plant) makes real need jump far above the model. Margins may also fall during expansion. AFN is more accurate with spare capacity and mild growth; for large expansion or capacity bottlenecks, use detailed capex and financial forecasts.
Related Tools
References
Content review: Calculatorism Finance Team. Results are for reference only; please refer to the relevant authorities for the official figures.