Hello! I'm doing a sample case and I'd like to know how can I find what year had the highest gross margin from a chart.
I know the gross margin would be the revenue minus the cost but I know there would be a more simple way since I do not have the cost in this chart but have the revenue breakdown year by year.
This looks like a simple question but I am not 100% sure how I can solve this.
Thanks in advance for the help!
Hello!
Precisely for the high amount of questions (1) asked by my coachees and students and (2) present in this Q&A, I created the “Math & Formulas - Economic and Financial concepts for MBB interviews”, recently published in PrepLounge’s shop (https://www.preplounge.com/en/shop/prep-guide/economic_and_financial_concepts_for_mbb_interviews).
After +5 years of candidate coaching and university teaching, and after having seen hundreds of cases, I realized that the economic-related knowledge needed to master case interviews is not much, and not complex. However, you need to know where to focus! Hence, I created the guide that I wish I could have had, summarizing the most important economic and financial concepts needed to solve consulting cases, combining key concepts theorical reviews and a hands-on methodology with examples and ad-hoc practice cases.
It focuses on 4 core topics, divided in chapters (each of them ranked in scale of importance, to help you maximize your time in short preparations):
Feel free to PM me for disccount codes for the guide, and I hope it helps you rock your interviews!
Y1: 0.47x0.5 + 0.16x0.7 + 0.02x0.08 + 0.04x0.4 + 0.2x0.3 + 0.12x0.15 = 0.4426
Y2: 0.42x0.5 + 0.16x0.7 + 0.08x0.08 + 0.04x0.4 + 0.2x0.3 + 0.09x0.15 = 0.4179
Y3: 0.37x0.5 + 0.16x0.7 + 0.16x0.08 + 0.04x0.4 + 0.19x0.3 + 0.08x0.15 = 0.394
Y4: 0.35x0.5 + 0.15x0.7 + 0.2x0.08 + 0.04x0.4 + 0.2x0.3 + 0.06x0.15 = 0.381
Y5: 0.32x0.5 + 0.13x0.7 + 0.26x0.08 + 0.04x0.4 + 0.2x0.3 + 0.04x0.15 = 0.3538
Y1 has the highest gross margin of all years
I think you can calculate the gross margin of each year as a weighted average of the gross margin of each of the segments, with the contribution of that segment to the total revenue as the weighing factor. So for each of the years, the overall gross margin would be contribution (bus) * gross margin (bus) + contribution (air tickets) * gross margin (air tickets) and so on, divided by the number of contributions.
To speed things up, you can use the fact that you won't need absolute value to sort them. You can therefore skip the division step, as the number of contributions is the same for each year (6) and that factor effectively cancels out. You can also remove some contributions that are sufficiently small or that are similar and therefore should cancel out - for example, air tickets contribute approximately 20% to the revenue in each of the years, and you will therefore arrive at the same order if you neglect this contribution.
Total margin for all years: Y1: 111.5, Y2: 125.37, Y3: 138.58, Y4: 153.2, Y5: 151.86
(edited)
Am I using this method correctly? Y1: Domestic: (255*47%)*50% = 59.925 Long Haul: (255*16%)*70% = 28.56 Promo: (255*2%)*8% = 0.408 Cruises: (255*4%)*40% = 4.08 Air Tickets: (255*20%)*30% = 15.3 Bus: (255*12%)*15% = 4.59 Y1 = 112.863 Y2 = 64.68 + 34.496 + 1.9712 + 4.928 + 18.48 + 4.158 = 128.7132. However, the correct answer is TravelCo reached highest gross margins (in %) in Y1. I don't think I should be using the Y1-Y5 gross margin in the calculation as I'm trying to figure which year has the highest margin but what should I use instead?
(edited)
