What is the correct way to calculate the IRR if there are multiple cash outflows (at different times) which all happened before any inflows?
For example, the cashflows may look like this: -600, -150, 0, -150, 0, 0, 18000
Is it as simple as solving r for 0 = -600 -150/(1+r) - 150/(1+r)^3 + 18000/(1+r)^6 ?
| +312 | London MF REPE is paradise | 16 | 8h |
| +45 | The Peanut Portco | 4 | 12h |
| +22 | My Work Products Get 95% There, is that a failure or somewhat expected? | 13 | 3d |
| +18 | Seeking External Perspectives | 1 | 2h |
| +18 | LMM PE to PE-backed Corp Dev? | 2 | 21h |
| +14 | Partners misalignmet common? | 4 | 6d |
| +14 | Opinions on DTCP? | 5 | 4d |
| +13 | Joseph Baratta to Leave BX | 9 | 14h |
| +13 | How often do you see your girlfriend / boyfriend? | 4 | 3d |
| +12 | PE job sucks, how can I navigate returning to my old firm? | 2 | 20h |
Career Resources
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.
A bit of an odd cash flow profile but if you have dates you can use the XIRR function and will tell you what the IRR is.
If your initial cash outlay is 600 and you exit at 18,000 - I'd like to invest ;)
Thanks. The additional outflows after the first one could be interpreted as follow-on investments. Mechanistically speaking, ignoring the dates (by assuming equal period between cashflows) is it the right approach?
Beatae sunt voluptas explicabo. Aperiam mollitia aut quia nulla velit exercitationem veritatis. Sunt quia soluta dolorum corporis. Nobis itaque ut dolor et nihil vel libero.
At enim corrupti sapiente laboriosam. Sapiente qui velit eum. Qui ipsum praesentium architecto.
Nesciunt asperiores quia laudantium rerum architecto architecto consequatur. Libero minus dolor doloribus esse maiores hic quia. Eaque qui ducimus quo commodi.
Aut qui voluptates sed et sed. Sequi amet beatae voluptas dolores ab voluptas eum. Aut voluptate aut occaecati rerum.
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...