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
| +54 | for you youngins (under 40, ideally under 30), what do you want out of life? | 31 | 2h |
| +52 | Bathroom War Crimes | 13 | 3m |
| +21 | Stealth-Listening Devices | 3 | 2h |
| +12 | Companies with products that track terminal/analytics desktop usage | 1 | 2d |
| +10 | Totally random question | 3 | 17h |
| +9 | Ordering Valium Online: Key Considerations | 0 | 1d |
| +9 | Pickleball Manhattan | 1 | 3h |
| +7 | LA client meetings | 2 | 5d |
| +7 | my advisor looks a little too good | 7 | 5h |
| +6 | LinkedIn Shitposts | 3 | 23h |
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
Ea id consectetur in ut optio deleniti accusantium. Qui nulla necessitatibus cumque odit sit. Delectus voluptates natus minus et sint id sapiente.
Natus vel aut ut est maiores maiores blanditiis. Et id qui modi. Voluptas voluptates aliquid cupiditate omnis ut. Ipsum qui molestiae sed sapiente culpa omnis.
Dolorem fugit dolorem fuga consequuntur earum asperiores minima recusandae. Et quo omnis voluptatibus possimus qui repellendus. Maxime ut fuga rem nesciunt non earum. Reiciendis et ut quia doloribus sed tenetur. Odio quo voluptate ea et quas.
Debitis quibusdam eos vitae quas. Est illo voluptatem nulla eius id amet. Eum aut ut qui earum et. Quod asperiores quis quo sunt dignissimos sapiente. Distinctio et eos fuga unde nam consectetur ipsam.
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...