Additional Funds Needed Calculator

Estimate the external financing a growing company must raise: projected asset increase minus the spontaneous liability increase and the addition to retained earnings.

Quick Facts

Formula
AFN = (A0*/S0)ΔS − (L0*/S0)ΔS − M × S1 × (1 − d)
Percent-of-sales method: assumes assets and spontaneous liabilities grow in proportion to sales and the profit margin holds at the new sales level.

Your Results

Calculated
Additional funds needed
-
External financing required
Required asset increase
-
(A0*/S0) × ΔS
Spontaneous liability increase
-
(L0*/S0) × ΔS
Addition to retained earnings
-
M × S1 × (1 − d)

Ready

Enter sales, growth, balance-sheet figures, and payout ratio, then press Calculate.

What this calculator does

The Additional Funds Needed (AFN) calculator estimates how much external financing a company must raise to support a planned increase in sales. It applies the standard percent-of-sales equation: AFN = (A0*/S0) × ΔS − (L0*/S0) × ΔS − M × S1 × (1 − d), where A0* is assets that grow with sales, L0* is spontaneous liabilities, S0 is current sales, S1 = S0 × (1 + g) is forecast sales, ΔS = S1 − S0 is the sales increase, M is the profit margin, and d is the dividend payout ratio.

How the three pieces fit together

  • Required asset increase — (A0*/S0) × ΔS. Higher sales demand proportionally more receivables, inventory, and often fixed assets. This term is the new investment the growth requires.
  • Spontaneous liability increase — (L0*/S0) × ΔS. Accounts payable and accrued wages and taxes rise automatically as the business buys and produces more, providing financing that requires no negotiation.
  • Addition to retained earnings — M × S1 × (1 − d). The profit kept in the business after dividends; the retention ratio (1 − d) is the share of net income not paid out.

Interpreting the output

A positive AFN is the funding gap the company must close with new debt or equity. A negative AFN means internal sources more than cover the growth — a financing surplus. With the default inputs ($1,000,000 sales growing 20%, $600,000 of assets, $100,000 of spontaneous liabilities, a 5% margin, and a 40% payout), the required asset increase is $120,000, spontaneous liabilities add $20,000, retained earnings add $36,000, and AFN comes to $64,000. The model assumes assets scale linearly with sales and that there is no spare capacity; excess capacity in existing assets makes the true figure lower.

Next steps

  • Test faster and slower growth rates — AFN rises quickly with g because both ΔS and S1 grow with it
  • Find the self-supporting growth rate: the growth level at which AFN is exactly zero
  • For actual financing decisions, refine the estimate with a full projected balance sheet or professional advice

Frequently Asked Questions

What is the AFN formula?
AFN = (A0*/S0) × ΔS − (L0*/S0) × ΔS − M × S1 × (1 − d). A0* is assets that grow with sales, L0* is spontaneous liabilities (accounts payable and accruals), S0 is current sales, S1 is forecast sales, ΔS is the sales increase, M is the profit margin, and d is the dividend payout ratio. The first term is the new assets the growth requires, the second is financing that arises automatically, and the third is the retained earnings the firm generates itself.
What does a negative AFN mean?
A negative AFN means projected retained earnings plus the automatic increase in spontaneous liabilities exceed the new assets required to support the sales growth. The company can fund the expansion internally and has surplus funds available to pay down debt, repurchase stock, or raise dividends.
Which liabilities count as spontaneous?
Only liabilities that rise automatically with sales — mainly accounts payable and accrued wages and taxes. Notes payable, bank loans, and long-term debt are excluded because they require a deliberate financing decision and do not grow in proportion to sales.

Related calculators