Not sure which of these videos to watch? Try out our 'Which Excel Formula to Use' App to get guidance. NOTE: All these free Excel video tutorials are streamed via YouTube. If your network does not allow YouTube videos, you can access the video via your smartphone or from a different network.
How to use the NPV in Excel to determine the Net Present Value or a series of cash flows
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.
so the NET PRESENT VALUE of these series of cash flows is actually this number here.
Please fill in your details below to get regular Excel tips and tricks and a free Quick Reference Download!
Alumni Reward, spider charts, extract text from the last #-/, look for current month and year, training budgets In this issue: LAST Advanced Excel course 2015 7-9 Dec Alumni reward In houses Courses– Use up your remaining training budget? Extract … Continue reading
Extract text from Excel cell AFTER an instance of a character If you need to extract a certain part of text, but the unique item is not consistent and possibly repeats itself you need to make a few adjustments to the … Continue reading
I can testify that since I have been trained by you online, I really improved my Excel knowledge. But as you know, I am not living in South Africa but I am in Democratic Republic of Congo.– Congo
Please let me know if you have an online version of this session and I will be part of it.