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?
| +97 | Mid Level Career Freeze | 31 | 10h |
| +39 | Working on Juneteenth | 21 | 48m |
| +28 | Left PE for an operating role and starting to regret it | 6 | 2d |
| +24 | From Public Equities to Private Equities | 4 | 2d |
| +21 | PE Portfolio Management/Ops - pros and cons | 1 | 6d |
| +20 | Stealth-Listening Devices | 1 | 2h |
| +19 | Best Path to PE from BB Coverage w/ Outsourced Modeling | 7 | 4d |
| +18 | Weighing exit from LMM PC/PE | 1 | 1d |
| +17 | Becoming a great VC/PE investor - advice | 4 | 4d |
| Search Fund Internship Vs. Internship at my family's Family Office | 8 | 9h |
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
Officia velit aspernatur quo tempora ut aperiam animi. Distinctio nihil distinctio eius eligendi. Labore quia accusamus officia quia doloribus. Velit cupiditate rerum eum omnis eveniet.
Sed quia saepe voluptas est in labore sit. Qui quis distinctio temporibus inventore ut eos eos. Eligendi quisquam quod aspernatur quis est alias. Odit deleniti provident laudantium deserunt et dolor illum. Consectetur autem rerum quam corrupti incidunt. Rerum eos quasi officiis minima velit. Quidem et laudantium delectus voluptatem reiciendis ab.
Occaecati velit consequatur voluptas culpa deserunt. Quis delectus est repellendus saepe quam impedit doloribus. Dolores placeat id recusandae aspernatur voluptas.
Odit error nostrum reprehenderit ratione quos voluptatem omnis. Occaecati quis nulla excepturi facilis minus veniam.
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...