You might be wondering if you’re doing all you can to improve your profits. Our profit increase calculator will help you work out how much extra profit your business is capable of.

What does the profit increase calculator do?

The profit increase calculator (Excel, 53 KB) prompts you to enter your existing figures to determine your current net profit based on cash flow and other relevant factors. It then guides you through various performance improvement factors, showing you how minor improvements can impact your profit.

Those performance factors are:

  • Number of potential customers – if you reach more customers, you'll generate more sales, and that translates into increased profits. The profit increase calculator allows you to see how much additional profit you can make by improving your reach by a certain percentage
  • Conversion rate – no business has a 100% conversion rate, so there's always room for improvement. The profit increase calculator shows you how much more profit your business could generate if you improved your conversion rate by a given percentage
  • Number of transactions per customer – as they say, it's cheaper to keep an existing customer than it is to attract a new one. The profit increase calculator allows you to examine how an increase in the number of transactions per customer will increase your profit
  • Average value of each sale – what if you could boost the average value of each sale by five, ten, or even 30%? Use the profit increase calculator to see the potential results
  • Net profit percentage – have you ever wondered what would happen if you could increase your net profit percentage by a few percentage points? The profit increase calculator can answer that question, delivering solid dollar figures based on your existing data.

The profit increase calculator (Excel, 53 KB) automatically computes the number of paying customers. It also calculates total turnover, and resulting net profit based on the figures you enter. As you enter various improvement factors, pay attention to how the resulting net profit improves compared to your current net profit.

Use the profit increase calculator to your advantage

There's always a risk associated with raising prices, making it smart to look beyond price increases to improve your profits. The profit increase calculator allows you to consider other factors. It also allows you to determine how much of an increase you could expect if you were to follow through with key performance improvements.

You may find that you're leaving a lot on the table or that it would make financial sense to invest in some sales training for your staff. You could also use the profit increase calculator to see how expanding your pool of potential customers might affect your bottom line. Depending on your net profit results, you may be able to justify entering a new market or launching a broader marketing campaign.

How to use the profit increase calculator

Our profit increase calculator is a simple spreadsheet that makes it easy to see how minor improvements can translate into increased profits.

Step 1

Download the 'profit increase calculator (Excel, 53 KB)' and open it in Microsoft Excel or another spreadsheet application.

Step 2

Enter your name in the ‘Prepared By’ field. The date is automatically set to today.

Step 3

Look at the example on the left to get a better sense of the calculator's purpose and outcome.

Step 4

Enter your existing sales figures into the ‘Current Performance’ column. This includes the number of potential customers, your existing conversion rate, number of transactions per customer, average value of each sale, and net profit percentage.

Step 5

Next, enter your improvement factor for each of the following:

  • Number of potential customers
  • Conversion rate
  • Number of transactions per customer
  • Average value of each sale
  • Net profit percentage.

Step 6

Experiment with different improvement factors to see their potential improvement on your profit. To isolate one improvement factor at a time, enter '0' in the other improvement factors. Consider using the profit increase calculator in conjunction with your marketing plan to ensure that your marketing investments make the most sense. Will they:

  • Increase the number of potential customers?
  • Improve conversions, and thus the number of actual paying customers?
  • Help increase the number of transactions per customer?
  • Increase the average value of each sale?
  • Help boost your net profit?

Important information

The information contained in this article is correct as of July 2018 and is intended to be of a general nature only. It has been prepared without taking into account any person’s objectives, financial situation or needs. Before acting on this information, NAB recommends that you consider whether it is appropriate for your circumstances. NAB recommends that you seek independent legal, financial, and taxation advice before acting on any information in this article.

Want to keep exploring?

Other business moments

​Understanding and managing your cash flow

Learn how to manage and improve your cash flow by understanding your cash cycles and setting cash goals.

​How to use our sales forecast template

Help predict your future sales, overheads and profits with this easy-to-use sales forecast template.

Using our business financial health check tool

Our business health check is a quick and easy tool to identify potential issues in your business, and what you can do to fix them.

After more?

Loans and finance

Make it easy for your customers to pay their bills with our range of billing solutions.

NAB QuickBiz Loan

Fast, unsecured business lending made easy, giving you access to funds to grow, run and invest in your business.

Calculators

Starting a business or looking to expand? Our range of business loans, overdrafts, equipment and trade finance options can help you achieve your goals.

Let's talk

We're ready to help you

Request a call back
Call 13 10 12

Mon-Fri 8am - 8pm (AEST/AEDT)
Sat-Sun 9am - 6pm (AEST/AEDT)

Talk to an expert