Trade discount series l.jpg
This presentation is the property of its rightful owner.
Sponsored Links
1 / 16

Trade Discount Series PowerPoint PPT Presentation


  • 107 Views
  • Uploaded on
  • Presentation posted in: General

Trade Discount Series. Using Excel. Trade Discount Series. Also called “chain” discount Seller offers more than one discount one after the other Format: 20/10/10 which means 20%, 10% and 10% taken off in series. Set Up Labels. Enter List Price and Discounts. Be sure and type the % signs.

Download Presentation

Trade Discount Series

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Trade discount series l.jpg

Trade Discount Series

Using Excel


Trade discount series2 l.jpg

Trade Discount Series

  • Also called “chain” discount

  • Seller offers more than one discount one after the other

  • Format: 20/10/10 which means 20%, 10% and 10% taken off in series


Set up labels l.jpg

Set Up Labels


Enter list price and discounts l.jpg

Enter List Price and Discounts

Be sure and typethe % signs


Enter first discount formula use cell references l.jpg

Enter First Discount Formula(Use Cell References)

Don’t forget to hit Enter after entering


Results enter first discount formula use cell references l.jpg

RESULTS: Enter First Discount Formula(Use Cell References)

How much is saved for 1st discount


Find new list price original list price discount l.jpg

Find New List PriceOriginal List Price – Discount


Results find new list price original list price discount l.jpg

RESULTS: Find New List PriceOriginal List Price – Discount

After 1st discount, new price of item is $560


Discount on new list price l.jpg

Discount on “NEW” List Price


Result discount on new list price l.jpg

RESULT: Discount on “NEW” List Price

How much is saved for 2nd discount


New list price l.jpg

“New” List Price

Be sure and subtract previous new price


Results new list price l.jpg

RESULTS: “New” List Price


Final discount l.jpg

Final Discount


Results final discount l.jpg

RESULTS: Final Discount


Final price l.jpg

Final Price


Results final price l.jpg

RESULTS: Final Price

This is the Final price the buyer has to pay after a 20/10/10 trade discount series


  • Login