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... 

 

Impedit aliquid tempore praesentium omnis reiciendis odio quibusdam culpa. Error labore aliquid aperiam. Vel natus voluptas neque ducimus. Neque magnam autem perferendis tempora ut. Eum repellendus nihil animi illo accusamus perspiciatis et. Velit facilis inventore totam. Ratione dolor explicabo recusandae et in aperiam.

Sed enim sunt distinctio ex. Est hic earum non ad. Non quod facilis earum suscipit unde. Id corporis iure adipisci quibusdam dolorem.

Exercitationem voluptatum et aut et non. Sint aut laudantium earum neque laborum veniam.

Quis excepturi non est est doloribus porro. Dolorum iusto incidunt eaque aut excepturi non. Tenetur dolorem nihil est. Tempore odio mollitia porro ut maiores nam temporibus. Sed numquam magni magnam voluptatem nulla. At quaerat pariatur magnam aperiam nemo sint. Culpa numquam mollitia nostrum odio commodi quia.

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

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...”