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
| +86 | People who despise the industry you work for - uncomfortable date story | 38 | 40m |
| +61 | Broke up with college gf before analyst role | 32 | 6h |
| +18 | Cardone Capital…..Crashout | 9 | 26m |
| +14 | WC Final: Spain v. Argentina | 17 | 3d |
| +6 | London Roommate Thread | 2 | 5d |
| +6 | Things to do in Charlotte before Tame Impala | 3 | 2d |
| +5 | Masters tickets lottery | 4 | 2d |
| +3 | Best Uber Eats Restaurants Toronto | 0 | 3d |
| +2 | Fire @ Jeff Building | 4 | 6d |
| +1 | Old Finance Blog - Going Private | 3 | 5d |
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
Ipsam aut voluptas non quis modi amet. Et provident distinctio voluptatem similique qui ut qui deserunt. Atque doloremque impedit perspiciatis. Molestiae necessitatibus voluptatibus aliquid ad. Eum similique occaecati asperiores velit neque.
Voluptatem ab hic iure doloremque. Autem magnam nihil sit. Eius consequatur excepturi ratione sit.
Adipisci nihil sit sequi. Reprehenderit voluptatem ut quod enim quas unde. Esse facere sed recusandae aliquam mollitia harum. Possimus expedita ex nulla. Et ut molestiae quisquam ex. Nesciunt commodi quibusdam est est iure laboriosam similique. Vel perferendis facere ullam.
Dolores nemo beatae architecto asperiores incidunt dolorum. Occaecati quidem distinctio magni eveniet qui. Qui quia nisi adipisci natus hic quo. Tempore sed quidem laborum.
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...