Skip to content
FiftyCalc Free calculators for all 50 states

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

Sample figures

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.

AFN Calculator (Additional Funds Needed)

Current sales, in dollars: enter 1 or more. Prefilled example: 5,000,000.

Expected sales growth, in percent: enter -100 or more. Prefilled example: 20.

Assets that grow with sales, in dollars: enter 0 or more. Prefilled example: 2,000,000.

Spontaneous liabilities: payables, accruals, in dollars: enter 0 or more. Prefilled example: 400,000.

Profit margin (% of sales): enter -100 or more. Prefilled example: 5.

Dividend payout ratio, in percent: enter a number from 0 to 100. Prefilled example: 40.

How to use this calculator

Fill in the fields in this order; each step takes you to its field.

  1. Current sales, in dollars: enter 1 or more.
  2. Expected sales growth, in percent: enter -100 or more.
  3. Assets that grow with sales, in dollars: enter 0 or more.
  4. Spontaneous liabilities: payables, accruals, in dollars: enter 0 or more.
  5. Profit margin (% of sales): enter -100 or more.
  6. Dividend payout ratio, in percent: enter a number from 0 to 100.
  7. 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

  1. S1=s0×(1+g100)
  2. Inc=as0×(S1−s0)
  3. Sp=ls0×(S1−s0)
  4. Re=m100×S1×(1−d100)
  5. Afn=Inc−Sp−Re
Symbols used in the formula
SymbolMeaningUnit
s0Current sales$
gExpected sales growth%
aAssets that grow with sales$
lSpontaneous liabilities: payables, accruals$
mProfit margin (% of sales)
dDividend payout ratio%
S1Next year's sales$
IncRequired increase in assets$
SpSpontaneous increase in liabilities$
ReIncrease in retained earnings$
AfnAdditional funds needed (AFN, $)$

Worked example

Current sales$5,000,000
Expected sales growth20%
Assets that grow with sales$2,000,000
Spontaneous liabilities: payables, accruals$400,000
Profit margin (% of sales)5
Dividend payout ratio40%
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
  1. S1=5,000,000×(1+20100)=6,000,000
  2. Inc=2,000,0005,000,000×(6,000,000−5,000,000)=400,000
  3. Sp=400,0005,000,000×(6,000,000−5,000,000)=80,000
  4. Re=5100×6,000,000×(1−40100)=180,000
  5. Afn=400,000−80,000−180,000=140,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.

Related calculators