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
| +142 | What’s “the path” now? | 56 | 1d |
| +105 | Is Everyone Too Bearish on PE? | 34 | 2h |
| +48 | Why would anyone do PE in long term in 2026? | 13 | 1d |
| +37 | 3rd Year IB Analyst, Top Bucket, Still No PE Offer. What Would You Do? | 19 | 1d |
| +25 | Is This Normal in LLM PE | 10 | 4d |
| +24 | Q&A: What It’s Actually Like Working at an Independent (Fundless) Sponsor | 4 | 2d |
| +21 | Striking out in last rounds | 2 | 3d |
| +21 | UMM PE or High Paying Strat Finance? | 13 | 17h |
| +15 | DELETE | 1 | 1d |
| +15 | Overwhelmed by amount of data / granularity | 3 | 1d |
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.
Molestiae esse officia ea quia perspiciatis omnis rerum. Iste sapiente placeat voluptatem. Alias error eius optio. Est et ut rerum nemo rem. Asperiores ut quia aliquam. Enim tenetur est nihil et architecto optio est corporis.
Cum aut eum est consequatur laudantium voluptas. Sit consequatur temporibus eveniet sint vero accusantium voluptatem. Laudantium suscipit tempora illum est quae temporibus.
Veritatis iure nulla sit. Quis facere quia mollitia aut magnam. Ut odit dolores voluptas fugiat id.
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...