Real Estate Financial Modeling Case Study HELP - Getting to Purchase Price??

Hi, so I've recently applied to a RE investment firm and they gave me this case study. I've been trying to read through some case studies online, but I can't find anything that is similar to the one they gave me.

Basically, there is a target Office Building to be acquired with 1 year of renovations before being leased out to a tenant, and then an exit by Year 4. The property will be funded by equity, mezzanine, and senior debt. Now, usually, case studies provide the purchase price for the target property as well as an exit cap rate at the end to determine the returns of the investment.

However, in this case, they did not give me a purchase price nor any cap rates. They only mentioned that the minimum equity IRR for the Investor should be 22%. How should I compute the purchase price for this? I'm stumped on how I would have to do this.

 

Oh, so basically I need to compute for the NOI in their first year of operations? And for the cap rate, I've found that the cap rates in this area range from 7% to 9% generally. So say, I assume an 8% entry cap rate. My purchase price will then be Year 1 NOI / 8% cap rate?

But what cap rate should I assume for when they exit? Will it also be up to me to assume that exit cap rate? 

 
Most Helpful

Good job on finding a going-in cap and probable purchase price! 8% sounds good.

Now, exit caps are almost always an assumption because predicting the future is hard, so this is definitely up to your assumption. I'd suggest the cap rate expansion method : 0.1 * holding period. So if you have a 10 year hold: 0.1 * 10 = 1%. Add that to 8% for a 9% exit cap. If you can find the data: Find historically how cap rates have increased per year in the area for office buildings and use that average change number (instead of 0.1)

Also, if you're allowed to ask- it wouldn't hurt to ask for a purchase price to use just so you're a little more accurate in your model

Also yep you calculated purchase price correctly.

Lastly! Do you have a sale price? Exit cap would be easy to calculate at that point. Forward NOI (Year 5) divided by sale price would get you an exit cap, too.

 

Thank you for the really helpful replies man! I'll certainly look at your recommendations! They did not give me purchase price, sale price, nor any entry/exit cap rates as reference. They didn't even give me the lease rates for the building lol. From what I've watched so far, most of the time, these are assumptions that are directly given in the case studies. So I guess they also want to assess my research skills lol. 

I'm thinking of asking my employer but this is what they said in the case study: "Executive summary of transaction with your recommendation on deal structure and pricing of the Asset that will achieve a minimum of 22.0% equity IRR". Based on this, I think they really want me to come up with my own purchase price. At the same time, however, they also want me to compare my purchase price with comps to determine if asset pricing is cheap and attractive relatively. But if I'm already basing on market rates, wouldn't that just be kind of pointless? I'm thinking i'd just be going back in circles if i do that.

 

If you know the IRR should be 22%, just adjust a purchase price by guessing, until your leveraged IRR equals 22%. I assume your debt is based off of your purchase price, so once you set your purchase price, say $10MM, your debt will become, for example, $6.5MM and $1MM, and if your IRR at this price shows 18%, lower your purchase price and see what your IRR is. Rinse and repeat (in either direction) until your purchase price equals a 22% IRR

 

Sed vitae sunt corrupti magni. Tempore est ut dignissimos consectetur voluptatem qui. Nobis id et iste qui esse accusantium et.

Blanditiis illum provident omnis ab officia nulla maxime. Ut soluta incidunt soluta eos. Quia fugiat voluptatem ut voluptas iste. Deserunt repellendus eum dicta commodi vel perferendis corporis.

Pariatur tempore ut voluptatem qui voluptas. Asperiores dolores saepe alias dolores.

Career Advancement Opportunities

March 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. (++) 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

March 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

March 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

March 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (86) $261
  • 3rd+ Year Analyst (13) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (202) $159
  • Intern/Summer Analyst (144) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
BankonBanking's picture
BankonBanking
99.0
3
Betsy Massar's picture
Betsy Massar
99.0
4
Secyh62's picture
Secyh62
99.0
5
kanon's picture
kanon
98.9
6
DrApeman's picture
DrApeman
98.9
7
dosk17's picture
dosk17
98.9
8
GameTheory's picture
GameTheory
98.9
9
CompBanker's picture
CompBanker
98.9
10
Jamoldo's picture
Jamoldo
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”