Chain Discount Calculator

Chain discounts are multiple discounts which a business offers on its original list price. They are useful in encouraging customers to take certain actions such as to making a volume purchase. This chain discount calculator is useful for calculating the net price of a product after deducting a series of discounts.

If you need further information on the use of chain discounts and the calculations they involve this is more fully discussed in our chain discounts in accounting tutorial.

chain discount calculator v 1.0
Chain Discount Calculator Preview

Instructions

The Excel chain discount calculator, available for download below, is used by entering details of the original list price and up to five discount percentages. The calculator works out the net price of the product after deducting the discounts and also calculates the single equivalent discount rate (SED) for the chain discount. To use the calculator enter the details as follows:

Step 1

Enter the original list price of the product.

Step 2

Enter up to five discount percentages. For example, if the business offers 25% trade discount on a particular product and then a further 10% for purchasing in bulk quantities (normally quoted as 25/10%), then enter 25% in column B and 10% in column C, and leave the other discount percentages blank or enter 0%.

For each percentage the calculator works out the discount given and the net price after that particular chain discount. The chain discount calculator also provides a summary showing the list price, total discount and net price to be paid.

Finally, the single equivalent discount rate (SED) is calculated. The SED represents the discount rate which when applied to the original price results in the same net price and total discount as applying the chain of discounts. For example, a chain of two discounts of 25/10% is equivalent to a single discount rate of 32.5%

Chain Discount Calculator Download

The chain discount calculator spreadsheet is available for download in Excel format by following the link below.

The chain discount calculator is one of many financial calculators used in bookkeeping and accounting, discover another at the links below.

Notes and major health warnings
Users use this chain discount calculator at their own risk. We make no warranty or representation as to its accuracy and we are covered by the terms of our legal disclaimer, which you are deemed to have read. This is an example of a series discount calculator that you might use when considering how to calculate chain discounts. It is purely illustrative. This is not intended to reflect general standards or targets for any particular business, company or sector. If you do spot a mistake in this multiple discount calculator, please let us know and we will try to fix it.
Chain Discount Calculator November 6th, 2016Team

You May Also Like


Related pages


aging of accounts receivabledupont roeintangible fixed assets amortisation policycalculate markup from marginprofitability ratios listmarkup calculatorroce financial ratiocalculating wipunearned service revenue still unearned journal entryinternally generated intangible assets examplestemporary accounts accountingformula for calculating future value of annuityexpenses template small businessentry for prepaid insuranceentry for bad debt expensebasics of cash flow statementoverapplied overheadnper 3cost accounting absorptionhow to calculate the contribution margin per unitgeneral ledger xlshow to bookkeep with excelretained earnings statement definitionmarkup on cost formulaaccounting for damaged inventoryrent receivable journal entrypetty cash definition in accountingpv of annuity formulaannuity payment calculatorhow to calculate selling price based on marginclosing entries are madeeffect on accounting equationprepayment accountingare patents intangible assetsexamples of subsidiary ledgersmanufacturing overhead costs includeaccounting unadjusted trial balancedeferred revenue meaningdebtors control accountcogs balance sheetaccounts receivable journal entry examplecash flow statement format in excel indiaamortised cost calculationjournal entry for accrued wagesaccrued revenue entrylist of debits and credits in trial balancestandard costing method examplecalculating factory overheadweighted average method of inventory valuation exampleaccounting wages payablefuture value and present value formulasjournal entry prepaid expensecurrent ratios and quick ratiosgearing ratio accountingbook value formula depreciationhow to calculate a payback periodearnings statement template freecurrent ratio and quick ratio analysispmt function to calculate monthly paymentdefine sundries expensecommon stock exampleimprest moneyentries for bonds payable and installment note transactionsjob order costing formulaguide to bookkeepinghow to calculate bonds payabledebiting and crediting accountsdebit and credit journal entriesdividend growth model excelbalance sheet ratio analysis examplepresent value of an annuity due tablefuture value calculator in excelexcel bookkeeping spreadsheetwhat is common stockholders equityaccounts payable templatescash withdrawal from bank entry in tallyaccounting practice quizformula for turnover ratiobad debt expense methods