From the course: Real Estate Analysis Foundations
Unlock this course with a free trial
Join today to access over 22,600 courses taught by industry experts.
Discounted cash flow and the net present value (NPV) - Microsoft Excel Tutorial
From the course: Real Estate Analysis Foundations
Discounted cash flow and the net present value (NPV)
- Let me ask you a quick question. Would you rather get $100 right now or get $100 a year from now? All things equal, the answer is really clear, right? You want $100 right now. Why would you wait a year for that? But let's look at another example. Would you rather take $100 right now or $1000 in 10 years? Now, it's kind of more difficult, maybe some of you might choose, still choose to get the $100 now but some of you may be willing to wait 10 years in order to get $10,000. And the questions that might go through some of your minds may be, well, who's guaranteeing it and do I have confidence that person who's going to offer me the 1000 in 10 years is actually going to be able to fulfill on that request? When investors think about the profits coming from an investment, that's one of the things that they've got to grapple with, it's not just how much they're going to make from investment, but it's when they're actually going to receive those profits, and one of the ways that investors…
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
-
-
-
-
-
-
-
Intro to measures of returns1m 48s
-
(Locked)
Discounted cash flow and the net present value (NPV)5m 37s
-
(Locked)
Discount rate2m 42s
-
(Locked)
Net present value exercise7m 34s
-
(Locked)
Internal rate of return2m 34s
-
(Locked)
Internal rate of return exercise4m 24s
-
(Locked)
Cash multiple1m 58s
-
(Locked)
Which measure to use?6m 3s
-
(Locked)
Which measure to use? Part 24m 51s
-
(Locked)
The terminal value5m 53s
-
(Locked)
Yields and cap rates8m 38s
-
(Locked)
Summary of measures of return7m 49s
-
-
-
-
-
-
-