Estimate additional funds needed from projected sales or growth rate, sales-linked assets, spontaneous liabilities, profit margin, and retained earnings.
Last updated
Estimate the AFN / EFN financing gap Model how much outside funding a sales plan may need after sales-linked operating assets, spontaneous liabilities, and retained earnings are all taken into account.
Display currency
Choose the reporting currency before entering sales, operating assets, liabilities, or retained earnings assumptions. The AFN formula is unchanged.
Sales plan input
Earnings retention input
AFN assumptions
Use only the operating assets that genuinely rise with sales, such as receivables, inventory, and the portion of fixed assets that must expand with the plan.
Use only spontaneous liabilities that rise naturally with sales, such as payables and accruals. Do not treat chosen borrowing, notes payable, or long-term debt as spontaneous support.
Result
$48,000.00 AFN
The projected sales plan creates an estimated external financing gap of $48,000.00 after spontaneous liabilities and retained earnings support are applied.
Sales growth
33.33%
AFN as % of projected sales
4%
Required asset increase
$180,000.00
Spontaneous liability support
$60,000.00
Retained-earnings support
$72,000.00
Retention ratio
75%
External financing required The growth plan needs financing beyond spontaneous liabilities and retained earnings.
Financing bridge
Sales increase
$300,000.00
Required asset increase
$180,000.00
Less spontaneous liability support
$60,000.00
Net gap before retained earnings
$120,000.00
Less retained-earnings support
$72,000.00
Additional funds needed
$48,000.00
Balance-sheet support at the planned sales level
Projected operating assets rise to $720,000.00 while spontaneous liabilities rise to $240,000.00.
Internal sources cover 73.33% of the required asset increase before any new external funding is raised.
What to test next
The model assumes 60% of sales must be supported with operating assets and 20% is offset by spontaneous liabilities such as payables and accruals. Before treating the AFN output as a borrowing target, test whether working-capital efficiency, payout policy, or phased growth could reduce the gap.
Check whether receivables, inventory, or other operating assets can grow more slowly than sales.
Model a lower payout ratio or higher margin to see how much more retained earnings support the business could keep.
Layer in any one-time capex, unused fixed-asset capacity, or lender constraints that the simple AFN formula does not capture.
Additional funds needed calculator: AFN, EFN, and external financing gaps
An additional funds needed calculator estimates the outside capital a growth plan may require after internally generated support is considered. This AFN calculator, also useful for EFN-style external financing planning, compares the sales-linked asset build needed for higher revenue with spontaneous liabilities and retained earnings that can fund part of that growth without new borrowing or equity.
What additional funds needed is measuring
Additional funds needed, or AFN, is a first-pass estimate of the financing gap created when a business plans for higher sales. More sales usually require more receivables, inventory, and other operating assets. The question is not only how much those assets must rise, but how much of that rise can be financed internally before management has to raise debt or equity.
That is why AFN is often taught alongside EFN, or external funds needed. Both labels point to the same planning idea: compare the asset growth implied by the sales plan with the liabilities that rise naturally with sales and the earnings that are retained in the business. The remainder is the external financing gap. A positive result points to borrowing or equity needs. A negative result suggests the plan is internally funded under the assumptions entered, though it does not automatically mean the business has fully free cash to distribute.
Core AFN formulas
The calculator uses the classic percentage-of-sales AFN approach. It starts with the share of current operating assets that genuinely moves with sales and applies that ratio to the projected sales increase. It then subtracts the share of spontaneous liabilities expected to move with sales and the retained earnings expected from the projected profit margin and payout policy.
That makes AFN a useful planning shortcut because it turns current operating structure into a financing estimate quickly. It is intentionally simpler than a full projected balance sheet and is most useful when management wants an early financing signal before building a lender-ready forecast or a full integrated model.
Required asset increase = (Operating assets tied to sales / Current sales) x Change in sales
This estimates how much additional operating-asset support is needed for the projected sales plan.
Spontaneous liability increase = (Spontaneous liabilities / Current sales) x Change in sales
This estimates the amount of funding that naturally rises with sales through payables and similar liabilities.
Addition to retained earnings = Projected sales x Profit margin x (1 - Dividend payout ratio)
This estimates how much projected profit is kept inside the business instead of being paid out.
This is the external financing gap left after internal balance-sheet support is applied.
What counts as spontaneous liabilities and sales-linked assets
The most common AFN mistake is using total assets and total liabilities instead of only the balances that move with sales. Sales-linked operating assets usually include receivables, inventory, and sometimes the portion of fixed assets that must expand with volume. Spontaneous liabilities usually include accounts payable and accruals that rise naturally as sales and activity rise.
Items such as long-term debt, notes payable, and new equity raised deliberately by management are not spontaneous liabilities in the classic AFN formula. They are financing decisions made after the financing gap is identified. If those balances are mixed into the spontaneous-liability input, the model will understate the external financing gap and make the plan look more self-funding than it really is.
The same caution applies to fixed assets. If the business has spare capacity, a sales increase may not require fixed assets to rise in proportion to sales, so using a broad total-assets ratio can overstate AFN. On the other hand, if growth triggers a warehouse expansion, new production line, or other lumpy capex, the simple formula can understate real funding needs unless that step-up is layered in separately.
Using projected sales, growth rate, payout, and retention inputs
Many AFN and external funds needed calculators ask for the same sales plan in different ways. If you know the next-period sales target, enter projected sales directly. If you are testing a percentage growth plan, use the growth-rate mode and the calculator converts that percentage into projected sales before applying the same AFN formula.
The dividend payout and retention inputs are also two views of one assumption. A 25% payout ratio means a 75% retention ratio, so the business keeps three quarters of projected net income inside the company. Switching between payout ratio and retention ratio can make the model easier to use depending on whether management is discussing dividends, owner distributions, or the proportion of profit that will be reinvested.
This extra flexibility matters because AFN is often a sensitivity tool. A finance team may start with projected sales from a budget, then pressure-test growth percentages, lower payouts, stronger margins, or working-capital improvements to see which lever has the largest effect on the external financing needed.
Worked example: growth plan with a financing gap
Suppose current sales are 900,000 and projected sales are 1,200,000, so the sales increase is 300,000. If operating assets tied to sales are 540,000, the asset-to-sales ratio is 60%, which implies 180,000 of required asset growth. If spontaneous liabilities tied to sales are 180,000, the liability-to-sales ratio is 20%, which contributes 60,000 of spontaneous support.
If the projected profit margin is 8% and the dividend payout ratio is 25%, projected net income is 96,000 and retained-earnings support is 72,000. The financing bridge then works in stages: 180,000 of required asset growth minus 60,000 of spontaneous-liability support leaves a 120,000 gap before retained earnings. Subtracting 72,000 of retained-earnings support leaves AFN of 48,000.
That 48,000 result is not a valuation of the whole business and not a recommendation on which financing source to choose. It is a compact signal that, under the current structure, the sales plan is not fully self-funding. Management still has to decide whether to cover that gap with working-capital improvements, lower payouts, slower growth, more borrowing, or new equity.
Why AFN can overstate or understate the financing gap
AFN can overstate financing needs when the business has unused capacity and does not need assets to rise in direct proportion with sales. A manufacturer with spare plant capacity, for example, may be able to support a sales increase without adding as much fixed-asset support as the current asset-to-sales ratio implies. In that situation, a simple percentage-of-sales model can make the financing gap look larger than it will be in practice.
AFN can also understate financing needs when growth is lumpy instead of smooth. A new warehouse, extra production line, or step-up in headcount may be required before sales actually arrive. That kind of pre-growth investment does not show up cleanly in a proportional sales model. The formula also ignores financing costs, seasonality, covenant limits, timing within the year, and separate cash-flow strain that may appear even when the annual AFN figure looks manageable.
How to use AFN results in planning
Use AFN to pressure-test growth before finalising budgets, inventory plans, staffing, or capital commitments. If the AFN output looks too large, the usual levers are to improve profit margin, reduce payout, improve working-capital efficiency, or phase the sales plan so operating assets do not need to rise as quickly. Many businesses also compare AFN with a debt-capacity view to decide whether borrowing is realistic or whether the plan needs more retained capital.
AFN is best treated as an early financing signal rather than a final financing recommendation. It is useful because it forces the same practical question a lender or finance team will ask later: if sales rise, how exactly will the business support the extra assets required? Once AFN shows a material gap, the next step is usually a fuller forecast with explicit assumptions for receivables, inventory, payables, capex, financing terms, and cash timing.
Frequently asked questions
What counts as spontaneous liabilities in an AFN calculation?
Spontaneous liabilities are balances that rise naturally with sales and operating activity, such as accounts payable and accrued expenses. They are different from financing decisions such as new term debt, revolving borrowing, or new equity. In a clean AFN model, only the liabilities that scale automatically with sales should be treated as spontaneous support.
What does a negative AFN mean?
A negative AFN means the assumptions entered generate more internal support than the sales plan consumes. That can happen because margins are strong, payout is low, spontaneous liabilities are meaningful, or projected sales fall instead of rise. It suggests the plan is self-funding under the model, but management still has to check whether cash timing, capex, or debt constraints change the real-world picture.
Is AFN the same as EFN or external financing needed?
Usually yes. Many finance texts use AFN, additional funds needed, and EFN, external funds needed, for the same percentage-of-sales planning concept. The labels can vary by course or textbook, but the core logic is the same: estimate the asset growth required by higher sales, subtract spontaneous liabilities and retained earnings, and solve for the remaining financing gap.
When can the AFN formula misstate financing needs?
AFN can overstate needs if the business has unused capacity and assets do not need to rise in line with sales. It can understate needs when growth requires lumpy investment such as new equipment, facilities, or headcount before the revenue arrives. That is why AFN is best used as a first-pass planning model and followed by a fuller forecast when the financing decision is important.
Can I calculate AFN from a sales growth percentage instead of projected sales?
Yes. A sales growth percentage is just another way to express projected sales. For example, a 20% growth plan on current sales of 900,000 implies projected sales of 1,080,000. The AFN formula then uses the change in sales between the current and projected sales levels.
Should I enter payout ratio or retention ratio?
Use whichever assumption you know best. Payout ratio is the share of projected net income distributed out of the business, while retention ratio is the share kept in the business. The two should add to 100%, so a 30% payout ratio is the same as a 70% retention ratio.
Why does improving working capital reduce external financing needed?
AFN rises when more operating assets are needed for each unit of sales. If a business collects receivables faster, turns inventory more efficiently, or negotiates operating payables responsibly, the asset increase tied to sales growth can fall or spontaneous-liability support can rise. That reduces the external financing gap before the company considers new debt or equity.
Is AFN enough for a lender or investor forecast?
No. AFN is useful for early planning, but lenders and investors usually need a fuller forecast with explicit cash timing, debt service, covenants, working-capital assumptions, capital expenditure, and scenario analysis. Use the AFN result to identify whether the growth plan probably needs outside funding, then support financing decisions with a more detailed model.
