Any update on the answer keys? Thanks again for everything!

 

Hello, I would be really interested for your unofficial "answers keys" for the "challenges cases" since I cannot find all of them on Kahr's website. It would be really helpful for me as I am trying to prepare for CRE Interviews. Thanks! 

 

Hi All ~ if anyone has the unofficial answer keys from personal attempts, would love to connect to cross check my attempts / understanding (I'm a newbie to RE modeling). Please PM!

 

Echo RE the answer keys.

Side note....has anybody solved this case from A.CRE?  If so, could you post your excel to google docs and share the link?

THE STONES HOTEL – FINANCIAL MODELING TECHNICAL INTERVIEW

This is a variation of a timed technical interview test previously given by a global real estate private equity firm as part of its hiring process.

Participants are given 60 minutes to complete this test.

ASSUMPTIONS – THE STONES HOTEL

  • 5-year hold period
  • 250 rooms
  • Acquisition price of € 200k/room
  • Acquisition costs are 2% of purchase price
  • Debt
    • 70% loan-to-cost (LTC)
    • 5% interest rate, and requiring mandatory annual debt amortization based on
    • 25-year annual amortization period
  • Occupancy
    • 60% in Year 1, 65% in Year 2, 70% in Year 3, and 75% thereafter
  • Average Daily Rate (ADR)
    • € 325 in Year 1, growing at 5% in Year 2, 4% in Year 3, and 3% thereafter
  • Room Revenues equal 75% of total revenues and other revenues make up the remaining 25% to get Total Revenues
  • Assume the following EBITDA margins:
    • 20% in Year 1
    • 23% in Year 2
    • 25% in Year 3
    • 30% thereafter
  • CAPEX reserves are 4% of total revenues
  • For the exit value, assume a 13x on T12 EBITDA with 2% transaction costs

QUESTIONS – THE STONES HOTEL

  • What is the unlevered and levered IRR?
  • What is the Peak Equity and WDP (whole dollar profit, i.e., undiscounted profit after recovery of the original basis)?
  • Please build sensitivity tables showing the results for the levered IRR and levered WDP with the following variables:
 

Et illo quam odio aut. Et similique repellat consequuntur est et et dolor. Est reiciendis officia nihil nesciunt iste ipsum. Perspiciatis molestiae adipisci omnis aut id.

Ipsam qui repellat autem nisi. Aut voluptatem pariatur voluptas aut.

Animi similique voluptatem et illum. Ab non ipsam est cumque. Ut consequatur deleniti est nam. Qui velit dolor non dolor qui aliquam. Voluptas tempora iste laboriosam repellat. Laboriosam beatae unde voluptatem labore officia eum vitae.

 

Commodi sed quis voluptatem recusandae quaerat ad ad quod. Exercitationem est amet laborum molestias excepturi sit. Et aut mollitia non dolorem. Recusandae vitae quia maiores omnis veritatis fugiat.

Nesciunt voluptate dolorem error ipsa quae nesciunt et ducimus. Maiores molestias saepe facilis dolorum consequatur. Dicta deserunt enim similique vel. Et at impedit similique et. Minus consequatur sit asperiores architecto autem cum sed.

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
Secyh62's picture
Secyh62
99.0
3
Betsy Massar's picture
Betsy Massar
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
dosk17's picture
dosk17
98.9
6
DrApeman's picture
DrApeman
98.9
7
kanon's picture
kanon
98.9
8
CompBanker's picture
CompBanker
98.9
9
GameTheory's picture
GameTheory
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...”