How To... Calculate Net Present Value (NPV) in Excel 2003

In Project Selection, project managers can use a Net Present Value (NPV) calculation to help select a project. See how to calculate NPV in simple steps.

Category:

Education

Tags:

• NPV
• npv
• project
• selection
• excel

[grassguydave]

Useful, but you're not from Kansas are you?

[eoloughlin]

@grassguydave Nope - but I have been to your wonderful Kansas City. I live in Dublin!

[incompletious]

Excellent tutorial, it makes the whole process easy as compared to how we first conceived it! God bless you

[mc1703]

Hello there. Good video. I wonder if you can help me - I am trying to calculate the NPV of a perpetuity that doubles every 25 years. So in my example the annuity is $100, but in the year x+20 the annuity will double to become $200. I know how to calculate the npv if the annuity doesn't change - 1 / K * £annuity, but not sure how to take account of the doubling ad infinitum...

[Robmeisterflex]

Cheers, really helpful.

[anniemcp88]

helped alot, thanks!

[Judge4utube]

I fell asleep. 

[Bahjathaddad]

Thanks

[Weam576]

Very Helpful. The only NPV video that relates to my project and actually went step by step without any confusion. Thank you.

[cksingh23]

It is quite an easy way to understand NPV. Tq