Calcipedia

Additional Funds Needed Calculator

Estimate additional funds needed from projected sales growth, operating assets tied to sales, spontaneous liabilities, profit margin, and retained-earnings support.

Last updated

Also in Pricing & Profit

← All Pricing & Profit calculators

Business Finance

Additional funds needed calculator guide: AFN formula, retained earnings support, and external financing gaps

An additional funds needed calculator estimates how much outside financing a business may need when sales are expected to rise. It compares the extra operating assets required to support higher sales with the spontaneous liabilities and retained earnings that can fund part of that growth internally.

What additional funds needed is measuring

Additional funds needed, or AFN, is a planning estimate of the financing gap created by growth. When sales increase, a business often needs more receivables, inventory, and other operating assets. Some of that growth can be supported by payables and accruals that rise with sales, and some can be supported by profit retained in the business.

The AFN result is the amount still left to fund after those internal sources are considered. A positive AFN means the business likely needs new borrowing, new equity, or another external funding source. A negative AFN means the sales plan can be supported internally, or that a lower sales plan may release funds instead of requiring them.

Core AFN formulas

The calculator uses the classic percentage-of-sales AFN approach. It starts with the share of current operating assets that moves with sales and applies that ratio to the planned sales increase. It then subtracts the share of spontaneous liabilities expected to move with sales and the addition to retained earnings expected from the projected profit margin and payout policy.

This makes AFN a useful first-pass planning tool. It is intentionally simple and works best when operating assets and spontaneous liabilities scale roughly with sales and when management wants a quick estimate of the financing gap before building a full forecast model.

Required asset increase = (Operating assets tied to sales / Current sales) x Change in sales

This estimates how much additional operating-asset support is needed for the projected sales plan.

Spontaneous liability increase = (Spontaneous liabilities / Current sales) x Change in sales

This estimates the amount of funding that naturally rises with sales through payables and similar liabilities.

Addition to retained earnings = Projected sales x Profit margin x (1 - Dividend payout ratio)

This estimates how much projected profit is kept inside the business instead of being paid out.

Additional funds needed = Required asset increase - Spontaneous liability increase - Addition to retained earnings

This is the external financing gap left after internal balance-sheet support is applied.

Worked example: growth plan with a financing gap

Suppose current sales are 900,000 and projected sales are 1,200,000, so the sales increase is 300,000. If operating assets tied to sales are 540,000, the asset-to-sales ratio is 60%, which implies 180,000 of required asset growth. If spontaneous liabilities tied to sales are 180,000, the liability-to-sales ratio is 20%, which contributes 60,000 of spontaneous support.

If the projected profit margin is 8% and the dividend payout ratio is 25%, projected net income is 96,000 and retained-earnings support is 72,000. Subtracting 60,000 of spontaneous liability support and 72,000 of retained-earnings support from the 180,000 asset increase leaves AFN of 48,000. That is the estimated external financing need for the sales plan entered.

How to use AFN results

Use AFN to pressure-test growth before finalising budgets, staffing, or capital commitments. If AFN looks too large, the usual levers are to improve profit margin, reduce payout, improve working-capital efficiency, or phase the sales plan so operating assets do not need to rise as quickly.

AFN is not a substitute for a full forecast. It does not model step changes in fixed assets, financing costs, tax changes, or timing differences inside the year. It is best used as an early financing signal that points to whether the sales plan is likely to require outside capital.

Frequently asked questions

What does a positive AFN mean?

A positive AFN means the projected sales plan needs more financing than spontaneous liabilities and retained earnings can provide. The gap usually has to be covered with borrowing, new equity, or another outside funding source.

What does a negative AFN mean?

A negative AFN means internal funding sources are enough to support the plan. In some cases, especially when projected sales fall, the model can show a release of funds instead of a financing need.

Why does the payout ratio matter in AFN?

The payout ratio controls how much projected profit is kept inside the business. A lower payout leaves more retained earnings available to support growth and reduces the external financing gap.

Does AFN include long-term fixed-asset expansion?

Not directly. The standard AFN approach is a sales-linked planning model. If growth requires a new plant, warehouse, or major one-time asset purchase, that extra investment usually has to be layered onto the simple AFN result separately.

Related

More from nearby categories

These related calculators come from the same leaf category, nearby sibling categories, or the same top-level topic.