Business balance sheet forecast

Forecasting your balance sheet

Key points in this article

  • Current and fixed assets
  • Long-term and current liabilities
  • Calculating your equity in the business

For an idea of what position your balance sheet will be in by the end of the year, download our balance sheet forecaster to estimate your assets and liabilities at a future date.

Once you've downloaded the spreadsheet, first enter the date of your estimation.

Inputting your assets

Input the dollar values of your current assets – these are assets that can be converted into cash within 12 months.

Only fill in the boxes that are applicable to your business. The template will calculate your total current assets.

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 the current liabilities you have. 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 your total liabilities figure.

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 relates to the portion of net income from your business that is retained by the business and not distributed as dividends. 

The template will automatically calculate your total equity as well as your current asset and quick asset ratios.

Goodwill, owner’s equity and retained earnings are all part of your equity in this section

Download the Small Business Hub balance sheet forecasting template now.

Download template

Important information Show more

Australia and New Zealand Banking Group Limited ABN 11 005 357 522 (ANZ). ANZ's colour blue is trade mark of ANZ. This site contains general information only. Its content is for information purposes only, is subject to change and is not a substitute for commercial judgement or professional advice. This material does not take into account your personal and financial needs and/or circumstances, and you should seek appropriate advice (which may include property, legal, financial and/or taxation advice) before making any decisions or acting on any of the information contained in this material. To the extent permitted by law, all members of the ANZ group of companies disclaim liability or responsibility to any person for any direct or indirect loss or damage that may result from relying on the information contained or this site, or any act, omission or error, by any person in relation to the material contained on this site. For further information, see the ANZ Business Hub Terms of Use.