Today's lesson on how to use percentage change, mark-ups and discount formulas

In today's lesson, we're going to learn how to use percentage formulas to calculate:

a) percentage changes

b) % mark-ups and 

c) % discounts 

                                      all vital to business transactions and dealings.

To access the Excel spreadsheet, please click on this link.


                                                Percentage change formula:

Percentage markup:

Percentage discount:

Sale price = Marked Price x (1- % Discount)

% Discount= (Sale price - Marked Price) / Marked Price