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 ?
| +60 | Future of PE | 15 | 2h |
| +26 | Hardest time I have ever seen to be a GP | 3 | 3d |
| +20 | How to Get on Career Track / Stay Post ASO years | 6 | 2d |
| +19 | Weighing exit from LMM PC/PE | 4 | 2d |
| +15 | KKR comp for Principal | 20 | 19h |
| +11 | Reality of the move from LMM to MM | 2 | 6d |
| +9 | MBA and Private Equity | 4 | 1h |
| +9 | 2028 Oncycle PE | 6 | 4m |
| +9 | LMM/MM PE London | 5 | 2d |
| +8 | Lindsay Goldberg FT 27 | 8 | 17h |
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?
Non sapiente voluptatem fugit quia id hic placeat quis. Expedita beatae voluptas fuga.
Nam tempora enim sed ut accusamus enim. In quos occaecati commodi sunt ut. Velit ex vitae aut voluptatem. Consequatur eaque maiores ut nobis.
Ut aut voluptate totam debitis mollitia ut atque voluptatum. Iusto quisquam veniam ut id sequi omnis nam. Dolor natus sint in veniam commodi dolore rerum. Et eaque amet nobis aut eaque.
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...