From the course: Investment Evaluation
Unlock the full course today
Join today to access over 24,800 courses taught by industry experts.
Real talk: Net present value - Microsoft Excel Tutorial
From the course: Investment Evaluation
Real talk: Net present value
- All right, so I'm back here with Kevin, founder of Meet Kevin and Meet and Done. This time we're gonna talk about net present value. And when I think of net present value I think immediately of overhead costs, discount rates, all right, and so, how important is NPV to you, and how do you use it in decision making for business? - Yeah, absolutely, the interesting thing from an entrepreneurial point of view is initially, when you first start a business, every NPV count you run I so negative. It's very depressing. So ultimately, I kind of just don't. But, when it becomes very important is when you start developing your business, and now you have to decide between options within your business. Do you but another sprinter van? So we expand the business with different tools? Do we buy a concrete mixer? Where do we want to spend? Where do we think we're gonna get a better yield? But also, in terms of, where do we want to invest business profits? That's where NPV is really gonna be a…
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
-
-
-