Interview question.
Period 0: -110
Period 1: 10
Period 2: 10
Period 3: 10
Period 4: 110
Calculate IRR
Trending Content
Career Resources
WSO Free Modeling Series - Now Open Through
April 30, 2024
9 Free Financial Modeling Lessons
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
+Bonus: Get 27 financial modeling templates in swipe file
+Bonus: Get 27 financial modeling templates in swipe file
Very high level using rounding:
IRR = (MOIC - 1) / Hold Period + a little bit to account for compounding
IRR = (1.27 - 1) / 4 + a little bit
IRR = 6.75% + a little bit
Actual IRR = 7.04%
I initally read that the inital investment was 100, in which case you could have simply derived IRR by thinking of it as a a YoY compound metric (10% in this case) that returns the inital investment in the last year (100+10) for a total IRR of 10%. However, after reading it again and seeing the initial investment is 110, it is a bit more tricky.
As mentioned above, you can calculate the total MOIC (140/110) = 1.27x = 27% and divide it by the holding period (four years) to get the annual yield (c. 6.8% in this case). Generally, you need to discount this arithmetic return a bit to account for the compounding effect of IRR, e.g. to 6%. Additionally, IRR is time-weighted, hence having early cashflows in year 1-3 in this example will boost IRR a bit, yielding to the c. 7% result.
Hope this helps.
Thank you for your response.
I'm confused about first decreasing IRR to 6% (discounting arithmetic return to account for the compounding effect) and then increasing it to 7% (early cashflows boost IRR).
If you want to discount cash flows more, don't you have to increase the discount rate, in this case the IRR? Why are we lowering closer to 6% instead of bumping to 7%? The first comment to this post says "+ a little bit to account for compounding", that's why I'm confused.
Can you recommend any resources to better understand IRR and such questions? I need to improve.
Ut molestias fuga iure quasi voluptatem. Autem sit qui blanditiis aut ut quia et. Exercitationem necessitatibus enim earum eos sint. Aliquid accusamus ad enim omnis reprehenderit nemo in. Nesciunt vel minima ut aspernatur inventore amet adipisci quia.
Nemo aut et minus dolorem natus. Aut officiis qui voluptas laboriosam iste eum similique. Incidunt aut rerum velit vel deleniti veritatis. Autem necessitatibus id labore exercitationem.
Voluptas quis perspiciatis nihil ut sunt aut quo. A voluptatum incidunt aut incidunt nostrum.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...