The formula for markup and margin is as follows
Markup : (MRP - PC) * 100 / PC OR Markup: =SP/CP % and
Margin : (MRP - PC) * 100 / MRP OR Margin: =(SP-CP)/CP %
Please try the above formula in Excel. It should show the following value.
|
Purchase Cost |
MRP |
Markup |
Margin |
|
100000 |
2 |
- 99.998 |
-4999900 |