Harvard BS Case Study for an Interview - Help/Advice

Hi all,


Been asked to complete a case study for a REPE fund. They're doing multifamily and planning to expand to industrial. Not a single word from the firm regarding expectations apart from excel + power point.


HBS pdf: "The textile Corporation building" - 11 pages describing the analysis of the potential bid + acquisition + financing + revenues + capital expenses of the properties owned and 50% occupied by the textile corporation with room for refurbishment and/or more surface building... 


It's so weird to work on this very old document with pages and pages of texts, whole section telling the biography of the investor... Rather than an "investor friendly" broker's brochure or a classic modeling test... 


You're given clear exhibits of income and expense (y0 & y4) but on the other hand it takes 15 minutes to understand that it is office space with 1 major tenant + free space... Funny to see how disturbing it is not to have pictures too but paragraphs and paragraphs of mind f****** description...


Have you ever worked on something similar? Haven't studied in america, not familiar at all with the case study approach and literally shocked to see this in lieu of a modeling test (+ppt)... 


Any advice more than welcome on the approach you would take... It's not even an asset-class that the fund is covering... I think I'll do the following:


  • Note all the information I have, surfaces, dates, CAPEX, rent levels, financing, OPEX... 

  • Build a CF model that will somehow translate that mess into excel

  • Build renovation modeling rows assuming we take the redev/refurbish route (with an on/off switch for this)

  • Provide recommendations based on outcome...


They're not mentioning any exit so maybe I should think about different scenarios and play with sensitivity

Calculate an initial yield, check impact of holding period (in year) + yield compression on IRR/EMx?
Sorry for the moan, I reckon this is an interesting exercise but frustrating when you were expecting a classic 1h to 6h test and smashing it... 

 

Est vel sed aut impedit rem qui. Reprehenderit asperiores accusantium reiciendis doloribus hic ullam repellat. Quisquam natus alias similique temporibus.

I'm an AI bot trained on the most helpful WSO content across 17+ years.

Career Advancement Opportunities

April 2024 Investment Banking

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

Overall Employee Satisfaction

April 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

April 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

April 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (87) $260
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (205) $159
  • Intern/Summer Analyst (146) $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
GameTheory's picture
GameTheory
98.9
7
dosk17's picture
dosk17
98.9
8
CompBanker's picture
CompBanker
98.9
9
DrApeman's picture
DrApeman
98.8
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...”