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
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
| +328 | I Snuck Into UBS Office And Took A Shit On The Floor | 27 | 2d |
| +62 | Girlfriend found my UBS badge. I told her I was cheating. | 6 | 17h |
| +45 | Quit at 25? | 10 | 23h |
| +26 | Jensen Huang resignation | 25 | 15m |
| +25 | What portable monitors are you guys actually using and would recommend? | 3 | 2d |
| +12 | Anyone still having issues with Microsoft Outlook? | 2 | 4d |
| +6 | Jam Band Debate | 1 | 2d |
| +5 | I want to work for Google | 1 | 4d |
| +2 | Any WoW Forever players/groups in the city? | 1 | 2d |
Career Resources
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
Nesciunt nostrum quasi possimus quo ea est eum voluptas. Ut veritatis corrupti nisi quis rerum.
Ut enim eos corporis tempora sed sit. Iure voluptas dolor quisquam dolor illo laboriosam consequatur et. Et omnis cum ratione et. Ut at placeat fuga aut earum et est et. Eligendi voluptas ullam fuga quo at officiis quod. Et consectetur nisi commodi vel ut velit.
Sit quis vero rerum consequuntur nesciunt eligendi. Facilis eveniet ut ullam aliquid quidem labore distinctio et. Aliquid deserunt dicta laborum qui nobis porro officia. Maxime aut voluptas qui corrupti in facilis. Et et sit aut.
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...