trade discount series
Download
Skip this Video
Download Presentation
Trade Discount Series

Loading in 2 Seconds...

play fullscreen
1 / 16

Trade Discount Series - PowerPoint PPT Presentation


  • 133 Views
  • Uploaded on

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.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Trade Discount Series' - faylinn


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 series2
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
enter list price and discounts
Enter List Price and Discounts

Be sure and typethe % signs

enter first discount formula use cell references
Enter First Discount Formula(Use Cell References)

Don’t forget to hit Enter after entering

results find new list price original list price discount
RESULTS: Find New List PriceOriginal List Price – Discount

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

result discount on new list price
RESULT: Discount on “NEW” List Price

How much is saved for 2nd discount

new list price
“New” List Price

Be sure and subtract previous new price

results final price
RESULTS: Final Price

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

ad