Next Live Training Date:

JHB 11-15 July , CT 12-14 Oct

Not sure which Excel course you should do? Try out our free Which Excel Course Should you do" questionnaire. 20 questions and you will know exactly what course you should do!

NPV in Excel

NPV in Excel
Watch this video

How to use the NPV in Excel to determine the Net Present Value or a series of cash flows

  • 2:27
  • Skill Level:
  • What's my skill level
    Flying screens

    All of our videos are listed by user Excel Skill Level.

    To find out your personal skill level, download our quick assessment.

    Once you've completed the test, send it to us and we'll evaluate for you.

    Download Test

  • Watch this Video

NPV in Excel

This segment will show you how to determine the NET PRESENT VALUE (NPV) in Excel of a series of cash flows.

In this example we have a series of cash flows starting at the beginning of Period 1, which we called Period 0. An outflow of 20 000, and then the next five years we have inflows of cash.

We would like to determine what the NET PRESENT VALUE is of these series of cash flows. In order to do this we can make use of the NET PRESENT VALUE function.

Now this is very, very important because if you look at our numbers, Period 0 is actually the beginning of Period 1 and then Period 1 that’s the end, the end, the end.

If we assume the values of all these cells we’ll be incorrect because Excel will assume that this 20 000 investment actually occurs at the end of Period 1. So in order to do this is our Value 1

However we have to be very careful because what we’ve told it to do, is give us the NET PRESENT VALUE of all the cash flows at the end of the years. We have excluded this, now because it happens at the beginning of Period 1 we don’t have to worry about present valuing it because the number is already present values.

So in order to get an accurate NET PRESENT VALUE, you need to subtract the initial investment.

<ul

so the NET PRESENT VALUE of these series of cash flows is actually this number here.

Free Tips & Tricks Newsletter

Please fill in your details below to get regular Excel tips and tricks and a free Quick Reference Download!

Handy Tips & Tricks

Excel negative numbers

Negative numbers in Excel can sometimes cause some confusion for users. Below some of the most common issues/ questions addressing Excel negative numbers. Entering a negative number in Excel At its very simplest you need to add a negative symbol … Continue reading

Check if the row is blank in Excel

One of the more common uses for Excel is financial reporting based on templates. The one problem is that if you use a template you have to pre populate it with all the options and when you use it, perhaps … Continue reading

....As an example, the training in VLOOKUP had applicability in differing ways for each employee and they learned then and there how to use it in their own work. They left the training with clear expectations on improvement in their areas of responsibility...

– Benefits of inhouse training- Health and Accident Underwriting Managers

Video Library & Tutorials //

View Entire Video Gallery ››

Making the same change to multiple worksheets in Excel

Making the same change to multiple worksheets in Excel

Tables in Excel for PowerPivot use

Tables in Excel for PowerPivot use

Excel see formula instead of value 2013

Excel see formula instead of value 2013

Excel Quick Sum 2013

Excel Quick Sum 2013

Some of our Featured Clients