skip to log on skip to main content
VoiceOver users please use the tab key when navigating expanded menus
Article related to:

Run

Small business profit and loss forecasts and templates

2024-01-29 00:00

Key points

  • Use financial forecasting forecast to make predictions over the coming financial year
  • Have a clear expectation of your income, cost of goods sold, and expenses
  • Get started with our profit and loss template

Our profit and loss template will help you with financial forecasting for the year ahead. Set yourself up for business success by having a clear expectation of how much you will make and the expenses you will incur during the coming 12 months.

Use our profit and loss template

Financial forecasting is used to predict profit and losses over the coming financial year.

Alongside your balance sheet and cash flow statement, financial forecasting is one of the key elements of setting up your business financially. 

Download our Profit and loss template (xls 1.5MB) to start your financial forecasting for the year ahead.

Begin by focusing on predictions for next month for each of the key sections: income, cost of goods sold and expenses. Then continue estimating your sales and expenses for the next six or 12 months.

Income

The first part of financial forecasting involves predicting sales.

Begin by focusing on next month:

  • Enter your predicted sales for the upcoming month
  • Add any sales returns you usually have
  • Factor in any discounts to be applied

Continue inputting any additional income streams you may have. The template will automatically make the calculations for you, so enter each amount as a positive number.

Cost of goods sold

Next, enter your stock level at the start of the month and add stock purchases plus other costs associated with your goods. 

Input your predicted stock level for the end of the month. The template will calculate the estimated total cost of goods sold and gross profit for the month.

Expenses

The bottom half of the template deals with expenses – your selling, administrative and finance expenses. Navigate down the list entering all relevant expenses, which will be calculated by the template.

Input any interest expenses and hire purchase charges to calculate your profit before tax. Lastly, enter the estimated tax you’ll pay for the month and your net profit will be calculated at the bottom.

The last column will total all your monthly sales, expenses, interest and tax data into a half-year or annual amount. 

Lastly, calculate your likely expenses over the appropriate period of time.

Get started with our profit and loss template

Download our Profit and loss template (xls 1.5MB) to start your financial forecasting for the year ahead.
 

anzcomau:content-hubs/business-hub/run,anzcomau:content-hubs/business-hub/run-business-finances,anzcomau:content-hubs/business-hub/financial-management
Small business profit and loss forecasts and templates
2024-01-29
/content/dam/anzcomau/images/business/smiling-casual-man-artist-looking-paper-coffee-headphone_Small-hero.jpg

Related articles

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) 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.

Top