AFN Calculator - Funding Gap Forecast

AFN calculator estimates the additional funds needed when a business plans for higher sales. Use it to translate a sales forecast into a financing gap by comparing the assets required for growth with spontaneous liabilities and retained earnings that can fund part of that growth.

• • Annual planning: Estimate whether next year's sales target needs new borrowing, owner capital, or retained cash.
• • Bank discussions: Prepare a simple funding bridge before discussing a line of credit, term loan, or covenant capacity.
• • Scenario review: Change profit margin, retention, or sales growth assumptions to see which variable drives the gap.
• • Classroom finance work: Check the percentage-of-sales AFN formula and each component in a worked corporate finance exercise.

AFN stands for additional funds needed. A positive result means the plan needs outside financing after automatic operating liabilities and retained profit are considered. A negative result means the projected plan creates more internal funding support than the modeled asset build requires, though that does not mean cash is unrestricted or available on the exact date you need it.

The calculator is best for operating businesses where sales, working capital, and some assets move together. It is less useful for start-ups with no base sales, firms with step-change capacity projects, or plans where management is changing credit terms, inventory policy, pricing, payout policy, or financing structure at the same time.

After estimating growth funding, Cash Flow to Debt Calculator helps test whether operating cash flow can support the debt already on the balance sheet.

The AFN formula uses the percentage-of-sales method. It assumes selected assets and spontaneous liabilities keep the same relationship to sales during the forecast period.

• A*/S0: Sales-linked assets divided by current sales. This estimates how much asset investment is needed per dollar of sales.
• Delta S: Projected sales minus current sales. Positive growth usually requires more assets; a decline may release some support.
• L*/S0: Spontaneous liabilities divided by current sales. Payables and accrued expenses often rise as purchases and payroll rise.
• PM x S1 x RR: Projected net profit margin times projected sales times the retention ratio. This is the addition to retained earnings.

The result is a dollar amount, not a rate. If AFN is $124,000, the forecast says the business needs $124,000 from external sources unless the assumptions change. If AFN is below zero, the formula says retained earnings and spontaneous liabilities cover the modeled asset growth.

The formula should use only assets that really vary with sales. Excess cash, idle land, old investments, or a facility that already has unused capacity may not need to rise with sales. The same care applies to liabilities: selected borrowing is not spontaneous support because management chooses that financing.

According to Introduction to Financial Analysis, EFN equals required asset growth less spontaneous liabilities and retained earnings.

Because AFN scales growth against assets, Debt to Asset Calculator is a useful follow-up for checking how much of the asset base is already debt-financed.

AFN is easier to use when each input is tied to an actual planning assumption instead of copied from total balance-sheet lines.

The model separates operating support from financing choices. Spontaneous liabilities are not the same as a new loan. They are tied to normal operations and usually appear because purchases, payroll, taxes, or other accrued costs move with sales.

Retained earnings depend on both profitability and payout policy. A company can grow sales quickly and still have a high AFN if margins are thin or owners distribute most of the earnings.

When spontaneous liabilities are a major input, Current Ratio Calculator adds a short-term liquidity check using current assets and current liabilities.

Use one forecast period at a time and keep the accounting basis consistent across all inputs.

1. 1 Enter current and projected sales: Use the same revenue definition for S0 and S1, such as net sales from the income statement.
2. 2 Enter assets tied to sales: Include receivables, inventory, and capacity-linked operating assets that need to rise with the sales plan.
3. 3 Enter spontaneous liabilities: Use operating payables and accruals that normally increase with activity, excluding planned borrowing.
4. 4 Add margin and retention: Enter projected net profit margin and the percent of earnings retained after distributions.
5. 5 Review the bridge: Compare required assets, spontaneous liabilities, retained earnings, and the final AFN amount before choosing a funding source.

For a board planning package, run a base case, downside case, and stretch case. Keep the sales-linked asset assumptions visible so reviewers can see whether the funding gap comes from growth, asset intensity, weak margins, or payout policy.

Before choosing debt for a positive AFN result, Net Debt Calculator compares borrowings with cash and equivalents.

The calculator gives finance teams a compact way to connect sales goals with balance-sheet and funding consequences.

• • Connect growth to capital: A sales target becomes a dollar estimate of asset investment and external financing need.
• • Compare scenarios: Changing sales growth, margin, or retention shows which lever has the largest effect on the financing gap.
• • Prepare lender conversations: The bridge helps explain why a credit line, term debt, or equity contribution is being considered.
• • Check payout policy: The retained earnings line shows how dividends or owner draws affect growth funding.
• • Document assumptions: Separate outputs for assets, liabilities, and retained earnings make the forecast easier to review.

This AFN calculator is most useful before building a full pro forma balance sheet. It gives a quick first estimate, then the detailed model can refine capacity, taxes, interest, inventory timing, and financing terms.

For capital-structure planning after an AFN estimate, Debt to Equity Calculator compares total debt with shareholder equity.

Small changes in operating assumptions can move AFN materially, especially when sales growth is high.

• • The percentage-of-sales model assumes selected ratios stay constant. It can mislead when pricing, credit policy, inventory turns, supplier terms, or capacity utilization are changing.
• • The basic formula does not model interest, dividends, taxes, issuance costs, or circular financing feedback from the new funds raised.

Use AFN as a planning screen, then reconcile it to a pro forma income statement, balance sheet, and cash-flow forecast. The SEC guide is a useful reminder that sales, assets, liabilities, and cash flows come from related statements rather than one isolated report.

When the result is large, test the assumptions before treating the number as a financing request. Ask whether the company can collect faster, turn inventory faster, delay nonessential capital spending, retain more earnings, or negotiate operating terms without damaging the business.

According to Winkler, Financial Education and Practice, the AFN equation uses assets per dollar of sales, spontaneous liabilities per dollar of sales, sales change, and additions to retained earnings.

According to SEC Beginners Guide to Financial Statements, balance sheets, income statements, and cash-flow statements provide related but different views of assets, liabilities, sales, net income, and cash movement.

If the new funds support a defined project, Return on Investment Calculator helps compare the funding need with expected investment returns.