Real Estate Underwriting Case Study

Recently I was given a acquisition case study as part of a project for an internship with the following information provided:

  • 100 Unit class C multifamily being converted into class B

  • Market rents ~1600-1800 (Columbia Heights DC)

  • Renovation costs: 25K per unit

  • 5 year hold period

  • 6.5% going in cap rate

  • 1 year renovation period, 1 year absorption period

Model should include IRR, leverage, and return on cost.

That is all it is, no op-ex, no NOI, no debt assumptions.


Anything I am missing here? Units are renting 21,600 max - 25k renovation cost gives a negative NOI. Not sure how to find the purchase price. If anyone has any ideas would be appreciated.

 
Most Helpful

Negative cash flow in the first year isn't the end of the world in a project like this, your NOI on the frontend will take a beating due to the renovation cost but should be made up for on the backend due to the improved rents. 21,600 is the max top line rent for a single year - you're holding the asset for 5 years and the units should be improved and occupied for at least 3 of those years. 3*21,600 much greater than 25k though this is a very simplified way of looking at it. I would also ask what the renovation schedule should look like. The total project might take 1 year but I doubt each unit takes that long, so would try a more sophisticated renovation timeline on a monthly basis. You don't want to model Unit 1A finishing its renovation in Month 3 and not producing income till Month 25 because your perfect model says it should take a year to renovate, a year to absorb.

Also - you might be nervous as the intern to ask your coworkers these questions. Ask them. The 30 seconds it takes to ask and receive an answer is much faster than the three days you've had on this posting without anyone helping you out. Trust me, everyone's been there. Regardless, I'm working through this right now if you want to send me yours and I'm happy to give feedback.

 

Et et dolorem qui eum vitae fugit laudantium. In iusto autem inventore voluptas consequuntur et et cupiditate. Inventore est minus dolor eveniet. Dolore illo placeat praesentium. At doloribus voluptates in aut sequi repellat autem.

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
GameTheory's picture
GameTheory
98.9
6
dosk17's picture
dosk17
98.9
7
DrApeman's picture
DrApeman
98.9
8
CompBanker's picture
CompBanker
98.9
9
kanon's picture
kanon
98.9
10
numi's picture
numi
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...”