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.
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.
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.
Sit voluptatem dicta autem qui iusto. Quasi voluptas modi ut omnis in. Aspernatur ut corporis dolorem quia corrupti delectus.
Sapiente quo rerum architecto asperiores et reiciendis quod. Sed repellendus quae eveniet accusamus est id dolore. Et saepe sed rerum aut qui odio nam.
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)
Sorry, you need to login or sign up in order to vote. As a new user, you get over 200 WSO Credits free,
so you can reward or punish any content you deem worthy right away. See you on the other side!
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.
Sit voluptatem dicta autem qui iusto. Quasi voluptas modi ut omnis in. Aspernatur ut corporis dolorem quia corrupti delectus.
Sapiente quo rerum architecto asperiores et reiciendis quod. Sed repellendus quae eveniet accusamus est id dolore. Et saepe sed rerum aut qui odio nam.
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...