Additional Funds Needed (AFN) Calculator
Enter the projected change in assets, the change in liabilities and the retained earnings added to find the additional funds needed.
Updated
Additional Funds Needed (AFN) Calculator
Our Additional Funds Needed (AFN) Calculator shows how much outside financing a business must raise to pay for planned growth. Enter the projected change in assets, the change in liabilities and the retained earnings added, and it returns the funding gap, the share covered by internal funds and whether you need to raise money or have a surplus.
Quick answer
Additional funds needed is AFN = ΔA − ΔL − ΔRE: 100,000 − 25,000 − 40,000 = 35,000.
- ΔA: the increase in assets needed to support the growth
- ΔL: the increase in spontaneous liabilities, such as accounts payable and accruals
- ΔRE: the addition to retained earnings (net income minus dividends)
- Positive AFN must be raised from loans or new equity; negative AFN is a surplus
What Is Additional Funds Needed?
Additional funds needed (AFN), also called external financing needed (EFN), is the money a company must raise from outside sources to support its growth. When sales grow, a business usually needs more assets: stock, receivables, equipment. Part of that is paid for automatically by liabilities that grow with sales and by profits kept in the business. AFN is the part that is left over.
Analysts, lenders and founders use it to plan how much to borrow or raise as equity before growth runs into a cash shortfall.
AFN Formula
= ΔA − (ΔL + ΔRE)
- ΔA (change in assets): the extra assets needed for the planned growth.
- ΔL (change in liabilities): the increase in spontaneous liabilities such as accounts payable and accrued wages, which rise with sales without new borrowing.
- ΔRE (retained earnings added): next period net income minus dividends.
ΔL + ΔRE is the internal financing. AFN is what the internal financing does not cover.
How to Calculate AFN
- Add the internal funds. ΔL + ΔRE = 25,000 + 40,000 = 65,000.
- Subtract them from the change in assets. 100,000 − 65,000 = 35,000.
- Read the sign. A positive result is the amount to raise from outside. Here the company needs 35,000.
Use the same currency and the same period (usually next year) for all three figures.
AFN Examples
| ΔA − ΔL − ΔRE | AFN |
|---|---|
| 100,000 − 25,000 − 40,000 | 35,000 |
| 26,000 − 1,100 − 12,500 | 12,400 |
| 50,000 − 5,000 − 10,000 | 35,000 |
| 60,000 − 20,000 − 50,000 | −10,000 |
In the first row the company covers 65% of its new assets internally and raises the other 35,000 through a bank loan, bonds or new shares. In the last row internal funds are 10,000 more than it needs, so it has nothing to raise.
AFN From Projected Sales
Finance textbooks often build the three inputs from a sales forecast (the percent of sales method):
− (L*/S₀)ΔS
− M × S₁ × (1 − payout)
A* and L* are the assets and spontaneous liabilities that grow with sales, S₀ is this year’s sales, S₁ next year’s, ΔS the change, M the profit margin and payout the share of profit paid as dividends.
Example: sales rise from 800,000 to 1,000,000 (ΔS = 200,000), A*/S₀ = 0.5, L*/S₀ = 0.125, margin 8% and payout 50%:
ΔL = 0.125 × 200,000 = 25,000
ΔRE = 0.08 × 1,000,000
× 0.5 = 40,000
AFN = 35,000
Work out ΔA, ΔL and ΔRE this way, then enter them in the calculator.
Positive and Negative AFN
- Positive AFN: growth needs more money than the business generates. Plan a loan, a bond issue or new equity for that amount.
- Zero: internal funds exactly cover the new assets.
- Negative AFN: a surplus. The business can fund its growth itself and may repay debt, pay higher dividends or invest the extra.
A high AFN is not bad in itself. It often means fast growth, but the company should check that the new debt or equity keeps its capital structure balanced.
What Changes the AFN?
Each input moves AFN one for one. More assets raise it; more liabilities or retained earnings lower it:
| ΔA − ΔL − ΔRE | AFN |
|---|---|
| 20,000 − 5,000 − 8,000 | 7,000 |
| 25,000 − 5,000 − 8,000 | 12,000 |
| 30,000 − 10,000 − 8,000 | 12,000 |
| 30,000 − 5,000 − 12,000 | 13,000 |
In practice AFN rises with the growth rate and with capital intensity (assets per unit of sales), and falls with a higher profit margin or a lower dividend payout.
Common Mistakes
- Counting new loans in ΔL. Only spontaneous liabilities belong there. Notes payable and bonds are the financing AFN measures.
- Using net income for ΔRE. Subtract dividends first.
- Mixing periods. All three figures must cover the same forecast period.
- Ignoring spare capacity. If fixed assets are not fully used, ΔA can be smaller than sales growth suggests.
Key Terms
- AFN
- Outside funds needed for growth.
- ΔA
- Increase in assets.
- ΔL
- Increase in spontaneous liabilities.
- ΔRE
- Net income minus dividends.
- Payout
- Share of profit paid as dividends.
How to Use the AFN Calculator
- Enter the change in assets. Type the projected increase in total assets needed for the growth, such as 100000. Commas and a currency sign are fine.
- Enter the liabilities and retained earnings. Type the increase in spontaneous liabilities, such as 25000, and the retained earnings added (net income minus dividends), such as 40000.
- Read and copy the result. The additional funds needed appear as you type, with the working, the internal funds, the share funded internally and whether you need to raise money or have a surplus. Press Copy to copy it, or Clear or Esc to start again.
Example: a company expects its assets to grow by 100,000, its payables and accruals by 25,000, and plans to retain 40,000 of profit. Enter 100000, 25000 and 40000. The result is 35,000 to raise, with 65% of the growth funded internally.
Who Can Use This Calculator?
Frequently Asked Questions (FAQs)
How do you calculate additional funds needed?
Subtract the increase in spontaneous liabilities and the retained earnings added from the increase in assets: AFN = ΔA − ΔL − ΔRE. For example, 100,000 − 25,000 − 40,000 = 35,000.
What is the AFN formula with sales?
AFN = (A*/S₀) × ΔS − (L*/S₀) × ΔS − M × S₁ × (1 − payout ratio), where A* and L* are the assets and liabilities that grow with sales, S₀ and S₁ are this year and next year sales, ΔS is the change in sales and M is the profit margin.
What does a negative AFN mean?
A negative AFN is a surplus: liabilities and retained earnings grow by more than the assets needed, so the business can fund its growth without outside money. 60,000 − 20,000 − 50,000 = −10,000.
Is AFN the same as external financing needed (EFN)?
Yes. Some textbooks call it additional funds needed (AFN) and others external financing needed (EFN). Both mean the financing that must come from new debt or equity.
What liabilities count in the AFN formula?
Only spontaneous liabilities that rise with sales, such as accounts payable and accrued wages and taxes. New bank loans, notes payable and bonds are left out, because they are the financing AFN measures.
How do you find the change in retained earnings?
Take next period net income and subtract dividends. With sales of 1,000,000, an 8% profit margin and a 50% payout: 0.08 × 1,000,000 × 0.5 = 40,000.
What increases the additional funds needed?
Faster sales growth, more assets per unit of sales, a lower profit margin and a higher dividend payout all raise AFN. Spare capacity in fixed assets lowers it.
How often should a company recalculate AFN?
Whenever the forecast changes, and at least once a year as part of budgeting. Recalculate before a major expansion, a new product launch or a large capital purchase.
Is the Additional Funds Needed Calculator free?
Yes. It is completely free, needs no sign-up, and can be used as many times as you like.
Sources
- Brigham, E. F. and Ehrhardt, M. C. Financial Management: Theory and Practice. Cengage Learning.
- Gitman, L. J. and Zutter, C. J. Principles of Managerial Finance. Pearson Education.
- eFinanceManagement. Additional Funds Needed: meaning, formula, example.
Try our Additional Funds Needed Calculator to see how much outside funding your growth plan needs in seconds.