Additional Funds Needed Calculator

Form

Results

Additional funds needed

0

Table of Contents

1

What is Additional Funds Needed?

Additional funds needed, often shortened to AFN, is the financing gap left after a business compares planned asset growth with the funding already available from additional liabilities and retained earnings. A growing business can report a profit and still need outside money: inventory, receivables or equipment may have to be financed before enough cash becomes available.

This page uses a direct subtraction model. You supply the forecast changes rather than sales-growth percentages, and the calculator returns the part of asset growth that the other two entries do not cover. It is a useful reconciliation of a financing plan, but it is not a cash-flow forecast, a borrowing approval or a recommendation about how to raise capital.

2

How to Use This Calculator

  1. Choose one forecast period, such as the coming financial year, and use it for all three changes. Record opening and forecast closing balances before calculating the differences.
  2. Enter the increase in assets required by the plan. Use the change in assets, rather than the entire closing asset balance, unless you are intentionally modelling a business starting from zero.
  3. Enter the liability increase already expected to fund that growth and the addition to retained earnings after the distributions assumed in your forecast.
  4. Use the same currency and scale for every entry. The currency dropdowns identify money amounts; the calculation does not fetch exchange rates or reconcile different currency selections.
  5. Calculate the gap, then compare it with the proposed borrowing, equity contribution or other financing. Run a second scenario with different asset needs or earnings to see which assumption drives the gap.
3

Formula Used

AFN = ΔAssets − ΔLiabilities − ΔRetained earnings. Each Δ is the change over the same forecast period.
4

Variables Explained

InputMeaning in this calculator
Change in assetsAdditional assets the plan requires, such as receivables, stock and equipment, after any asset reductions included in the forecast.
Change in liabilitiesFunding expected from liabilities within the forecast assumptions. Exclude any new financing that you want AFN to determine, or the calculation becomes circular.
Change in retained earningsThe earnings retained in the business over this period after the distributions used in the plan. This is not necessarily the income statement profit.
Currency selectionsLabels for the amounts entered. Keep every amount in the same currency; the returned currency label follows the assets selection.
5

Worked Example

A business forecasts that assets will increase by 100,000 over the next year. Its operating liabilities are expected to increase by 30,000, while 20,000 of earnings will remain in the business. Enter those changes using one currency. AFN = 100,000 − 30,000 − 20,000 = 50,000. The plan therefore has a 50,000 gap under these assumptions.

Suppose a revised collection policy reduces the required receivables growth by 15,000. Keeping the other inputs unchanged, asset growth becomes 85,000 and AFN falls to 35,000. This does not prove the revised collection policy will work; it shows the funding effect if its assumption holds. Alternatively, if the original asset growth remains 100,000 but retained earnings rise to 35,000, the same 35,000 gap results for a different reason.

6

Why Use This Calculator?

A positive AFN is an amount still to be funded in this simplified plan. It does not tell you whether debt or equity is preferable, what interest rate is available or when money must arrive. A zero result means the three entered changes balance. A negative result means the identified funding exceeds the asset increase; it should prompt a review of the forecast rather than an automatic decision to distribute cash.

Timing deserves a separate worksheet. An annual plan can balance while the business runs short of cash during a seasonal inventory build. Likewise, depreciation changes asset carrying values and retained earnings without being a cash payment in the current period. Use the AFN figure alongside forecast balance sheets and a cash budget, checking that the same transaction has not been counted twice. Currency symbols and decimal places cannot repair inconsistent accounting assumptions.

7

Common Mistakes

    • Do not subtract total liabilities or the accumulated retained earnings balance from asset growth. Changes must be compared with changes.
    • Do not include a proposed loan in liabilities and then interpret the resulting gap as the amount of that same loan required.
    • Distinguish retained profit from total profit: a dividend or owner distribution can reduce what stays available in the business.
    • Avoid mixing thousands with whole currency units, or a year of asset growth with a month of retained earnings.
8

Frequently Asked Questions

Is this the sales-percentage AFN formula?

No. Some forecasting methods estimate asset and spontaneous-liability needs from a sales increase and a profit-margin assumption. This form starts one step later: it expects you to have already estimated the three changes, and then subtracts the identified sources from the asset need.

Does a negative AFN mean the company has spare cash?

It means only that the entered funding changes exceed the entered asset growth. Whether cash is actually available depends on the forecast balance sheet, the timing of receipts and payments, restrictions on funds and other commitments that this three-input model does not describe.

Should planned new equity go into retained earnings?

No. Retained earnings and owner contributions are different financing categories. Calculate the gap with the intended scope clearly defined, then compare proposed equity funding with it separately. Combining the two hides how much financing comes from operations and how much comes from investors.

Are all liabilities spontaneous financing?

No. Trade payables may grow with operating activity, while a new bank loan is a deliberate financing decision. Decide which liabilities your forecast treats as already available before entering the amount. The calculator cannot identify that distinction from a single total.

9

Sources & References

Mini Calculator provides online calculators for multiple niches including mathematical, financial, Health, informative, Chemistry, physics, statistics, and conversions. You can use any calculator for free without any limits.