An AFN calculator works out the additional funds needed by a company: the money it must raise from outside because its assets grow faster than the funding that comes from its liabilities and from its retained profits. Enter the change in assets, in liabilities and in retained earnings, and the calculator gives the additional funds needed. It uses a simplified form of the standard additional funds needed idea, which is our own working. [1] It runs in your browser and nothing you enter is sent anywhere.
How to use the AFN calculator
- Enter the change in assets over the period.
- Enter the change in liabilities.
- Enter the change in retained earnings.
- Press Work out the funds needed.
The formula
The formula is simple: the additional funds needed equal the change in assets, minus the change in liabilities, minus the change in retained earnings. A growing company needs more assets, such as stock, equipment and money owed by customers. Part of the growth is paid for by liabilities that grow with it, such as money owed to suppliers, and part by the profit that the company keeps. Whatever is left must come from new loans or new shares, and that is the additional funds needed. Spontaneous liabilities are those that move with the level of sales, mainly accounts payable. [1]
Changes, not totals
Each change is the ending value minus the beginning value. If assets are 20,000 lower at the end of the period, the change in assets is minus 20,000. The calculator accepts negative numbers for this reason. Retained earnings are the accumulated net income that a company keeps, which is the opening balance plus net profit minus dividends paid. [2] Assets equal liabilities plus equity, so equity is what is left of the assets after liabilities. [3]
Worked example
Our worked example is a company whose assets grow by 500,000. Its liabilities grow by 250,000 and its retained earnings by 50,000. The additional funds needed are 500,000 minus 250,000 minus 50,000, which is 200,000. The company must find 200,000 from outside sources, such as a bank loan or a share issue, to pay for its growth. If the result were negative, the company would have more funding than it needs, and would have a surplus.
The fuller version of the formula
Textbooks often write the AFN in terms of sales, using the ratio of assets to sales, the ratio of spontaneous liabilities to sales, the profit margin and the payout ratio. The fuller form uses the asset ratio and the liability ratio times the change in sales, minus projected net income times the retention rate. [1] This calculator has no terms for sales growth, margins or payout. It is the simple difference of the three changes. If you have your forecasts for assets, liabilities and retained earnings, this is enough.
Using the result
The AFN tells a finance team how much money to plan for. A large positive number may call for a loan or an issue of shares, or for slower growth. A negative number means the growth can be funded from within. Compare the result with the facilities you have, and with the cost of borrowing, before you decide how to fund the growth.
Reading the result
The calculator shows the additional funds needed. A positive amount is the sum that the company must raise from outside the business. A negative amount means that the changes in liabilities and retained earnings are more than enough to pay for the change in assets, and the calculator adds a note to say that the company has a surplus. A result of zero means that the growth pays for itself.
Planning with the AFN
Finance teams use the AFN when they plan growth. They forecast how much the assets will need to grow for a given increase in sales, how much the liabilities will grow with it, and how much profit will be kept. The difference tells them how much to borrow or to raise. Try different forecasts of the three changes, such as a fast-growth plan and a slow-growth plan, and compare the funds needed in each.
Sources of funds
The extra money can come from new bank loans, from bonds, from issuing shares, or from keeping more of the profit by paying lower dividends. Each source has a cost and a risk. The AFN only gives the amount, and the choice of source depends on the interest rates, the company's debt and the wishes of its owners.
An everyday way to think about it
Think of a small shop that wants to open a second counter. The counter needs shelves and stock, which are new assets. The supplier lets the shop pay later for some of the stock, which is a new liability, and the shop puts some of this year's profit back in, which raises its retained earnings. If the shelves and stock cost more than the supplier credit and the profit together, the shop must find the rest elsewhere, perhaps from a bank. That rest is the additional funds needed, and the calculator does this sum for a business of any size.
Checking your inputs
Take the figures from the balance sheets at the start and the end of the period, and subtract the first from the second for each item. For retained earnings, you can check the change against the net income minus the dividends of the period. If these do not agree, look for other entries that changed the retained earnings. Use the same currency and units for every input.
Common mistakes
- Using the totals. Use the changes over the period.
- Forgetting the sign. A fall in assets is negative.
- Counting dividends as retained earnings. Retained earnings are what is left after dividends.
- Mixing periods. Use the same period for all three changes.
What next
Use this often? Add AFN to your Home screen.
Frequently asked questions
What is an AFN calculator?
A tool that works out the additional funds a company needs to finance its growth.
What is the AFN formula?
AFN = change in assets − change in liabilities − change in retained earnings.
What is the AFN in the worked example?
500,000 − 250,000 − 50,000 = 200,000.
What is a change in assets?
The ending value minus the beginning value. It is negative if assets fall.
What does a negative AFN mean?
The company has more funding than it needs, so it has a surplus.
Sources
Was this tool helpful?
What went wrong?
We only receive the reason you pick, never what you typed into the tool.
Thanks for your feedback.