Consulting Consulting
Consulting Finance General
Login Sign up for free Sign up for free
Consulting Finance General
Community
Meeting Board
Consulting Q&A
Interview Partner
Premium Membership
Coaching
Coaches
Coaching Packages
Consulting Q&A
Resources
Case Interview Basics
Case Library
AI Casebot
Tests & Guides
Mental Math Tool
Stress Questions
Drills
Video Tutorials
Brainteaser
Career
Employers
Career Events
Consulting Jobs
Consulting Blog
Sign up for free
Login
Community
Meeting Board
Consulting Q&A
Interview Partner
Premium Membership
Coaching
Coaches
Coaching Packages
Consulting Q&A
Resources
Case Interview Basics
Case Library
AI Casebot
Tests & Guides
Mental Math Tool
Stress Questions
Drills
Video Tutorials
Brainteaser
Career
Employers
Career Events
Consulting Jobs
Consulting Blog
Schedule mock interviews on the Meeting Board, join the latest community discussions in our Consulting Q&A and find like-minded Interview Partners to connect and practice with!
Meeting Board
Consulting Q&A
Interview Partner
Premium Membership
Back to overview
Anonymous A
on Sep 18, 2023
Global
I want to receive updates regarding this question via email.

Struggling with understanding simple revenue exhibits (M&A case)

In one of my case practices the following exhibit came up. I don't understand how they calculated yearly revenue from the exhibit, but I've attached the answer from the guidance. 

I have 2 Qs:

1) I know that exhibits sometimes have info left out intentionally to see if you can deduce the right questions, but here I'm struggling to see how for eg they got to a monthly profit of $100k for Tier 1 product in Q1. I would assume that $100k is the profit for the whole year for Tier 1 [ (2+2+2+4)TB x 1000GB x $10 ]. What is the bit of insight/info I'm missing?

2) Is the formula they've quoted as “discount in perpetuity formula” just the Present Value (of an asset/company) in perpetuity? So PV = free cash flow / discount rate - growth? Is this a commonly used formula? I've not seen it before, and not sure I've understood it correctly. Can I use this simplified version in future cases?

3
800+
13
Write an answer
Be the first to answer!
Nobody has responded to this question yet.
Top answer
Deleted user
edited on Sep 21, 2023

Dear,

Thank you for the questions. Let me see if I can be of help with the 2 points you mentioned.

Question 1

I see there might be a bit of confusion/unclarity here. At first, when I looked at the exhibit you posted, I was puzzled too. The exhibit title says “revenues in 2019” but instead here we have a quarterly split of the quantity Q of data protected sold by the company. As a side note, it is always helpful to insert a unit of measure in every chart we produce as consultants to facilitate team and client discussions. But apart from that, to crack the question “what are the revenues for our client?” we need to rely on the commonly known Revenues = Price * Quantity formula, where the quantity is given in the quarterly chart per tier (1,2, and 3) and the subscription price is given in the case instructions. However, there is also a unit of measure mismatch to factor in: prices per tier are in $/GB per month, while the quantity Q (in the chart) is in TB. 

Hence, we can say that the numbers in the chart represent the quarterly quantities of TB sold per tier (it’s not obvious, I would assume that in a mock interview, you may need to ask some clarifying questions to arrive at this conclusion). For example, in Q1 the company sold 2TB of data to Tier 1 subscriptions (i.e. 0.67TB on average per month) that, considering $10/GB per month, should be equal to $20,000 revenue at run rate (i.e., from the year after) thanks to that quarter sales.

So, the logical steps to follow to discover the yearly total revenues would be:

1. Sum the quantity Q sold in each quarter per tier to come up with the total Q

Q(Tier 1) = 2 + 2 + 2 + 4 = 10 TB

Q(Tier 2) = 2 + 7 + 8 + 8 = 25 TB

Q(Tier 3) = 10 + 10 + 10 + 10 = 40 TB

2. Transform the quantity Q from TB to GB (x1,000 multiplier) 

Q(Tier 1) = 10,000 GB

Q(Tier 2) = 25,000 GB

Q(Tier 3) = 40,000 GB

3. Multiply the Q per tier with the related P ($/GB per tier) to obtain the total revenues

R (Tier 1) = 10,000 GB * $10/GB = $100,000

R (Tier 2) = 25,000 GB * $8/GB = $200,000

R (Tier 3) = 40,000 GB * $5/GB = $200,000

Total R = $100,000 + $200,000 + $200,000 = $500,000

Now, other key info here hidden in the sentence “assume these are all inclusive profit numbers” is that these revenues translate directly and surprisingly into profits (i.e. no costs to consider).

Also, another key factor to consider is that these are subscriptions, not one-off revenues. Hence, the total revenues will be much higher than $500,000 since each month we'll get something from these subscriptions. From next year, assuming no other subscriptions will be sold, $500,000 will be the monthly revenues generated by the company. This number multiplied by 12 months will give us the yearly revenue ($6,000,000) at run rate.

