Hi all,
I'm looking for help with a classic business math question:
“Sales of a semiconductor fabrication plant fell by 25% and Gross Profit increased by 15%. Gross Profit margin increased by ____”
How would you go about calculating this?
Hi all,
I'm looking for help with a classic business math question:
“Sales of a semiconductor fabrication plant fell by 25% and Gross Profit increased by 15%. Gross Profit margin increased by ____”
How would you go about calculating this?
Hi Joël,
I would be happy to share my thoughts on it:
If you would like a more detailed discussion on how to best prepare for your upcoming interviews, please don't hesitate to contact me directly.
Best,
Hagen
This is how I do it mentally. Not sure how much this helps, as this is really about having a lot of mental math training and being able to identify patterns and how to quickly transform numbers into other numbers it is easy to work with. Basically I identified that the 25% reduction in sales is the same as a 33.3% increase in margin (1/0.75 - 1 = 33%)… and then that the 15% increase in GP has to be adjusted to the new sales base that is now 33.3% higher…
Anyway, here's the math. Not sure how easy it is to follow, hope the explanation above helps.
Change = (1 + 15%) / (1 - 25%) - 1
= 115% / 75% - 1
= 115 / 75 - 1
= 133.3% * 115 / 75 - 1
= (133.3% * 115) / 100 - 1
= (133.3% * (100 + 15) / 100 - 1
= (133.3% + 20) / 100 - 1
= 153 / 100 - 1 = 1.533 - 1 = 53.3%
Hello Joel,
To calculate the increase in gross profit margin, you can use the following formula:
Gross Profit Margin = (Gross Profit / Sales) x 100%
First, you need to calculate the change in sales and gross profit:
Next, you need to calculate the new values for sales and gross profit after the changes:
Finally, you can calculate the new gross profit margin:
Therefore, the gross profit margin increased by 53.3%.
Hope it helped!
Best,
Victoria
Hi there,
whenever you feel a question is too abstract to grasp, as might be the case here, consider using smart numbers to simulate.
For example:
Hope this helps.
Cheers, Andi
Hello,
Have a look at the picture below. I assumed Sales = 100 and Gross Profit Margin (GPM) as 10%. After a 25% decrease in sales and a 15% increase in Gross Profit, I got Sales of 75 and GP of 11.5. To get the GPM, divide 11.5 by 75, to get 15%.
Thus the GPM increased from 10% to 15.33% i.e. by 53.33% or 5.33 percentage points.
Hope this helps!
Rushabh
Hi Joel,
The other coaches have it exactly right!
Now, remember, it is critical that you know all your major formulas and how to use them.
Make sure you learn margin, markup, breakeven, ROI, NPV, etc.