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
| +82 | Ex Apollo Associate Q&A (But I Actually Answer) | 123 | 2h | |
| +61 | Q&A - Anything about PE / MBA / Life | 65 | 3s | |
| +45 | How to Model SaaS Projections for Interviews | 51 | 6m | |
| +37 | [Technical doubt]: Cash sweep and mandatory amortization | 10 | 6h | |
| +26 | Partners Group Long Term | 8 | 1d | |
| +24 | Is internal reporting at most funds really so Excel & PPT heavy still? | 8 | 16h | |
| +23 | European Megafunds (based on PEI 2023) | 17 | 2d | |
| +18 | How much thematic work / industry research do you guys do? | 1 | 11h | |
| +18 | Advent NYC Culture/WLB - 2024 update | 9 | 6h | |
| +18 | How is your life in PE? | 12 | 9h |
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.
Ex alias consequatur architecto non molestiae. Sit eaque quis recusandae. Et alias tenetur velit nulla. Sed eligendi id ut voluptas veritatis autem.
Labore qui excepturi qui sint. Est porro non totam sed.
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...