Get Active in Our Amazing Community of Over 451,000 Peers!

Schedule mock interviews on the Meeting Board, join the latest community discussions in our Consulting Q&A and find like-minded Case Partners to connect and practice with!

An unusual quant qn from McKinsey

McKinsey quant quantitative
New answer on Nov 13, 2023
7 Answers
11.3 k Views
Odeh asked on Sep 17, 2017

Can someone please offer an explanation and solution to this problem?

The question has been adapted for this forum. It originally comes from a McKinsey case.

Below is a description of expected probability of success, by stage, in a biotech firm's R&D pipeline.

The R&D of a drug has several phases (1-4). As a drug goes through each stage, there is a probability of it suceeding:-

Phase 1 ---(70%)---> Phase 2 ---(40%)---> Phase 3 ---(50%)---> Phase 4 ---(90%)---> successful marketing & sales

This firm believes that the likelihood of success of its primary drug candidate can be improved by investing an additional $150 million in a larger Phase 2 trial. The hope is that this investment would raise the success rate in Phase 2, meaning that more candidate drugs successfully make it to Phase 3 and beyond. By how much would the Phase 2 success rate need to increase in order for this investment to break even?

Assume that if the drug is successfully marketed and sold, it would be worth $1.2 billion (that is, the present value of all future profits from selling the drug is $1.2 billion).

Overview of answers

Upvotes
  • Upvotes
  • Date ascending
  • Date descending
Best answer
Francesco
Expert
Content Creator
replied on Sep 20, 2017
#1 Coach for Sessions (4.500+) | 1.500+ 5-Star Reviews | Proven Success (➡ interviewoffers.com) | Ex BCG | 10Y+ Coaching

Hi Odeh,

As mentioned, there could be multiple ways to face this problem. A simple way would be to compare the outcome of two scenarios, one with the investment and one without and put them equal:

Step 1: Calculate the expected outcome without investment

In this case your expected outcome would be 1200M times 12.6% (where 12.6%=70%*40%*50%*90%); thus

V1=1200*0.126=151.2

Step 2: Calculate the expected outcome with investment

In this case your expected outcome would be 1200M times x (where x=70%*y*50%*90%, in which y is the new outcome of Phase 2) minus the investment required of 150M; thus

V2=1200*x-150

Step 3: Put the results equal

Now putting the two outcomes equal you get

V1=V2 <->

<->151.2=1200*x-150<->

<->301.2=1200*x<->

<->x=25.1%

Now solving for y:

70%*y*50%*90%=25.1%<->

<->y=79,68%

that is, almost twice the current amount.

Hope this helps,

Francesco

Was this answer helpful?
Laur on Aug 05, 2022

Just to add to this - I personally avoid complex formulas in interviews because I do not want to mess up the calculations, so I try to use simple logic instead if I can. The value of a drug is worth less and less the further back it is in development. For example, starting Phase 4, we have a 90% chance of getting 1.2 bn, and a 10% chance of getting 0, so the drug is worth 1.08 bn (0.9*1.2bn). Working backward, you'll get the value of a drug that's coming into the pipeline today, before phase 1 to be roughly 150M (1200M*0.9*0.5*0.4*0.7), same as the investment we plan to make. Now, if you invest 150M into any stage of development, you want that 150M to reflect the value of the pipeline today, Pre-phase 1. So we can now assume we want Pre-phase 1 value to be 150M + 150M = 300M (double). Now, we know that working backward from 1.2 bn to the initial 150M, we multiplied by a success percentage every time. Therefore, to get to an initial value of 2 x 150M and only have the change reflected in one of the Phases' success rates, then that Phase must double in its percentage effectiveness. This brings the success rate from 40% to 80% in Phase 2. If we were doing Phase 3 instead, for example, it would need to go from 50% to 100%, and if we were doing Phase 4, we would not be able to actually realize this gain, because we would need to go from 90% to 180% success rate, which is impossible. It's essentially the same calculation as above, but I found it easier for me personally to wrap my mind around. Hopefully, it offers an alternative for anyone struggling with complex maths, and please let me know if the logic is flawed somehow!

