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:
Enter your name and email in the form below and download the free template now!
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]
TP = Total Price
r = Tax rate
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
For more resources, check out our business templates library to download numerous free Excel modeling, PowerPoint presentation and Word document templates.