When looking at cash flows I usually use XIRR(), but I'm working on a project where I want the IRR to be the independent variable and have the cash returned dependent, so that I can look at different cash returns on certain IRR values. Is there an Excel formula for something like this? Don't want to have it be trial and error, which is my last resort.
Trending Content - Private Equity Forum
| +59 | Seeking External Perspectives | 17 | 2d |
| +32 | Rejoining old firm - Guaranteed Promotion? | 9 | 1d |
| +28 | Oncycle Rumblings | 32 | 30m |
| +22 | Cold Pitching an Investment Idea for a VP Seat | 3 | 3d |
| +21 | Reneging on an offer | 8 | 2d |
| +19 | Negotiating sale economics with CEO? | 4 | 4d |
| +19 | American PE VP who needs to move to London for personal reasons - how should I go about it? | 8 | 4d |
| +18 | Career Advice | 1 | 4d |
| +16 | GP Associate 1 Comp | 5 | 4d |
| +16 | PE -> CFO at Portco -> Back to Investing | 2 | 4d |
Career Resources
Wouldn't cash returned be 0 given that the IRR is the rate that makes NPV 0? Or are you comparing a single IRR to various discount rate estimates?
If you are comparing various discount rates to a single IRR, you can use the NPV at various discount rates.
Let me know if I am totally off track with what you're looking for.
Hic aut voluptatem eos et omnis quia odio. Aspernatur laborum molestiae et vel distinctio sint.
Explicabo aut sunt illum ullam. Cum atque sed praesentium. Doloribus modi omnis aut inventore magni et. Sapiente soluta quibusdam dicta eligendi officia eos. Blanditiis aut recusandae dolorem ut unde.
Unde ut aspernatur amet. Quae quis rem voluptas. Ipsa exercitationem ut tempora sit et.
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...