How to calculate Profit Margin %
DanielRose
Registered Posts: 2 New contributor 🐸
Hi guys, I would really appreciate some help here: I don't understand the method for adding profit margin % onto the total price of a quotation.
Could someone please explain why it is done like that?
I would have assumed that I would be able to calculate it in the same way that I would calculate VAT inclusive from VAT exclusive. But that doesn't give me the correct figure.
Many thanks!
Could someone please explain why it is done like that?
I would have assumed that I would be able to calculate it in the same way that I would calculate VAT inclusive from VAT exclusive. But that doesn't give me the correct figure.
Many thanks!
0
Comments
-
If I remember correctly, you need to get the total amount for the quotation (total revenue) and then minus any expenses. Then the total you divide by the original amount (total revenue) and then times it by 100. So for example say it the quote was for 100. We would do 100 - any expenses like COS, rent, electricity etc. Then we would divide that amount by the total revenue which would be 100 and then times the amount calculated by 100.
E.G: 100-30 comes to 70/100*100 = 70% Profit Margin.0 -
Hi @DanielRose
I hope you are well?
Not too sure if this is correct or if it is what you meant.
So let's say your costs are £100 but you want a 20% profit Margin. So we would do 1 - 0.2 = 0.8. Then you would do £100 / (Divide By) 0.8 = £125. So if you took 20% off £125 it would be £100.
In simple the 1 just represents 100% as a decimal and then minus by your required profit margin (again as a decimal) then divide by the difference.
Another example - 25% Profit Margin of £50. So it would be 1- 25 = 0.75. So we would £50 / (Divide by) 0.75 = £66.67. If you take off 25% from £66.67 you will get back to £50.
Hopefully this is what you meant?
Kind regards
Shamil1
Categories
- All Categories
- 1.2K Books to buy and sell
- 2.3K General discussion
- 12.5K For AAT students
- 348 NEW! Qualifications 2022
- 168 General Qualifications 2022 discussion
- 15 AAT Level 2 Certificate in Accounting
- 64 AAT Level 3 Diploma in Accounting
- 95 AAT Level 4 Diploma in Professional Accounting
- 8.9K For accounting professionals
- 23 coronavirus (Covid-19)
- 273 VAT
- 93 Software
- 275 Tax
- 139 Bookkeeping
- 7.2K General accounting discussion
- 205 AAT member discussion
- 3.8K For everyone
- 38 AAT news and announcements
- 345 Feedback for AAT
- 2.8K Chat and off-topic discussion
- 586 Job postings
- 16 Who can benefit from AAT?
- 36 Where can AAT take me?
- 42 Getting started with AAT
- 26 Finding an AAT training provider
- 48 Distance learning and other ways to study AAT
- 25 Apprenticeships
- 66 AAT membership