From the course: Investment Evaluation
Unlock the full course today
Join today to access over 24,800 courses taught by industry experts.
Pros and cons of NPV - Microsoft Excel Tutorial
From the course: Investment Evaluation
Pros and cons of NPV
- There are definite pros and cons to using net present value to evaluate your investment. Regardless, I would say it's one of the most widely used techniques to figure out if you're gonna get the most bang for your buck. Of course, this course just gives you an intro. There's a lot more nuance that goes into it than what I've shown you. So what are the pros? Well, just like this kind of cash flows, NPV accounts for the time value of money. As you can recall, a dollar is worth much more now than that same dollar will be in the future, mostly due to inflation and risk. So what are the cons? Well, the big one, which we'll be able to address with another technique, is that NPV doesn't give us visibility into how long it'll take to generate a positive NPV. So our NPV rule tells us to accept all investments where the NPV's greater than zero. However, it doesn't tell us when that positive NPV will be achieved. Will it happen in five years? Will it happen in 15 years? Another limitation of…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
The net present value equation2m 55s
-
(Locked)
NPV using tables3m 36s
-
(Locked)
Challenge 3: Calculate NPV using table values1m 23s
-
(Locked)
Solution 3: Calculate NPV using table values1m 39s
-
(Locked)
A fully worked out example4m 38s
-
(Locked)
NPV using a Microsoft Excel formula1m 48s
-
(Locked)
Challenge 4: Calculate NPV using Microsoft Excel42s
-
(Locked)
Solution 4: Calculate NPV using Microsoft Excel1m 31s
-
(Locked)
Pros and cons of NPV1m 32s
-
(Locked)
Real talk: Net present value4m 56s
-
-
-