The purpose of this pricing for profit calculator is to show the percentage increase in unit sales volume needed for a business to maintain its current gross profit level in the event that it changes its product selling price.
When a business is preparing financial projections for a business plan, and has established a target gross profit level, it is useful to be able to flex the financial projections to understand how a change in product selling price can be compensated for by a change in unit sales volume in order to maintain the same gross profit level. This topic is more fully discussed in our tutorial on pricing for profit in financial projections.
Using the Pricing for Profit Calculator
The pricing calculator is available for download below and is used as follows:
Change in Sales Volume
Enter the gross margin percentage
Enter the current gross margin percentage of the business.
Enter the change in selling price percentage
Enter the change in selling price percentage. For example, if it is planned to raise prices by 5%, then enter 5%. Likewise, if it is proposed to lower prices by 10%, then use a minus sign and enter -10%.
The pricing for profit calculator works out the percentage by which the unit sales volume needs to change in order to compensate for the change in selling price and maintain the same gross profit level.
If you want to see an example, the second part of the spreadsheet headed Gross Profit, allows you to enter details relating to the current selling price and unit sales volume, and demonstrates that the gross profit is the same both before and after the selling price changes.
Enter the product selling price
By entering the current product selling price, the pricing for profit calculator calculates the cost, gross margin, and gross margin percentage for the product both before and after the selling price change.
Enter the unit sales volume
By entering the current unit sales volume, the pricing for profit calculator will also calculate the revised sales volume needed, and calculate the total gross profit to demonstrate that the profit is the same both before and after the selling price change.
Pricing for Profit Calculator Download
The pricing for profit calculator is available for download in Excel format by following the link below.
Users use this pricing calculator at their own risk. We make no warranty or representation as to its accuracy and we are covered by the terms of our legal disclaimer, which you are deemed to have read. This is an example of a pricing calculator template that you might use when preparing financial projections in Excel. It is purely illustrative of a small business accounting calculator. This is not intended to reflect general standards or targets for any particular company or sector. If you do spot a mistake in the financial calculator, please let us know and we will try to fix it.
About the Author
Chartered accountant Michael Brown is the founder and CEO of Plan Projections. He has worked as an accountant and consultant for more than 25 years and has built financial models for all types of industries. He has been the CFO or controller of both small and medium sized companies and has run small businesses of his own. He has been a manager and an auditor with Deloitte, a big 4 accountancy firm, and holds a BSc from Loughborough University.