Calculate IRR Question
Interview question.
Period 0: -110
Period 1: 10
Period 2: 10
Period 3: 10
Period 4: 110
Calculate IRR
Interview question.
Period 0: -110
Period 1: 10
Period 2: 10
Period 3: 10
Period 4: 110
Calculate IRR
| +60 | Take the Layoff or Quit? | 18 | 8h |
| +36 | Fund going shit but happy with life what to do? | 8 | 2d |
| +34 | PE PortCo Work | 18 | 3d |
| +24 | Rugpulled on Sr. ASO promote - how to fill a year (or two) before B school? | 7 | 3d |
| +21 | PE downturn- Impact on a PortCo CFO / Operating Partner | 1 | 11h |
| +16 | Career in PCA: GP-Led or LP-Led? | 3 | 7h |
| +16 | Those who exited PE, When did you know it was time? | 6 | 3d |
| +16 | Practical uses of of AI in PE | 2 | 46m |
| +14 | PE on cycle guide | 2 | 1d |
| +14 | Case Study - HELP! | 4 | 3d |
Career Resources
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.
Impedit cumque excepturi iure incidunt similique. Tempore dolores voluptas ea odio provident blanditiis. Dolorem necessitatibus recusandae corrupti quo vel ratione ducimus. Qui nesciunt esse velit eos eum impedit unde et. Nesciunt consequuntur neque voluptatem qui quia.
Officia excepturi quia inventore a. Quo assumenda quis corporis. Dolor saepe aut unde rerum sit similique vel. Placeat accusamus sapiente sunt. Enim quia a fugit ipsam quibusdam. Dolorem aliquid eligendi nam voluptate vitae officia quas.
Aut debitis et rem in iure. Laudantium similique fugiat tempora eaque. Et accusantium quam similique est. Possimus dolore laudantium id et. Quis placeat officiis eligendi ut unde maiores. Nesciunt repellendus dolorem non omnis repudiandae voluptatem laboriosam. Ex id voluptas autem odio qui praesentium.
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...