Note: the yearly revenue for the year reported in the chart is a value between $500,000 and $6,000,000. To calculate it, we would need to know the exact point in time of each sale to understand how many months of subscriptions for each TB sold generated revenues.

Question 2

The perpetuity formula you posted is widely used in business. It’s simplistic but mathematically proven (and adopted). There are tons of caveats behind it, but it could be used as a first tool to have a first estimate of the present value of future cash flows generated by a company. 

In a nutshell, what the formula says is that if you assume to have a business that will:

  • Operate infinitely in the future (i.e. it will never end)
  • Have Cash Flows (CFs) that will grow every year at a constant rate G
  • Have a defined and known Cost of Capital

You can obtain the present value of the sum of all the future Cash Flows by dividing yearly Cash Flows at T0 by the cost of capital minus the growth rate.

If g = 0 (i.e. the company will always have constant cash flows going forward), the perpetuity formula will simply be CF/cost of capital.

Final note to know: it's not always true that Profits = Cash Flows. I'd say that 99.9% of the time they are completely different concepts. In this case, you're using profits as a proxy of cash flows which is fine in a case like this but it's important to know for your future career that this is a wrong approach.

Please let me know if I have cleared your doubts!

Feel free to ping me if you want to discuss this further.

Best,

Antonio

12
2 comments
Anonymous A
on Sep 19, 2023
Thank you so much for your response. See for Q1 there's still a missing link that I don't understand and which I can't see in your answer. So you showed the working out for the yearly cost am I right? So total costs is $500k (I'm assuming your $600k is a simple typo!). In the question guidance they then go on to multiply this by 12 as this is the *monthly* cost apparently! Which leaves $6mil as the yearly costs.

This is what I don't understand - I managed to get to $500k, but I can't understand how they got to $6mil yearly cost. How can $500k be the monthly costs when we've added up all the data sold across the year to arrive at this number?! Do you think this might be an error in the book?
Deleted user
Coach
on Sep 21, 2023
Dear,
thanks for pointing this out and apologies for, indeed, the typo :) Answer above updated accordingly.

Regarding your additional question, I definitely see your point. And I understand the unclarity. Without knowing much more about the case, my first guess might be that the case creator is projecting yearly revenue at a run rate.
In other words, taking this year standalone, we know we sold X TB of data for the different tiers. Hence, starting from next year we know that we will have a monthly recurring revenue equal to $500,000 (because we sold in the past year, and we earn each month from them). Therefore, multiplying $500,000 by 12 will produce the projected yearly revenue at run rate
Ian
Coach
on Sep 19, 2023
Top US BCG / MBB Coach - 5,000 sessions |Tech, Platinion, Big 4 | 9/9 personal interviews passed | 95% candidate success

Hi there,

Antonio has already provided a fantastic answer!

I highly recommend you use rocketblocks for further practice - they have tons of charts/exhibits in case context and with explanations!

7
Contact coach
0 comments
Cristian
Coach
on Sep 19, 2023
#1 rated McKinsey Coach

Hi there!

I see you've gotten an excellent answer already.

Sharing a resource that you might find helpful - a collection of all the most common terms that show up in consulting interviews:

  • Expert Guide: The Must-Know Consulting Terms for Interviews


Best,
Cristian

———————————————

Practicing for interviews? Check out my latest case based on a first-round MBB interview >>> SoyTechnologies  

