ALL BUSINESS ENGLISH ARTICLES MICROSOFT EXCEL TIPS

How to calculate discount, sale price and profit margin after discount?

How to calculate discount, sale price and profit margin after discount?
1) Find the original price (for example 90€)
2) Get the discount percentage (for example 20%)
3) Calculate the savings: 20% of 90€ = 18€.
4) Subtract the savings from the original price to get the sale price: 90€ – 18€ = 72€.
5) Subtract Buy Price from the Sale Price and divide it by Sale Price to get the Profit margin after discount: (72€ – 50€)/72€=30,56%
You’re all set!
Views: 1

Comments are closed.

Pin It