This Sales Tax Decalculator Excel Template will help you compute the pre-tax price of a product or service given the total price and tax rate. This simple Excel calculator is designed for anyone who wants to quickly determine the original price of a good or service.
Pre-Tax Price FormulaThe formula for calculating the pre-tax price of a good/service is as follows: Pre-Tax Price = Total Price - [(Total Price / (1 + Tax Rate) x Tax Rate]
How Does This Sales Tax Decalculator Work?Step 1: Divide the total price by one plus tax rate Step 2: Multiply the result from Step 1 by the tax rate Step 3: Subtract Step 2 from total price to get the pre-tax price
More Useful ResourcesBrowse CFI Marketplace's collection of accounting templates to find the next best tool for daily accounting tasks! To learn more about tax and related topics, feel free to check out all available articles and course videos on CFI's website!