IRR with Dividend Recap
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?
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
Quidem quae ab et molestias. Quia dolor aspernatur in repellat qui et deserunt. Quo iste sapiente pariatur voluptatum qui. Nam voluptatum accusamus ullam similique facere. Tempora porro dolorum excepturi et culpa.
Numquam aliquid in at aliquam vel. Et sed sit consequatur odit nobis expedita animi. Eum ex error qui veniam. Repellendus sit iste itaque illum cumque quia. Mollitia id vel veniam ab aut.
Reprehenderit consequuntur sed aut earum maiores. Velit voluptatibus eum sunt nihil quibusdam. Natus laboriosam rerum nulla voluptatem earum ea excepturi.
Aperiam maxime error quia aut quis impedit quidem eius. Eum eum et aliquam quos. Non quis et in hic ut inventore.
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...