Sales Tax Decalculator

This article gives you a free Sales Tax Decalculator template to use in Excel.

Written by CFI Team

Published August 6, 2019

Read Time 2 minutes

Earn Your Certification

What is a Sales Tax Decalculator?

A sales tax decalculator will tell you the pre-tax price of a good or service when the total price and tax rate are known.

You can download our free Excel template to determine the pre-tax price.

How the Sales Tax Decalculator Works

The Excel sales tax decalculator works by using a formula that takes the following steps:

Step 1: Take the total price and divide it by one plus the tax rate.

Step 2: Multiply the result from step one by the tax rate to get the amount of tax.

Step 3: Subtract the tax from step 2 from the total price.

Sales Tax Decalculator Template Screenshot

Download the Free Sales Tax Decalculator Template

Download CFI’s Sales Tax Decalculator template to advance your finance knowledge and perform better financial analysis.

Pre-Tax Price Formula Used by the Excel Decalculator

Here is the formula for decalculating the tax or determining the pre-tax price of the good/service.

Pre-Tax Price = TP – [(TP / (1 + r) x r]

Where:

TP = Total Price
r = Tax rate

Earn Your Certification

Additional Resources

Thank you for reading CFI’s guide to the Excel sales tax decalculator. If you want to become an Excel power user, please check out our Excel Resources to learn all the most important functions, formulas, shortcuts, tips, and tricks.

See all Accounting resources