← All prebuilt solutions
Planning & Finance

Price Increase Impact Calculator

What a price rise does to your profit – how many customers you could lose and still be better off, product by product

£20

Secure checkout. Your file is ready in your client portal as soon as payment clears.

Price Increase Impact Calculator

Overview

Putting prices up is one of the quickest ways to improve profit, but the fear of losing customers stops many businesses. This workbook puts numbers on that fear.

Price
£20
Who it’s for
Planning & Finance
Works with
Microsoft Excel for Windows and Mac
Buy now

See how it works

A walk through the main sheets

The sheets you will use most, in the order you will use them – shown with the sample data every workbook comes with.

Step 1

Products

Each product's price, cost and volume, with the proposed change. What you do: one row per product.

Products
What-If Grid

Step 2

What-If Grid

Profit at different price and volume changes. What you do: nothing to enter.

Step 3

Settings

Your business and default assumptions. What you do: fill in once.

Settings

Step 4

Who it is for

Made for people like you

  • Example – text
  • Businesses facing rising costs – Decide how much to put prices up.
  • Shops, cafés and service businesses – Test price changes product by product.
  • Accountants and advisers – Show clients the maths of a price rise.

Quick start

Up and running in minutes

  1. Example – text
  1. Settings – Fixed costs and, if you know it, how much your costs are rising this year.
  2. Products – Price, variable cost and yearly units for each product, then the rise you are considering and the share of units you think you might lose.
  3. Dashboard and grid – The effect on profit and the volume you can afford to lose.

Key features

  • Works out what a price rise does to contribution and profit, product by product, allowing for the customers or units you expect to lose.
  • Shows how much volume each product can lose before the rise leaves you worse off – and the rise needed just to keep up with rising costs.
  • Includes a what-if grid of price rises against lost sales, coloured to show where you are better or worse off.

What’s included

  • Dashboard – Profit now and after
  • Settings – Fixed costs and cost inflation
  • Products – Product by product
  • What-If Grid – Price rise against lost sales
  • Guide – How to use this workbook

How buying works

Your file is only released to your client portal once payment has cleared.

1

Click Buy now

You are taken to our secure checkout.

2

Pay securely

Checkout takes a minute and you get a receipt by email.

3

Download your file

Your file is ready in your client portal as soon as payment clears, and we email you your invoice with a link to the portal.

Explore the range

Need it tailored to your business?

We can adapt any prebuilt solution or build something bespoke, with a lifetime bug-free guarantee.

Part of AML Finance Group

Need an accountant too?

Our sister firm, AML Accountancy Solutions, is an award-winning accountancy practice helping businesses and individuals across the UK with their accounts, tax, bookkeeping and payroll.

Visit AML Accountancy Solutions