Additional Funds Needed (AFN) Calculator

The Additional Funds Needed (AFN) Calculator estimates whether a growth plan creates an external financing gap. It compares the expected increase in assets with the financing already supplied by increased liabilities and retained earnings. If assets grow by more than those internal or already-planned financing sources, the company needs additional funds. If liabilities plus retained earnings exceed the asset increase, the plan shows a surplus.

This page follows the calculator’s calculation exactly. Some corporate-finance textbooks calculate AFN with a percentage-of-sales model that starts from forecast revenue, asset intensity, spontaneous liabilities, profit margin, and retention ratio. This form is more direct: it asks for the forecast change in assets, forecast change in liabilities, and forecast change in retained earnings. That makes it useful after you have already prepared a high-level forecast or scenario. For related checks, pair it with the sustainable growth rate calculator, Altman Z-Score calculator, and MVA calculator.

How to use the calculator

Enter the expected change in assets first. This is the additional asset base needed to support the plan: inventory, receivables, equipment, software, cash balances, or other operating assets depending on your forecast. The calculator requires this value to be zero or positive. If assets are expected to shrink, this particular form does not model that case.

Next, enter the change in liabilities that will help finance those assets. This might include spontaneous operating liabilities such as accounts payable and accrued expenses, or financing that is already assumed in the plan. Be deliberate: not every liability increase is a stable funding source. A one-month payable stretch is not the same as permanent supplier credit or long-term debt. The form treats the liability increase as available financing and subtracts it from the asset increase.

Finally, enter the change in retained earnings. This is profit kept in the business after dividends or owner distributions. The calculator subtracts retained earnings because internally generated capital reduces the need for external funds. If you need to estimate the retention capacity first, use the sustainable growth rate calculator, which reports retained earnings, retention ratio, and ROE from net income, dividends, and equity.

Formula used by this calculator

The direct-input AFN formula is:

$\text{AFN} = \Delta\text{assets} - \Delta\text{liabilities} - \Delta\text{retained earnings}$

The calculator also groups liabilities and retained earnings as available funding:

$\text{available funding} = \Delta\text{liabilities} + \Delta\text{retained earnings}$

If AFN is positive or zero, the primary label is Additional funds needed, and the value is displayed as the absolute dollar amount. If AFN is negative, the primary label changes to Estimated surplus, and the result is the absolute value of the surplus. The copy text still preserves the signed calculation.

Example

The default scenario assumes a $500,000 increase in assets, a $250,000 increase in liabilities, and a $50,000 increase in retained earnings. The calculator first combines the internal and already-available funding:

$\text{available funding} = \$250{,}000 + \$50{,}000 = \$300{,}000$

Then it subtracts that amount from asset growth:

$\text{AFN} = \$500{,}000 - \$250{,}000 - \$50{,}000 = \$200{,}000$

The output is $200,000 of Additional Funds Needed. The supporting items show $500,000 of asset growth, $300,000 of liabilities plus retained earnings, and $200,000 of external financing needed. The note says the asset increase exceeds available liabilities and retained earnings by $200,000.

Now reverse the situation. If a smaller plan required $75,000 more assets, while liabilities rose $60,000 and retained earnings rose $25,000, the formula would be $75,000 - $60,000 - $25,000 = -$10,000. The calculator would display an Estimated surplus of $10,000. That surplus is not a promise that cash arrives at the right day or month; it only says the forecasted financing sources exceed the forecasted asset increase in total.

Interpreting a positive AFN

A positive AFN is a planning signal. It means management must close the gap with new debt, new equity, asset sales, lower dividends, better working-capital efficiency, slower growth, or higher margins. The best choice depends on cost, control, risk, and timing. Debt can be cheaper than equity but adds covenants and repayment obligations. Equity can strengthen the balance sheet but dilutes existing owners. Slower growth can protect liquidity but may sacrifice market share.

AFN is especially useful when a company is growing quickly. Sales growth often requires receivables, inventory, and capacity before cash collections fully arrive. A profitable company can still need outside financing if working capital and capital expenditures absorb cash faster than retained earnings accumulate. Use the accrual ratio calculator to check whether earnings are translating into cash, the debt-to-equity calculator to review leverage capacity, and the loan calculator to estimate debt service if borrowing is the likely solution.

Interpreting a negative AFN

A negative AFN means the forecasted liability increase and retained earnings are larger than the required asset increase. That can happen when margins are strong, dividends are low, suppliers finance more of the operating cycle, or growth is modest. It may indicate capacity for debt repayment, dividends, buybacks, cash reserves, or additional investment.

Do not overread a negative number. The calculator does not model the calendar. Retained earnings might be earned late in the year, while inventory must be purchased early. Liabilities might be due before receivables are collected. A full cash budget can show a temporary revolver need even when the annual AFN is negative. AFN is a first-pass financing screen; treasury planning still needs month-by-month cash flows.

Caveats and data quality

This form accepts only nonnegative inputs. It does not handle shrinking assets, liability paydowns, or retained losses directly. If your forecast includes a decline in liabilities, you may need a custom model rather than forcing the number into this calculator. The form also treats all liability growth as available funding, so analysts should separate spontaneous operating liabilities from discretionary borrowing and from overdue payables that may signal stress.

Finally, AFN is only as good as the forecast. Asset growth depends on sales mix, inventory turns, collection terms, capacity utilization, and capital expenditure timing. Retained earnings depend on margins, taxes, interest costs, and dividend policy. A single AFN number should lead to scenario analysis: base case, high-growth case, margin-pressure case, and delayed-collection case.

Displayed results use the currency, time period, percentage, or other units named in the tool and round only for presentation; retain additional precision when carrying a result into another calculation.

Sources

• NYU Stern, Aswath Damodaran, Definitions — corporate-finance definitions and financing context.
• Corporate Finance Institute, Financial Forecasting — forecasting context for business planning.
• Wall Street Prep, Financial Modeling — financial-modeling workflow and forecast structure.