How do you calculate IRR when there are interim cash flows like the scenario where a PE firm does a dividend recap in year 3 and exits in year 5? I know excel can do it for you with the IRR function, but what is the actual formula? How is excel calculating that?
| +74 | Ex Apollo Associate Q&A (But I Actually Answer) | 118 | 4s | |
| +57 | Q&A - Anything about PE / MBA / Life | 64 | 14m | |
| +45 | How to Model SaaS Projections for Interviews | 49 | 1d | |
| +37 | [Technical doubt]: Cash sweep and mandatory amortization | 10 | 7s | |
| +23 | European Megafunds (based on PEI 2023) | 17 | 2d | |
| +22 | Partners Group Long Term | 8 | 1d | |
| +22 | Is internal reporting at most funds really so Excel & PPT heavy still? | 8 | 10h | |
| +18 | How much thematic work / industry research do you guys do? | 0 | 5h | |
| +18 | How is your life in PE? | 12 | 4h | |
| +18 | Advent NYC Culture/WLB - 2024 update | 9 | 2h |
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.
Google: Npv and irr of uneven cash flows
Use XIRR. Excel calculates it through iteration.
IRR is the discount rate that equates the present value of future cash returns to equity to the initial purchase price (and any following equity contributions to the business).
Use XIRR in Excel and Excel will iterate to solve for that discount rate.
Without excel or a financial calculator, it's plug and chug. Pick a discount rate and continue to choose a new rate until your NPV is 0
Omnis ipsa velit libero illo. Quas tenetur libero libero quia quia reiciendis.
Excepturi et et labore. Quisquam veritatis consectetur maiores aut ipsum excepturi.
At temporibus sed et nobis optio aperiam ut. Quasi rerum tenetur quia non officia. Nostrum delectus velit ut aut nam assumenda cum maiores. Voluptas aut quod dolor ut sit qui et.
Et et aut alias eos dolores cupiditate. Sed consequuntur sit libero dolor dolore. Iste eum rerum voluptatem perferendis ut. Laborum dolores velit in maiores.
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...