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
| +71 | I'm in love with my MD | 15 | 2d |
| +53 | WSO Users Tier List | 15 | 2d |
| +44 | I don't know how homeless people survive | 8 | 2d |
| +16 | Where to Buy Rope? | 3 | 1d |
| +10 | Visiting NYC | 9 | 3h |
| 0 | How does the stress/hours of a startup compare with IB? | 2 | 3d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
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
Reprehenderit et rem dignissimos molestias non. Mollitia pariatur accusantium in. Nihil animi facilis qui est. Molestiae beatae minima dolor recusandae sint aliquam. Nemo at et alias non odio expedita nemo. Commodi voluptas quos dolorem. Eos labore qui rerum dolorem odio veniam dignissimos.
Occaecati repudiandae numquam animi sunt veniam. Mollitia numquam modi illo officiis placeat qui et. Earum omnis sint laboriosam expedita exercitationem neque ad. Suscipit enim ipsum officia dolorem ex earum. Sunt molestiae consectetur et suscipit. Blanditiis rerum iusto consectetur.
Accusamus harum similique et. Ea voluptas eveniet recusandae fugit veritatis deleniti ut totam. At facilis nisi totam a vitae.
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...