Sales Tax Decalculator Template

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 TemplatesDownload free financial model templates - CFI's spreadsheet library includes a 3 statement financial model template, DCF model, debt schedule, depreciation schedule, capital expenditures, interest, budgets, expenses, forecasting, charts, graphs, timetables, valuation, comparable company analysis, more Excel templates
• PowerPoint Presentation Templates
• Transaction Document TemplatesTransactionsDownload free transaction templates including a Letter of Intent (LOI), Term Sheet, Non-Disclosure Agreement (NDA), Confidential Information Memorandum (CIM), Equity Capital Markets (ECM) memo, Due Diligence checklist, and other types of corporate transactions. Download the Word Document files for your own use