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


fob shipping point means the seller pays cost of freightsales returns and allowances journal entrylifo examplesimple cash receipt templatebookkeeping templatejournal entry of accrued incomepetty cash account definitionsample interview questions and answers for bookkeeperhow to compute asset turnover ratiohow do you calculate beginning inventoryexcel annuity payout calculatorannuity cash flow formulafixed asset turnover ratio industry averageirr of a perpetuitynon profit organization chart templatewhat is provision for doubtful accountscosts of goods sold equationexcel chart of accountsending inventory formula accountingloan balance calculator exceltrial balance definition in accountingexamples of bank reconciliation problemshow to calculate present value annuitytypes of petty cash booknormal balance of revenueendowment fund definitioncapital lease interest ratepayment received in advance journal entryaccrual entriesadjusted trial balance templatecontribution margin vs profit marginasset retirement obligation journal entry examplepv factor of annuitysum of the years digits method of depreciationhow to calculate receivable turnovermanufacturing overhead calculatoraccounting for stockholders equitydeferred tax liability definitionall types of accounting entriesaccounts payable debit or creditpv formulasformula for present value of an annuitypv pmtmarkup vs margingp markup calculatoradjusting entry for accrued revenuevariable cost managerial accountinggeneral entries of accountscurrent assets current liabilities ratio analysiscalculate stock turnoverunearned revenue asset or liabilitybasic accounting t accounts examplesphysical inventory count sheetunearned revenue income statementformulas of simple interest and compound interestbasics of accounts payabledupont ratio analysis examplehow to find fixed cost formulaaccounting horizontal analysisperpetual inventory vs periodic inventoryhow to calculate weighted average inventoryformula for horizontal analysisa chart of accounts for a merchandising businesscumulative cash flow formulaaccrual and prepaymentstable present value of annuitytotal fixed cost formula accountingis petty cash an expenseprepaid insurance on balance sheetnpv excelljob order costing accountingmargin and markup differenceinterest rate formula compounded continuouslyhow to calculate raw materials inventoryformula for roasales and purchase ledgersaccounts payable adjusting entrytotal contribution margin at the break-even pointwhat is contra revenuepresent value and future value formulaaccounts payable report samplenet account receivable formulappe disposalwhat is revenue expendituresdebit note definition accountingbookkeeping source documentsfreight expense accountingcash withdrawal from bank journal entry in tally