User Rating 0.0 โ˜…โ˜…โ˜…โ˜…โ˜…
Total Usage 0 times
Sales & Growth
$
$
Balance Sheet Items
$
$
Profitability & Dividends
%
%
Enter values and click Calculate
Is this tool helpful?

Your feedback helps us improve.

โ˜… โ˜… โ˜… โ˜… โ˜…

About

The Additional Funds Needed equation estimates external capital a firm must raise to support a planned increase in sales. It decomposes funding requirements into three components: the asset expansion required to sustain higher output (A* scaled by the sales growth ratio), the spontaneous liability offset that arises naturally from increased trade activity (L* scaled identically), and internally generated funds via retained earnings (PM ร— S1 ร— (1 โˆ’ d)). Miscalculating AFN leads to either excess idle capital (cost of carry) or a funding shortfall mid-expansion (credit risk, operational disruption). This tool assumes a constant capital intensity ratio and linear asset-sales proportionality. It does not model economies of scale or step-function capacity additions. Pro tip: run the calculation at multiple growth rates to build a sensitivity table before approaching lenders.

AFN calculator additional funds needed financial planning pro forma external financing growth financing corporate finance

Formulas

The Additional Funds Needed formula quantifies the gap between required asset growth and internally available financing:

AFN = A*S0 ร— ฮ”S โˆ’ L*S0 ร— ฮ”S โˆ’ PM ร— S1 ร— (1 โˆ’ d)

Where A* = total assets that vary directly with sales, L* = spontaneous liabilities (accounts payable, accrued wages) that increase automatically with sales, S0 = current period sales, S1 = projected sales, ฮ”S = S1 โˆ’ S0 (change in sales), PM = net profit margin (Net Income รท S1), and d = dividend payout ratio. The retention ratio is (1 โˆ’ d). A positive AFN indicates external financing is required. A negative AFN means the firm generates surplus funds internally.

Reference Data

Growth RateTypical Capital Intensity (A*/Sโ‚€)Industry ExampleSpontaneous Liab. Ratio (L*/Sโ‚€)Avg. Profit MarginCommon Payout Ratio
5%0.40Software / SaaS0.1015%0%
10%0.55Professional Services0.1212%20%
10%0.65Retail / E-commerce0.155%30%
15%0.80Food & Beverage0.188%25%
15%1.00Manufacturing0.127%35%
20%1.20Heavy Industry0.106%40%
20%1.50Utilities0.0810%50%
25%0.70Healthcare / Pharma0.1418%15%
25%0.90Telecommunications0.119%45%
30%0.50Fintech / Startup0.05โˆ’5%0%
30%1.80Mining & Resources0.0712%30%
50%0.35Digital Media0.0920%0%

Frequently Asked Questions

A negative AFN indicates your firm generates more internal funds than needed to support the projected sales growth. The surplus can be used to pay down debt, increase dividends, buy back shares, or invest in new projects. It typically occurs when profit margins are high, payout ratios are low, or the planned growth rate is modest relative to asset intensity.
The payout ratio d directly reduces retained earnings available for growth. If d = 0, all net income is retained internally, minimizing AFN. If d = 1 (100% payout), no earnings are retained and the entire asset increase must be externally financed. Each 10 percentage-point increase in payout ratio raises AFN by 0.10 ร— PM ร— S1.
The AFN equation models a proportional (linear) relationship where each dollar of sales requires a fixed dollar amount of assets. This "constant capital intensity" assumption holds reasonably well for firms operating below full capacity. It breaks down when a firm hits a capacity ceiling requiring a step-function investment (e.g., building a new factory). In such cases, compute AFN at the capacity breakpoint separately.
Spontaneous liabilities are balance-sheet obligations that increase automatically and proportionally with sales volume without explicit management decisions. Common examples: accounts payable (suppliers extend more credit as orders grow), accrued wages (more labor hours), accrued taxes, and accrued utilities. Notes payable to banks are NOT spontaneous because they require a deliberate financing decision.
Hold all other inputs constant and vary projected sales (S1) across a range of growth rates (e.g., 5%, 10%, 15%, 20%). Plot AFN against growth rate. The intersection with zero identifies the sustainable growth rate (SGR), the maximum rate the firm can grow without external financing. Any growth above SGR requires raising debt or equity.
No. The standard AFN formula assumes assets are at full utilization. If your firm operates at, say, 80% capacity, you have 20% slack before needing new assets. To adjust: divide current assets by the capacity utilization fraction to find full-capacity asset level, then use that adjusted figure as A*. This reduces AFN because existing assets can absorb some growth.