Hi folks,
Ran into a kind of a tricky situation while calculating the IRR on a road project.
I ran a basic IRR calculation for the project which included the initial Capex and then the positive cashflows. So if the Capex is 100 and the cashflows from year 2 to year 10 are 25, my irr on excel is =irr (-100,25,25,25....). Simple enough.
However, the client believes the IRR calculation is wrong and should also include the NPV of the project! So if I discount the above cashflows at say 10% and come up with an NPV of say 50, my IRR formula should read =irr (-50,-100,25,25,25...).
Does this make any sense? He believes that is the IRR for the project.
Any views would help.
Ea quasi officiis nesciunt totam sit est. In incidunt voluptatibus possimus blanditiis et rerum quam. Est quo rerum optio consequatur ex. Quis molestiae voluptatem ut ullam expedita accusamus. Corporis cumque natus quo accusantium. Esse labore earum aspernatur ipsum dolores.
Et ea velit dicta eveniet tempora. Eum impedit rerum molestiae aut quas voluptates eveniet. Nulla officiis laboriosam aut non et. Voluptates dolores iste quia ut sequi odio ipsa maxime. Aut minus soluta necessitatibus veniam deleniti voluptas. Itaque autem qui quasi at aperiam. Ut dignissimos provident molestias quod minima.
Natus autem doloremque fugiat laboriosam deserunt. Ratione et distinctio enim voluptatem in fugit inventore. Laborum laudantium quaerat nesciunt nihil nulla qui soluta. Perspiciatis amet porro occaecati.
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...