(edited)

Clara
Expert
Content Creator
replied on Nov 13, 2023
McKinsey | Awarded professor at Master in Management @ IE | MBA at MIT |+180 students coached | Integrated FIT Guide aut

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):

  • Economic concepts: Profitability equation, Break even, Valuation methods (economic, market and asset), Payback period, NPV and IRR, + 3 practice cases to put it all together in a practical way. 
  • Financial concepts: Balance sheet, Income statement/P&L and Performance ratios (based on sales and based on investment), +1 practice case
  • Market structure & pricing: Market types, Perfect competition markets (demand and supply), Willingness to pay, Pricing approaches, Market segmentation and Price elasticity of demand, +1 practice case
  • Marketing and Customer Acquisition: Sales funnel, Key marketing metrics (CAC and CLV) and Churn, +1 practice case

Feel free to PM me for disccount codes for the guide, and I hope it helps you rock your interviews! 

 

 

Was this answer helpful?
Odeh replied on Sep 18, 2017

This is the solution offered by McKinsey. (The link for the whole case is http://www.mckinsey.com/careers/interviewing/globapharm)

Investment would need to increase the probability of success in Phase II from 40 to 80 percent (that is, increase of 40 percentage points). There are multiple ways to approach this calculation. One method is shown here:

  • If a candidate drug passes Phase II, then it has a 50% x 90% = 45% chance of being successfully marketed and sold. Since a successful candidate drug is worth $1.2 billion, a candidate drug that passes Phase II is worth 45% x $1.2 billion = $540 million.
  • To break even (that is, to make the $150 million investment worthwhile), the value of the candidate drug that passes Phase II would need to increase to $540 million + $150 million = $690 million. This means, the probability of combined success in Phase I and II would need to increase by (150/540) = 28 percentage points.
  • So the current probability of Phase I and II, that is, 70% x 40% = 28% would have to increase by 28 percentage points, to 56%. In order to come up to 56%, Phase II probability would have to increase from 40% to 80% (70% x 80% = 56%).
  • This seems like a very big challenge, as an increase by 40 percentage points means that the current probability of 40% needs to double.
Was this answer helpful?
6
Florian replied on Sep 18, 2017
Concluded my preparations and signed with Bain.

Hi,

the case seems like a relatively straightforward case of expected returns.

You know that the outlay of R&D cost $150m is real money. Therefore that money has the same value, as the payoff you get from drugs that make it through all phases (because that is also real without any discount for expectation)

You need to go backwards from the expected payoffs, and estimate the value of all drugs in trial in the various phases (of which you know some are not going to make it.)

In Market: 1.2b
In Phase 4: 1.2b / 90% = 1.33b
In Phase 3: 1.33b/50% = 2.66b
In Phase 2: 2.66b/40% = 6.66b
In Phase 1: 6.66b/70%= 9.5b

Now, the value of the drugs in the first phase does not change. However, we need to break even, meaning we need to make back the $150 investment in our 'in Market' phase. Therefore, the new value for In Market is: 1.35b.

Applying the same backwards logic results in:

In Market: 1.35b
In Phase 4: 1.35b/90%= 1.5b
In Phase 3: 1.5b/50%= 3b
In Phase 2: 3b/40% = 7.5b
In Phase 1: 7.5b/70% = 10.7b

As I mentioned above, the value of 10.7b is irelevant, as this would imply that we give more drugs into the development funnel. However, the question is to broaden the funnel, i.e. how do we get with the potential market of 9.5b (if all drugs tested became a success through all phases) to 1.35b (what we need to recoup investment). We are given the fact that the improvement happens in Phase 2, so we solve for the formula:

9.5b*x = 7.5b, x=0.79

Therefore, the answer shold be that the success rate in phase 2 would need to increase from 40% to 79%, an increase of almost 100%, to recoup the $150m investment.

On a sidenote, maybe worth mentioning that the drugs that make it through all phases have an NPV of 1.2b. That means it can take quite a long time to recoup the money (at 5% interest rate, it is about 20 years worth of returns, of around 60m each year. It depends whether the company has the same risk appetite for return on their investment cost, i.e. is the NPV value of the last stage a valid measure of the return. I assume it is in this case scenario, but in real life it may differ).

Cheers,

Was this answer helpful?
5
Odeh on Sep 18, 2017

I'm still not clear why you're dividing 7.5 by 9.5

(edited)

Florian on Sep 18, 2017

The 7.5 is the value of phase 2 in order to make 150m more profit of the drugs in market. The 9.5b is the initial value of all drugs you put in the funnel. You know that some won't make the cut, and the test will not let them proceed to the next stage. The question is, what percentage do you require to proceed to the next stage, to still make your required profit. If stage 1 is 9.5 and stage 2 is 7.5, you need 80% of stage 1 to make it to stage 2.

Simon
Certified
updated an answer on Oct 02, 2017
Looking for advanced/pro level case partners - currently preparing for McK & BCG interview intensively

The sucess rate of Phase II need to be 0.800 to break even the extra investment. Here is my thinking process using the concept of expected value (EV).

The concept of EV can be used to calculate the net expected earning of a particular gambling game, given the investment (INV), profit, and the success rate (SR):

  • EV= -INV + SR x Profit

,where SR=SR1 x SR2 x SR3 x SR4 accounts for the four phases in this case. Straightfowrdly, one would have no change in the expected value (dEV=0) if,

  • dINV=dSR x Profit

,where "d" denotes the change "delta". Here we know the profit is 1.200B and the change of investment is dINV=$0.150B, which gives dSR=0.125. With the unchanged sucess rate in phase I, III, IV, the change of sucess rate in phase II dSR2 need to be:

  • dSR2= dSR / (SR1 x SR3 x SR4) = 0.125 / (0.700 x 0.500 x 0.900) = 0.400

to offset the extra investment. Therefore, the sucess rate of Phase II need to be 0.800=SR2+dSR2=0.400+0.400.

(edited)

Was this answer helpful?
3
Raz on May 21, 2019

Thank you for that answer. could you please explain why are we looking at Delta and not absolute values?

Anonymous A updated the answer on Sep 18, 2017

The logic behind is a decision tree where on first stage you have probablity to move further of 70% an get 0 (or lose investment) of 30%. Then again 40% to move and 60% to have 0 -> 50% to move 50% to have 0 -> 90% to win $1200 and 10% to have 0. THen if you put $150 as investmetn you start to have -150 instead of 0 on each end. By multiplying % on win/lose of the branch and sum up results you go backward from 1200 to the beginning: 1200*0,9+(-150)*0,1=1065 -> 1065*0,5+(-150)*0,5=457,5 -> 457,5*0,4+(-150)*0,06 and so on...

Hope it's clear enough..

(edited)

Was this answer helpful?
0
Odeh on Sep 18, 2017

Although I follow your logic, this method aims to calculate the original cost of the R&D, correct? However the question is asking something different - by how much does the success rate need to increase?

Nikolay on Sep 18, 2017

I found an error - I was thinking abt all the project, but the question is asking to get back the investment of 150M. The answer is 28% (I don't agree with Florian). To solve the problem you should put 0,4+x and 0,6-x in phase 2 and try to make it equal to the profitability of decision without investment. check out it here: http://prntscr.com/gmdwap

Nikolay on Sep 18, 2017

but may be I am making it too complicated =)

Odeh on Sep 18, 2017

I'm not clear. What is 'x'? How have you defined it?

(edited)

Odeh on Sep 18, 2017

Also, you're making the assumption that the $150m is invested at the very start of the R&D process aren't you?

(edited)

Anonymous A replied on Sep 18, 2017

Looks like there should be some information on initial R&D invetments for the product. Because if you assume all initial investments as 0, it's alreade profitable to try.

Was this answer helpful?
0
Odeh on Sep 18, 2017

According to McKinsey, there is enough information to solve this.

Nikolay on Sep 18, 2017

so the answer is that it is no reason to invest additional 150M

Odeh on Sep 18, 2017

Not quite sure I understand Nikolay. Can you elaborate please.

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