Sales Tax Decalculator Template
This sales tax decalculator template will help you calculate the pre-tax price of a good or service when the total price and tax rate are known.
This is what the sales tax decalculator looks like:
Download the Free Template
Enter your name and email in the form below and download the free template now!
Pre-tax price formula
Here is the formula for de-calculating 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
How the decalculator works
The Excel de-calculator 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 dollars of tax
Step 3: subtract the dollars of tax from step 2 from the total price
More Free Templates
For more resources, check out our business templates library to download numerous free Excel modeling, PowerPoint presentation and Word document templates.
- Excel Modeling TemplatesExcel & Financial Model TemplatesThis sales tax decalculator template will help you calculate the pre-tax price of a good or service when the total price and tax rate are known. Pre-tax price formula Here is the formula for de-calculating the tax, or determining the pre-tax price of the good/service. Pre-Tax Price = TP – [(TP x (1 – r) x r] Where: TP
- PowerPoint Presentation TemplatesPresentationsThis sales tax decalculator template will help you calculate the pre-tax price of a good or service when the total price and tax rate are known. Pre-tax price formula Here is the formula for de-calculating the tax, or determining the pre-tax price of the good/service. Pre-Tax Price = TP – [(TP x (1 – r) x r] Where: TP
- Transaction Document TemplatesTransactionsThis sales tax decalculator template will help you calculate the pre-tax price of a good or service when the total price and tax rate are known. Pre-tax price formula Here is the formula for de-calculating the tax, or determining the pre-tax price of the good/service. Pre-Tax Price = TP – [(TP x (1 – r) x r] Where: TP
