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.
