Efn (External Funding Needed) Calculator
Growth eats cash. Every extra dollar of sales needs assets behind it: inventory, receivables, equipment. Some of that comes free, from suppliers who extend credit and profits you keep in the business. The rest has to come from somewhere else. External funding needed, or EFN, is the dollar amount of that gap: the cash you must raise through loans or new equity to support your growth plan.
This calculator runs the textbook percentage-of-sales EFN formula and three companion methods. Enter current sales, growth, assets, liabilities, margins, and dividend policy; it computes the funding gap, the sustainable growth rate, and how the gap compares to your sales, with plain-English recommendations on how to close it.
EFN (External Funding Needed) Calculator
Ratios fill in automatically from your sales, income, assets, and equity figures; you can override the margin.
How to Use This Calculator
Choose a method, then fill in the figures. The percentage-of-sales method is the standard textbook approach and the right default for most users. Enter current sales and the projected growth rate, current net income and the retention ratio (the share of profits kept in the business, which is 100 percent minus the dividend payout ratio), current total assets, spontaneous liabilities as a percent of the sales increase, and stockholders' equity for the sustainable growth check. Ratios compute automatically as you type, and the profit margin fills itself in from net income over sales.
The EFN Formula
EFN = (A/S x change in sales) - (L/S x change in sales) - (profit margin x projected sales x retention ratio)
- A/S is the asset-to-sales ratio: how many dollars of assets each dollar of sales needs.
- L/S is the spontaneous-liabilities-to-sales ratio: payables and accruals that grow automatically with sales.
- Profit margin x projected sales x retention ratio is the internally generated funding: the profits you keep.
A positive EFN is the amount to raise externally. A negative EFN is a funding surplus: the plan funds itself, and the extra can support faster growth or higher dividends.
Worked Example
A company has $500,000 in current sales, projects 20 percent growth, holds $400,000 in assets, carries spontaneous liabilities equal to 40 percent of the sales increase, earns a 10 percent net margin, and retains 60 percent of profits. Projected sales are $600,000, an increase of $100,000. Required assets: 0.8 x $100,000 = $80,000. Spontaneous financing: 0.4 x $100,000 = $40,000. Internal funding: 0.10 x $600,000 x 0.60 = $36,000. EFN = $80,000 - $40,000 - $36,000 = $4,000. The company must raise $4,000 externally, matching the calculator output above.
The Four Methods
| Method | What it does | When to use it |
|---|---|---|
| Percentage of Sales | The standard EFN formula above | Default choice for growth planning |
| Balance Sheet Approach | Same formula, framed from the balance sheet identity | When you think in assets and claims |
| Sustainable Growth Model | Compares planned growth to the sustainable rate; reports no external need when growth is self-fundable | Checking whether a growth target is realistic |
| Advanced Pro Forma | Adds a working-capital buffer of 10 percent of the sales increase | Conservative planning with a cash cushion |
What Competitors Miss
The competing calculators run the basic formula and stop. None of them derives the input ratios from your financials automatically, none computes the sustainable growth rate alongside EFN so you can see whether the plan is self-fundable, and none explains a negative result: users who get a negative number are left guessing whether it is an error, when it is actually the best possible news, a funding surplus. This page adds automatic ratio derivation, the sustainable-growth cross-check, four methods, and plain-English recommendations scaled to the size of the gap.
Frequently Asked Questions
What does a negative EFN mean?
It means a funding surplus: internal profits plus spontaneous liabilities more than cover the asset increase. You need zero external funding, and the surplus can fund faster growth or higher dividends.
What is the retention ratio?
The share of net income kept in the business instead of paid out as dividends. It equals 100 percent minus the dividend payout ratio: a 40 percent payout means a 60 percent retention ratio.
What are spontaneous liabilities?
Obligations that grow automatically with sales, mainly accounts payable and accrued expenses. They are free financing from suppliers, so they reduce EFN. Notes payable and long-term debt are not spontaneous.
How is the sustainable growth rate calculated?
Sustainable growth rate = return on equity x retention ratio. With 20 percent ROE and 60 percent retention, the company can grow 12 percent a year without external funds.
Why does the advanced method give a higher number?
It adds a working-capital buffer equal to 10 percent of the sales increase, a conservative cushion for cash-flow timing. Use it when you want the plan to survive a rough quarter.
Can EFN be zero?
Yes. When internal funding and spontaneous liabilities exactly cover the asset increase, the growth plan is self-financing. The sustainable-growth method reports zero in exactly this situation.
Should I use debt or equity to cover EFN?
Small gaps are usually cheapest with a bank credit line or term loan; large gaps often need equity or long-term debt. The calculator's recommendations scale with the gap relative to your sales.