Discount Calculators

 

These calculators show discounted prices for trade customers depending on their category

 

The figures shown are for illustration

 

Replace the figures in the clear cells with your own.  The calculated results are shown in the shaded cells.

 

Start by entering in the VAT rate and the trade discounts

 

Then enter the retail price for each line item

 

The ex VAT price is then shown, together with the trade discounts

 

Only change the unshaded cells (VAT, Dealer Discount, Distributor Discount, Key Account Discount, Product and Retail price)

 

Each trade discount is a percentage discount based on the previous price (ie Key Acount is 25% of Distributor)

 

Refresh your browser to clear the data and start again.

 

The results cannot be saved, but a copy of the spreadsheet in Excel can be downloaded and saved by selecting the download link

Please allow a few seconds for the calculators to loadDownload calculator

 

Download calculator

Discount Calculator - Non Cumulative

Discount Calculator - Cumulative