AFN Calculator (Additional Funds Needed)
Test cases replayed : 2 of 2 match · Methodology · No outside source listed
Estimate how much outside financing a company needs to support next year's sales growth.
Result
Additional funds needed (AFN, $)
Next year's sales ($)
- Required increase in assets ($)
- Spontaneous increase in liabilities ($)
- Increase in retained earnings ($)
Estimate for planning only, not tax, legal, financial or medical advice. This calculator uses the method explained on this page.
This browser did not allow copying. The sentence is in the box below, already selected: copy it with your keyboard or the menu.
How to use this calculator
Fill in the fields in this order; each step takes you to its field.
- Current sales, in dollars: enter 1 or more.
- Expected sales growth, in percent: enter -100 or more.
- Assets that grow with sales, in dollars: enter 0 or more.
- Spontaneous liabilities: payables, accruals, in dollars: enter 0 or more.
- Profit margin (% of sales): enter -100 or more.
- Dividend payout ratio, in percent: enter a number from 0 to 100.
- Read the result: Additional funds needed (AFN, $); the panel also shows Next year's sales ($), Required increase in assets ($), Spontaneous increase in liabilities ($) and Increase in retained earnings ($).
How this calculator works
AFN = (A* ÷ S₀) × ΔS − (L* ÷ S₀) × ΔS − M × S₁ × (1 − payout ratio), where A* are assets tied to sales, L* spontaneous liabilities, S₀ current sales, S₁ next year's sales, ΔS = S₁ − S₀ and M the profit margin.
This is the additional funds needed equation of corporate finance textbooks (percent-of-sales method). It assumes assets and spontaneous liabilities grow in proportion to sales. A negative result is a surplus of funds.
The formula
| Symbol | Meaning | Unit |
|---|---|---|
| Current sales | $ | |
| Expected sales growth | % | |
| Assets that grow with sales | $ | |
| Spontaneous liabilities: payables, accruals | $ | |
| Profit margin (% of sales) | ||
| Dividend payout ratio | % | |
| Next year's sales | $ | |
| Required increase in assets | $ | |
| Spontaneous increase in liabilities | $ | |
| Increase in retained earnings | $ | |
| Additional funds needed (AFN, $) | $ |
Worked example
| Current sales | $5,000,000 |
|---|---|
| Expected sales growth | 20% |
| Assets that grow with sales | $2,000,000 |
| Spontaneous liabilities: payables, accruals | $400,000 |
| Profit margin (% of sales) | 5 |
| Dividend payout ratio | 40% |
| Next year's sales ($) | $6,000,000 |
|---|---|
| Required increase in assets ($) | $400,000 |
| Spontaneous increase in liabilities ($) | $80,000 |
| Increase in retained earnings ($) | $180,000 |
Additional funds needed (AFN, $) $140,000
Each step uses the unrounded value of the step before it; figures on this page are rounded for display.
Frequently asked questions
What does AFN mean?
The external money (new debt or equity) a firm must raise so that its assets can grow with sales, after counting the payables that grow on their own and the profits it keeps.
What is AFN in the default example?
$140,000: an asset increase of $400,000, minus $80,000 of spontaneous liabilities and $180,000 of retained earnings.