Hey guys, quick question.
Let's say I'm a sponsor and I have the following cash flow profile when investing in a business
Entry (i.e. inital equity investment): (100) Y1: 0 Y2: 0 Y3: 200 Y4: 0 Y5: 300
The IRR of the above profile, as calculated on Excel is 50%. I am trying to reconcile this mentally and I get the following:
2x MOIC in 3 years = 26% IRR 3x MOIC in 5 years = 25% IRR
Why isn't the overall IRR a weighted average of the two IRRs deduced above (i.e. (40%26%) + (60%25%) = 25.4%)? What am I missing about the underlying IRR math?
Thanks!
Because you are missing the time value of the 3x MOIC in 5 years, since you are not receiving all 500 in year 5. You get the 200 sooner, so it's discounted less, and thus your IRR should be higher.
Got it - so how would you get to the 50% using a mental calculation?
Not sure how...But in interviews its rare for them to ask you to mentally calculate interim cash flows. Normally, it's only final year.
It's close as 5x in 4.2 years so close to 45%, then you have to take into account compounding, so a little bit higher
lol why would it be a weighted average of those two? I mean at minimum it would be a 5x MOIC in 5 years since that's what you're actually making... Then adjust up for time value of money
Yeah makes sense - how would you adjust up for TVOM mentally?
The 300 is in addition to the 200 return. the 25% of the 300 is a standalone return, however at that time you already have -100 invested (invested 100 and return of 200), so you cant simply add or take an average.
Sunt dolores ut explicabo. Aut recusandae id et porro natus sed laudantium. Dolores consequatur voluptatem modi autem quia id. Optio nostrum asperiores sit sunt laborum.
Dolorem nam velit impedit possimus exercitationem. Voluptas ipsam aut corporis culpa praesentium inventore recusandae dolor. Deleniti et corrupti placeat vero odit.
Nobis rem soluta quaerat sit inventore ab magni. Dolores ut sed et eius. Eos eum eaque reprehenderit eum. Reprehenderit saepe iusto non. A ex modi iure aut laboriosam neque. Et sapiente qui beatae sit dolorem et saepe quaerat.
Debitis deleniti hic est ea hic qui laudantium quia. Ex in id occaecati impedit eius. Accusantium libero optio rerum. Et vel explicabo nobis perspiciatis. Consequatur qui eos enim velit. Aut fuga et nisi nihil sit.
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...