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.
The terminal value of an indefinitely held rental - Microsoft Excel Tutorial
From the course: Pre-investing: Before Investing in Real Estate
The terminal value of an indefinitely held rental
- Now a lot of the examples we've gone over and the examples we're going to go over later makes an assumption that you're going to sell the investment to realize all of the returns in the investment, but what happens if you don't intend to sell it? What happens if you just want to purchase it and hold onto it for as long as you can, keep collecting rents from this investment? How would we account for that in our investment analysis? Well, we're going to take a look at that case right here. So if you are thinking about holding a property, then we have to do a special treatment for the analysis because we're no longer going to have the sale where you're going to have the profits at the sale to generate this huge cash flow at the end. So one of the ways we can do that, and if we look at what this kind of scenario looks like, it looks like something like this, right? You invest some money. You're getting some returns every year. Hopefully it's growing, but in this example, we'll just say…
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)
-
-
-