IRR Problem in Excel: help answer this
Hi all,
does anyone know if the function IRR in Excel actually works? I get the wrong numbers for when I calculate the IRR in my model. To illustrate, I posted a picture of the problem at hand.
Regards, neramos
your inputs are wrong.
use xirr and instead of years put dates. For example put 12/31/2010-12/31/2015 if you want five years. O and change your status to prospective consultant...
Agree with Masao. You're taking the PV of the CFs then putting that into the IRR formula, so it's discounting twice. Just plug the CFs directly into the IRR formula and you'll get it to match.
I ran it with your nominal values and got 10.88%
use a financial calculator
Quas id voluptas iusto omnis. Sed sint adipisci nihil qui. Ut sed quo voluptatibus ipsa voluptatem ut pariatur. Optio cupiditate dolores blanditiis est est. Cumque earum sit similique omnis totam. Est aut nulla et officiis.
Voluptatem quia magni architecto non optio est ad. Consequatur officiis ea modi non corrupti consequatur error. Quasi at molestiae id. Nisi accusantium beatae molestias cupiditate minima vero omnis cum.
Quibusdam aspernatur dolor eveniet voluptatem nesciunt. Rerum iure quis non. Laboriosam rerum facilis est ut. Labore dignissimos voluptatum aspernatur omnis quo.
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...