# 1. Introducing the Case

Overview

To begin, we'll learn about real estate asset we're going to value. We'll also meet the investor and his expectations for the investment.

To explore more Kubicle data literacy subjects, please refer to our full library.

Summary

1. Overview of the Case (00:04)

This course builds a valuation model for a real estate asset. Property is an interesting asset to study, as many people will buy a property in their lives. Also, a property is a single asset, unlike many companies, making it easier for us to study.

We consider a three bedroomed apartment in a US city. Our client is an investor who wants to purchase the property, rent it out for several years, and then sell it. We must decide if the investor should buy the apartment, based on his desired level of return.

Following Powell and Batt’s four-stage modeling process, the first step is to frame the problem. We come up with the following problem statement:

Will the asset yield an IRR of greater than 15% if we buy for $1,400,000 and sell in the next six to nine years? Transcript In this course, we’re going to build a full valuation model for a Real Estate asset. Why did I choose a Real Estate asset? Well for a number of reasons. Firstly, because of its relevance. Most people during their life time will buy a property, and so the concepts and terms I use in this case study will be very familiar. Also, given that it’s a single asset, the valuation process will be much easier to understand, and safer value in your company, which might contain multiple business units and many different types of assets. The real estate asset in question is a 3-bedroomed apartment in a downtown US city that’s currently for sale for$1,400,000.

In valuing this asset, I’m going to assume that you have a basic understanding of valuation theory, including concepts such as discount cash flow, net present value, and Internal rate of return.

Now let’s meet our client who’s Joe Calatrava, an experienced Real Estate Investor.

He plans to buy the apartment as an investment and rent it to tenants in the near to medium term.

He wants a minimum 15% IRR on the investment, and plans to sell on the asset in six to nine years.

And he has asked us to advise him on a decision on whether he should buy the apartment.

For this case study we’ll be using Powell &amp; Batt’s four stage modeling process to help structure our approach and eventually reach a decision.

Let’s start off in step one by framing the problem.

Given that Joe knows the purchase price, his estimated holding period and the target rate of return, the problem statement for this case is quite straightforward.

Will the asset yield an IRR of greater than 15% if we buy for \$1,400,000 and sell in the next six to nine years? With this introduction out of the way, and our problem statement confirmed, let’s move on to defining the model structure in the next lesson.

Investment Valuation
Valuing a Real Estate Investment

Contents

02:03

02:25

04:00

04:53

04:55

01:50

05:45

04:05

03:18

03:30

04:43

03:46

#### 13. Find the Drivers of IRR

03:38

My Notes

You can take notes as you view lessons.

Sign in or start a free trial to avail of this feature.