How to Use This Calculator
- 1
Enter Sales Growth and Asset Ratios
Input the Change in Sales (projected revenue increase), Assets per $ of Sales (asset intensity ratio), and Liabilities per $ of Sales (spontaneous liabilities like accounts payable).
- 2
Set Profitability and Retention
Enter the Profit Margin (net margin as a percentage), Margin of Safety (additional cash buffer), and Retention Ratio (percentage of net income retained, not paid as dividends).
- 3
Review Your Results
The calculator displays Additional Funds Needed, Total Assets Required, Internal Funds Available, and Self-Financing Ratio. The Funding Analysis panel shows retained earnings, net income from growth, external funding ratio, and implied asset turnover, plus an Asset Funding Sources breakdown bar.
Example Calculation
A growing small business projects a $50,000 increase in sales and needs to determine how much external financing it will require.
Change in Sales
$50,000
Assets per $ of Sales
0.6
Liabilities per $ of Sales
0.3
Profit Margin
10%
Margin of Safety
$5,000
Retention Ratio
50%
Results
AFN
$10,000
Total Assets
$30,000
Internal Funds
$20,000
Self-Financing
66.7%
Tips
Optimize Retention to Reduce External Funding
Increasing the retention ratio from 50% to 70% reduces AFN from $10,000 to $8,000 — a $2,000 reduction in external capital needed. If external financing costs exceed the dividend yield shareholders expect, retaining more earnings is the cheaper funding source.
Asset Intensity Drives the Funding Gap
Assets per $ of Sales is the most sensitive input. Reducing it from 0.60 to 0.50 drops Total Assets Required from $30,000 to $25,000, cutting AFN from $10,000 to $5,000. Improving inventory turnover or using existing capacity more efficiently directly reduces this ratio.
Watch the Self-Financing Ratio
A self-financing ratio of 66.7% means the business generates two-thirds of the capital needed for growth internally. Ratios above 75% indicate strong internal funding capacity; below 40% signals heavy reliance on external funds that may be expensive or dilutive.
Forecast External Financing for Sales Growth
The Additional Funds Needed (AFN) Calculator estimates how much external capital a business requires to support projected sales growth.
For a $50,000 sales increase with 0.60 asset intensity, 0.30 spontaneous liabilities, 10% profit margin, $5,000 safety margin, and 50% retention: AFN is $10,000, total assets required are $30,000, internal funds available are $20,000, and the self-financing ratio is 66.7%.
The Funding Analysis panel provides retained earnings, net income, external funding ratio, and implied asset turnover insights.
The AFN Formula
The AFN model balances asset requirements against internal funding sources:
totalAssetsNeeded = changInSales x assetsPerDollarOfSales
liabilitySponsoredFunds = changeInSales x liabilitiesPerDollarOfSales
netIncome = changeInSales x profitMargin
retainedEarnings = netIncome x retentionRatio
internalFunds = liabilitySponsoredFunds + retainedEarnings + (safetyMargin x retentionRatio)
AFN = totalAssetsNeeded - internalFunds
selfFinancingRatio = internalFunds / totalAssetsNeeded x 100
Additional derived metrics — retained earnings, net income from growth, external funding ratio, and implied asset turnover — appear in the Funding Analysis panel.
Funding a $50,000 Sales Expansion
A small manufacturing company projects $50,000 in new sales and needs to determine its external financing requirement.
- Total Assets Required: $50,000 x 0.60 = $30,000 — moderate asset investment needed.
- Liability-Sponsored Funds: $50,000 x 0.30 = $15,000 — spontaneous liabilities from accounts payable and accruals.
- Net Income: $50,000 x 10% = $5,000 — projected profit from the sales increase.
- Retained Earnings: $5,000 x 50% = $2,500 — half of net income reinvested.
- Safety Margin (Retained): $5,000 x 50% = $2,500 — retained portion of the cash buffer.
- Internal Funds: $15,000 + $2,500 + $2,500 = $20,000 — total internal funding capacity.
- Additional Funds Needed: $30,000 - $20,000 = $10,000 — external capital required.
The Funding Analysis panel also shows: retained earnings of $2,500 (modest contribution), net income from growth of $5,000, external funding ratio of 33.3%, and implied asset turnover of 1.67x.
The Asset Funding Sources bar breaks down the $30,000 requirement across liability-sponsored funds, retained earnings, safety margin, and external funds.
Balancing Internal and External Financing
A healthy growing business typically self-finances 60-80% of its asset expansion.
At 66.7% self-financing, the example company falls within this range but has room to improve.
Three levers reduce AFN: increasing the retention ratio (from 50% to 70% saves $2,000 in external capital), improving asset efficiency (reducing asset intensity from 0.60 to 0.50 saves $5,000), or negotiating better supplier terms (increasing spontaneous liabilities from 0.30 to 0.35 saves $2,500).
Each lever has trade-offs — higher retention means lower dividends, better asset efficiency may require operational changes, and extended payment terms depend on supplier relationships.
Limitations of the AFN Model
The basic AFN model assumes linear relationships between sales and assets, which may not hold if the business has economies of scale (existing equipment handles a 20% sales increase without new investment) or if growth is lumpy rather than steady.
It also assumes constant profit margins and retention ratios, which may change at different revenue levels.
For complex scenarios, a full pro forma financial statement or detailed cash flow forecast provides more accurate results.
The AFN model works best as a quick-estimate planning tool for moderate, steady growth scenarios.
Frequently Asked Questions
What is Additional Funds Needed (AFN)?
AFN estimates the external financing a company needs to support projected sales growth. It compares the total assets required for growth against internal funding sources (retained earnings, spontaneous liabilities, and safety margin). A positive AFN means the business needs outside capital; a negative AFN indicates a surplus.
Why is calculating AFN important for businesses?
AFN prevents liquidity crises during growth. Rapid sales expansion requires more inventory, receivables, and equipment. Without forecasting, a profitable company can still run out of cash. AFN lets management plan for external financing — loans, credit lines, or equity — in advance rather than making costly last-minute decisions.
What are spontaneous liabilities in the AFN calculation?
Spontaneous liabilities arise automatically with sales increases. The main examples are accounts payable and accrued expenses (wages, taxes). As sales grow, a company buys more inventory on credit (higher payables) and incurs more operational costs (higher accruals). These provide interest-free financing that reduces the external funding gap.
Can AFN be negative, and what does that mean?
Yes. A negative AFN means internal funding exceeds the assets needed for growth — the business has surplus capital. This can happen with high profit margins, high retention ratios, or low asset intensity. The surplus can be used for debt reduction, share buybacks, dividends, or opportunistic investments.
How does profit margin affect AFN?
Higher profit margins generate more net income, which increases retained earnings available for internal funding. At 10% margin and 50% retention on $50,000 growth, retained earnings are $2,500. At 20% margin, retained earnings double to $5,000, reducing AFN from $10,000 to $7,500.