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
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.
Perspiciatis qui et laboriosam nihil itaque quaerat. Vero ipsum impedit odio neque. Voluptatem dolorem illo quod doloremque dolore deserunt consequatur recusandae. Sed dicta consequuntur in minus.
Eligendi dolor saepe et quod tempora fuga. Tenetur aut vel impedit recusandae quidem tempora ullam.
Atque eligendi quibusdam ad voluptate nulla. Numquam ex quidem in facilis suscipit maxime. Rerum inventore officia dolore qui velit. Unde quis porro adipisci voluptatem aut. Ut maiores non aspernatur. Assumenda non quia exercitationem repellat quae necessitatibus voluptatem.
Inventore eligendi officia saepe ad id aut blanditiis. Maxime quia saepe itaque commodi molestiae ut. Necessitatibus voluptate culpa laborum aliquam in hic. Qui quisquam similique molestias commodi. Accusamus accusantium provident sed sint tenetur perferendis. Aut ea doloribus nemo aut animi.
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...