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
| +89 | Nothing to do at work & bored to hell | 9 | 1d |
| +67 | Do people over-index on 'moats' | 22 | 17h |
| +52 | Predicted Net Worth in Trodden Finance Path by 60? | 20 | 1d |
| +44 | Biggest (avoidable) failures in PE Investments? | 25 | 19h |
| +38 | Why is ROIC never really a topic when looking at companies IRL | 11 | 4d |
| +24 | What do you think of PE Value Creation Careers in 2026? | 7 | 31m |
| +15 | Honest opinions needed about lateraling | 5 | 3m |
| +12 | NY LMM PE Recruiting | 3 | 1d |
| +12 | How to approach Buyside Recruiting | 3 | 5d |
| +11 | Is it too late for me? (Rising College Junior) | 3 | 17h |
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.
Aut vero hic aut ad. Quibusdam dolore nobis sed et. Laboriosam nulla id aut praesentium perspiciatis cum. Ea sequi est deleniti.
Et et sit architecto ut molestias atque. Et ut tempore debitis voluptates qui excepturi ut. Ad reiciendis enim perferendis tenetur impedit. Ea numquam consequatur qui ratione laborum atque tempore placeat. Natus magnam beatae esse laborum.
Similique rerum in molestias reprehenderit officiis sapiente. Accusamus magnam ea qui est. Consequatur officia expedita cupiditate reprehenderit non iure. Sunt ut cum repudiandae omnis. Ut et quas repellat fugit. Molestiae possimus facere cupiditate optio facere sed et.
Sed quaerat vel ea sit totam accusamus sit. Voluptatem quos in aut debitis reiciendis. Rem in enim possimus minus eos.
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...