How To… Calculate Net Present Value (NPV) in Excel 2013

About this tutorial:

Video duration: 6:20
Net present value (NPV) analysis is a method of calculating the expected net monetary gain or loss from a project by discounting all expected future cash inflows and outflows to the present point in time

Projects with a positive NPV should be considered if financial value is a key criterion. The higher the NPV, the better.

NPV is used in project selection and is a recommended tool for the Project Management Body of Knowledge (PMBOK) in the Project Integration knowledge area.

Incoming search terms:

Post Author:

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

5 thoughts on “How To… Calculate Net Present Value (NPV) in Excel 2013


    (May 14, 2019 - 5:23 am)

    – how do you pick discount rate? expected inflation per year?

    Efaz Goffur

    (May 14, 2019 - 5:23 am)

    Thanks, It helped me out right away.

    Levani Tsomaia

    (May 14, 2019 - 5:23 am)

    have you heard about NPV function in excel -_-

    Melissa Moffat

    (May 14, 2019 - 5:23 am)

    Thank you so much for making this video! I had been working for literally three hours on a problem until I found your video. This is the only way that really made it click. Thank you!

    M. Raed Al-Lulu

    (May 14, 2019 - 5:23 am)

    A useful one as usual.
    Thank you Mr. +Eugene O'Loughlin

Leave a Reply

Your email address will not be published. Required fields are marked *