From the course: Pre-investing: Before Investing in Real Estate
Unlock this course with a free trial
Join today to access over 24,000 courses taught by industry experts.
NPV vs. IRR - Microsoft Excel Tutorial
From the course: Pre-investing: Before Investing in Real Estate
NPV vs. IRR
- Hey guys, let's look at the examples we visited earlier again. The eight investments where we're making $200 of an investment, and then we're getting a total of $1,000 back over a ten year period. But, the difference here is each one of the investments, the $1,000, come in different amounts in different times. So, some of them are spread out more, and some are spread less and it'll only come in two years, right? With those we remember we saw that investment five was the best option; was the most efficient at returning the investment to the investor. When we look at the other measures, the Net Present Value at a discount rate of 8%, we see that the NPV is consistent with the IRR here in this case. That it is the most efficient at returning that capital. Now, when we look at the Cash Multiple, they all look exactly the same. And, that was by design, right? Because, you're getting the same amount of total cash back. $1,000 for your $200 investment. 1,000 over 200 is five X. So, you…
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
-
-
-
-
-
-
-
-
(Locked)
What makes a good investment?1m 48s
-
(Locked)
Discounted cash flow and the net present value (NPV)5m 37s
-
(Locked)
Discount rate2m 42s
-
(Locked)
NPV demonstration7m 34s
-
(Locked)
Measuring efficiency: Internal rate of return (IRR)2m 34s
-
(Locked)
IRR demonstration4m 24s
-
(Locked)
Measuring magnitude: Cash multiple1m 58s
-
(Locked)
How to use the measures6m 3s
-
(Locked)
NPV vs. IRR4m 51s
-
(Locked)
The terminal value of an indefinitely held rental5m 53s
-
(Locked)
Investment yields and capitalization rates8m 38s
-
(Locked)
Measures of return summary7m 49s
-
(Locked)
-
-
-