6
Contact coach
0 comments
Similar Questions
Consulting
Case Study Based on CIM
on Jun 12, 2024
Global
4
1.7k
Top answer by
Sanjeev
Coach
PwC/Strategy&/GT/Chicago Booth - 2nd Session Complementary till June 1st
46
4 Answers
1.7k Views
+1
Consulting
How should I explain a change in course at university? Will it be asked of me?
on Apr 14, 2025
Global
10
3.7k
Top answer by
Alessa
Coach
xMcKinsey & Company | xBCG | +200 individual & group coachings | feel free to schedule a 15 min intro call for free
81
10 Answers
3.7k Views
+7
Consulting
Just did the Mckinsey Solve Game (January 2025) - got some questions/insights
on Apr 24, 2025
Global
5
3.9k
Top answer by
Hagen
Coach
#1 recommended coach | >95% success rate | 8+ years consulting, 8+ years coaching and 7+ years interviewing experience
42
5 Answers
3.9k Views
+2
Related Article
Valuation Cases
Understanding how to determine a company's value is a crucial skill in strategy consultingstructured approach to valuation is essential. While full-scale valuation analyses are rare in case interviews, you may still be asked questions like, "How much would you pay for company XY?" or "Is this offered price reasonable?" Let's take a closer look on how to approach valuation in a case interview: The Most Common Methods of Valuing Are the Discounted Cash Flow (DCF) and the Industry Multiple MethodSince case interviews are designed to test structured thinking rather than financial modeling skills, you won’t be expected to conduct a full valuation. Instead, you’ll likely need to estimate the worth of a company, product, patent, or service, often with limited data. Your task is to provide a logical and well-reasoned valuation rather than an exact figure.Discounted Cash Flow MethodThe first valuation method is the Discounted Cash Flow Method. This method shows how much money you would have in your savings account at a certain interest rate in order to provide you with the same annual cash flow generated by the company that is being evaluated.To calculate this, you divide projected annual cash flows by an appropriate discount rate (or interest rate). Naturally, the discount rate for a business investment is higher than that of a savings account because investing in a company carries more risk.👉 For more details on how to use the Discounted Cash Flow (DCF) method, have a look at our Net Present Value (NPV) lessonIndustry Multiple MethodThe Industry Multiple Method provides a relative valuation by comparing a company to similar businesses in the industry. This is especially useful when additional factors—such as brand value or strategic positioning—affect valuation beyond simple cash flow calculations.For example, football teams are often overvalued compared to their financial returns because their brand, fan base, and sponsorship potential add intangible value. The industry multiple method accounts for such variations.The process involves:Identifying a relevant financial metric (e.g., revenue, EBITDA, or book value).Finding the average multiple for similar companies (e.g., P/E ratio, EBITDA multiple).Multiplying the chosen metric by the industry multiple to estimate value.Example: Price-to-Book Ratio (P/B)If a company’s assets are valued at $200 million but it was sold for $100 million, the price-to-book ratio is 0.5 (100M ÷ 200M). By averaging this ratio across comparable companies, you can estimate a reasonable valuation for a target firm.Other commonly used valuation multiples include:Price-to-Earnings Ratio (P/E)EV/EBITDA MultipleSince precise calculations aren’t required in case interviews, you don’t need to memorize industry-specific multiples. However, a rough understanding can help:A typical industry multiple can be EBITDA × 10.Discount rates vary from 3% (inflation level) to 20% (high-risk investments). Key TakeawaysUse the Discounted Cash Flow (DCF) method to value a firm based solely on its expected profits.Use the industry multiple method to double-check if the DCF valuation is reasonable. Sometimes other aspects need to be factored in like brand value, customer loyalty, liabilities, etc.There are several types of industry multiples to choose from. For more precise valuation, choose more types of industry multiples.Practice M&A cases to optimize your valuation-techniques:
View article
Related Case
Expert case by
Ian
Based on Bain 1st Round Case (2023): Last Mile Delivery
5.0
4.0k times solved
Advanced
Interviewer-led
Open case
Similar Questions
Consulting
Case Study Based on CIM
on Jun 12, 2024
46
4
1.7k
Consulting
How should I explain a change in course at university? Will it be asked of me?
on Apr 14, 2025
81
10
3.7k
Consulting
Just did the Mckinsey Solve Game (January 2025) - got some questions/insights
on Apr 24, 2025
42
5
3.9k
Everything for Your Career
  • Interview Coaching
  • Q&A
  • Interview Partner
  • Mental Math Tool
  • Interview Drills
  • Stress Questions
  • Blog
Everything for Your Career
  • Interview Coaching
  • Q&A
  • Interview Partner
  • Mental Math Tool
  • Interview Drills
  • Stress Questions
  • Blog
Popular in Consulting
  • Case Library
  • Meeting Board
  • Case Partner
  • Case Interview Basics
  • Case Interview
  • Consulting Q&A
Popular in Finance
  • Finance Q&A
  • Interview in Investment Banking
  • Investment Banking Salaries
Popular in Consulting
  • Case Library
  • Meeting Board
  • Case Partner
  • Case Interview Basics
  • Case Interview
  • Consulting Q&A
Popular in Finance
  • Finance Q&A
  • Interview in Investment Banking
  • Investment Banking Salaries
Consulting and Finance Employers
  • RWE Consulting
  • Whiteshield Advisory
  • All Employers »
About PrepLounge
  • For Companies
  • For Universities
  • For Coaches
  • About Us
  • Career
  • FAQ
© 2012 PrepLounge
Our servers are powered by electricity from renewable sources.
  • Cookies & Privacy
  • Terms & Conditions
  • Imprint
  • Sitemap
  • Contact
How likely are you to recommend us to a friend or fellow student?
0
1
2
3
4
5
6
7
8
9
10
0 = Not likely
10 = Very likely
Submit feedback
Thanks for your feedback! Your opinion helps us make PrepLounge even better.
Close Close and keep on prepping
Want to leave already?
After your registration you have free access to:
12 mock interviews with peers
360.000+ peers in our community
36 exercises (incl. structuring drills, mental math, brainteasers and more)
Video tutorials
Video case solutions
Sign up for free
Questions or Feedback?
Select category
  • Select category
  • General Feedback
  • Case Interview Preparation
  • Coaching
  • Technical Problems
  • Other
Your name
Your email address
Cancel