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.
Internal rate of return - Microsoft Excel Tutorial
From the course: Real Estate Analysis Foundations
Internal rate of return
- How would you compare an apple with an orange? You might say that they're both fruit or maybe they're both sweet, but when you're looking at investment opportunities that would be the equivalent of saying well, they're both investments or they're both real estate. Not very helpful, right? So how would you be able to compare investment opportunities on an apples to apples basis even if they're not exactly alike? Now we saw with our example of the discounted cash flow and net present value, that's one of the ways we can do that. But another way that is very popularly used by professional investors is the concept of something called the internal rate of return. What is that? Definition, if you find it somewhere, Wikipedia or Investopedia or other places, here's one definition, the percentage rate earned on each dollar invested for each period it is invested. What? That sounds like a mouthful, right? Well, it's actually quite simple. Imagine an investment where you put some money in and…
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
-
-
-
-
-
-
-