1 / 16

Trade Discount Series

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.

faylinn
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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Trade Discount Series Using Excel

  2. 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

  3. Set Up Labels

  4. Enter List Price and Discounts Be sure and typethe % signs

  5. Enter First Discount Formula(Use Cell References) Don’t forget to hit Enter after entering

  6. RESULTS: Enter First Discount Formula(Use Cell References) How much is saved for 1st discount

  7. Find New List PriceOriginal List Price – Discount

  8. RESULTS: Find New List PriceOriginal List Price – Discount After 1st discount, new price of item is $560

  9. Discount on “NEW” List Price

  10. RESULT: Discount on “NEW” List Price How much is saved for 2nd discount

  11. “New” List Price Be sure and subtract previous new price

  12. RESULTS: “New” List Price

  13. Final Discount

  14. RESULTS: Final Discount

  15. Final Price

  16. RESULTS: Final Price This is the Final price the buyer has to pay after a 20/10/10 trade discount series

More Related