From the course: Investment Evaluation
Schalten Sie den kompletten Kurs noch heute frei
Join today to access over 23,300 courses taught by industry experts.
Solution 3: Calculate NPV using table values - Microsoft Excel Tutorial
From the course: Investment Evaluation
Solution 3: Calculate NPV using table values
- [Instructor] If you want the work past solution, feel free to open up exercise file 03_04_Solution3. Let's get crackin'. If I think about the cash flow stream, I'll be able to figure out if Kevin should invest. So, based on the worksheet, I know I have an initial cash outflow of 1,500, so here in cell B13, I'll type in equals and then click on B3, and it's negative because it's an outflow. And to that, I'm going to subtract another value, and that's gonna be the upgrade costs, and again, I'm subtracting it because it's gonna be a cash outflow. So I'm gonna open up parentheses here, and click on cell B4, which is the upgrade cost, but I want the present value of that, 'cause remember, that thousand dollars is gonna be spend five years from now. So the present value of that is going to be found by multiplying the $1,000 by the factor .6806, which is the present value for one dollar, five years from now at a eight percent discount rate, and that's gonna be in cell B8. I'm gonna close…
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.
Inhalt
-
-
-
-
-
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
-
-
-