In times of uncertainty and change, it’s important to consider your business’ balance sheet movements. By forecasting your business’ balance sheet, you will be able to more clearly understand what you’re likely to own or owe at a certain date, allowing you to plan for future business decisions.
Inputting your assets
Once you've downloaded the spreadsheet, input the dollar values of your current assets – these are assets that can be converted into cash within 12 months.
Next, input each of your fixed assets – those that can’t easily be changed into cash. Again, the template will automatically calculate your total fixed assets and your total assets.
Be sure to include all your current and fixed assets in this section.
Including your liabilities
Enter each of your current liabilities. Current liabilities need to be settled in cash by your business within the next 12 months. Ignore the fields that aren’t relevant. Do the same with your long-term liabilities – those liabilities due after 12 months.
The template will total both these columns and calculate the amount of your total liabilities.Both your current liabilities and long-term liabilities should be included here.
Adding your equity
Lastly, enter any goodwill and owner’s equity you have in your business, plus any retained earnings from your previous year’s operations if applicable.
Goodwill is an intangible asset that relates to the perceived value of such assets as:
- your brand
- the quality of your business relationships
- your reputation.
Retained earnings is the portion of net income from your business that is retained by the business, once dividends have been paid out. This template will automatically calculate your total equity and key liquidity indicators (current asset and quick asset ratios). These help understand the value of the business as well as its ability to pay its current liabilities.
Goodwill, owner’s equity and retained earnings are all part of your equity in this section.
Next steps
Related articles
How to calculate your business’ break-even point
Given changing business scenarios and market conditions, it’s important to know your business’ break-even point to help you decide pricing strategies, set budgets and readjust your business plan.
How to forecast your business’ profit and loss
Different events can change your idea of how much money your business will make over the next year. Likewise, your view of the business expenses you will incur during the coming 12 months may have varied. Use our profit and loss template to help forecast for the year ahead.
Get in touch
Any advice does not take into account your personal needs, financial circumstances or objectives and you should consider whether it is appropriate for you.
ANZ recommends you read the applicable Terms and Conditions and the ANZ Financial Services Guide (PDF 104kB) before acquiring the product.
This page contains only general information which is subject to change and is not a substitute for commercial judgement or professional advice. This information does not take into account your personal and financial needs, particular objectives and/or circumstances, and you should seek appropriate independent advice (which may include property, legal, financial, taxation and accounting advice) before making any decisions, investing, or acting on it.
Tools, templates, checklists, and calculators (“ANZ Tools”) linked or referred to on this page, are only some of many ways to analyse a business or industry, or to assist your planning and business decision making. You should seek the assistance of your accountant, business or other advisor when either planning for or analysing your business.
To the extent permitted by law, all members of the ANZ group of companies, their employees, officers and contractors (“ANZ“), offer no warranty and disclaim liability or responsibility to any person for any actions, claims, costs, demands, liability, or direct or indirect losses or damage that may result from using or relying on the information set out in the anz.com pages or the ANZ Tools, and / or any act, omission or error, by any person in relation to them. To the extent permitted by law, ANZ makes no warranty and has no liability in respect of your use and reliance. ANZ Tools are also subject in many cases to further specific cautionary wording and disclaimers which you should read.
ANZ tools, templates and checklists are only some of many ways to analyse a business or industry to assist your planning and business decision making. You should seek the assistance of your business advisor or accountant when either planning for or analysing your business' performance. To the extent permitted by law, ANZ makes no warranty and has no liability, in respect of your use of and reliance on these tools.