Download
trade discount series n.
Skip this Video
Loading SlideShow in 5 Seconds..
Trade Discount Series PowerPoint Presentation
Download Presentation
Trade Discount Series

Trade Discount Series

298 Vues Download Presentation
Télécharger la présentation

Trade Discount Series

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