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!
Back to overview

Math prep : CAGR without excel - any tips?

Hi,

How do you approach CAGR calculations during the interview without excel? 

Any tips?

Ex1: Your client revenue has grown from 100 to 150 in 5 years, how would you estimate the average annual growth manually (1,5)^(1/5)-1?

Thank you in advance!

3
5.2k
0
Be the first to answer!
Nobody has responded to this question yet.
Top answer
edited on Jun 16, 2020
#1 Coach for Sessions (4.500+) | 1.500+ 5-Star Reviews | Proven Success: ➡ interviewoffers.com | Ex BCG | 10Y+ Coaching

Hi Anonymous,

basically here you have to compute

(1+x)^a=V

where you don’t know x and where a=5 and V=1,5.

For relative low interest rates and periods, the simpler process for precise results is the following:

1) Calculate what would be the solution with simple interest – in this case, 10%; the real result will always be lower than that

2) Decrease by 1 percentage point – in this case, 9%

3) Apply Taylor series till the third element.  To do so, you would have to learn by heart the following formula:

1+ax+1/2*a*(a-1)*x^2

Given point 2, x=9%

1+0,45+1/2*5*4*0,09^2=

=1,45+10*0,0081=

=1,531

4) Repeat decreasing till when you find a value below V=1.5

Given x=8%

1+0,4+1/2*5*4*0,08^2=

=1,4+10*0,064=

=1,464

Thus the result is between 8% and 9%.

Hope this helps,

Francesco

on Jul 28, 2017

Hello,

You can use binomial appriximation but may have to iterate depending; works best with low value of r as noted below.  

150/100 = (1+r)^5

Binomial approximation: means, set the right side to 1+ 5*r .... and ignore higher power terms in r for now..

Solving will give you r=0.1.  Now this is equivanent to 10% simple ineterest. So compound rate will be smaller than 10%. 

Also plug back and check how far off are we. (1.1)^5 =  [(1.1*1.1)^2 ] *1.1 = (1.21^2) *1.1  

~ 1.44*1.1 = 1.44+.14 = 1.58.  Now 158 is pretty close to 150. You can stop here. 

OR you can try 9% and see if that works. Now calculate 1.09^5 in bite size steps.

1.09^2 =  1+  0.18+ 0.0081 ~1.19   ----- use (a+b)^2

Repeat again with (1.19)^2 = 1.38 + 0.19^2 ~ 1.38 + 0.04 ~ 1.40.   ------ By now you have  1.09^4 approxiately

Last step 1.4*1.1 = 1.54.

So  still higher than 1.5. Repeat with 8% 

Regards,

SR

2
Deleted
Coach
on Jul 28, 2017
Current partner @ Andreessen Horowitz (VC firm). Ex-Mckinsey, ex- strategy guy at Google.

Easiest is the rule of 72  (if you divide 72 by the interest rate in question, you'll get the number of years it will take your money to double at that interest rate). So if interest rate were 12%, it'll take 5yrs to double 100 to 200. You are at 150 after 5 years, so, you know that it will take more than 5yrs to double, so the interest rate has to be <12%. At 6%, it'll take 12yrs to double, which means at year 6 it is at least 150, so 6% is too low. You can likely guess it's not exactly 9% because compound interest grows faster with each year, so you can estimate somewhere closer to 8%. If you practice more, you can get better at this.

Similar Questions
Consulting
Has anyone tried any of the AI Interview Tools for MBB before?
on Feb 27, 2025
Global
9
9.8k
Top answer by
Iman
Coach
Systemiq | Ex-BCG | 10 years experience with 8+ specialising in sustainability | Free Intro | Ex-PrepLounge candidate
340
9 Answers
9.8k Views
+6
Consulting
Revolut Case interview
on Mar 01, 2025
Global
5
10.1k
Top answer by
#1 rated MBB & McKinsey Coach
353
5 Answers
10.1k Views
+2
Consulting
How to prepare for a presentation-case-interview?
on Apr 25, 2024
Global
6
7.0k
Top answer by
Dennis
Coach
Roland Berger|Project Manager and Recruiter|7+ years of consulting experience in USA and Europe
257
6 Answers
7.0k Views
+3
How likely are you to recommend us to a friend or fellow student?
0 = Not likely
10 = Very likely
Thanks for your feedback! Your opinion helps us make PrepLounge even better.