Real estate private equity modelling tests - HELP PLEASE!

Hi guys,


I seriously need your help. So I’ve done a few modelling tests within real estate PE, they’re mainly cash flow models at asset level.


I ALWAYS FAIL THESE AND ITS SO FRUSTRATING!!! All the models I did was slightly different and it really throws me off. 
 

I know the general layout of these models. They start at revenue down to operated expenditure to NOI to debt services blah blah.


I’ve noticed the troubled area I have is around the debt. Some on the modelling tests have no amortisation on debt and others do… with a amortisation schedule you can use PPMT for principal payment on loan and IPMT function for the interest portion only. But what do I do if there is no Amortisation?


I looked at courses such as uDemy, a course by Justin Kivel but it was only a little useful. 
 

please guys if there’s any resources that offer a step by step guide that I can use to learn this for my next modelling test that would be great. Im tired of this and can’t be failing these tests again and again!!


thanks. 

 

Interest only period should be a hard coded function. If the loan is 1,000,000 at 5% then it should be =1,000,000*.05%/12 through the interest only period. Maybe you should watch more udemy and immerse yourself in modeling and you would perform better on these tests 

 

When there is no amort you should thank your lucky stars bc it should save you time. At a big institutional investor and we use 5-10 year interest only debt for everything. Calculate the interest and keep it flat and the debt level the same at payoff, and keep a line for principle/amort at 0 the whole time just to show it as a necessary line item. 10mm loan at 5% is 500k in interest per year or ~41.6k a month and you just roll that on through nice and easy. No special functions needed. Not sure if I’m missing the bigger question here… a lot of loan assumption deals we see have a specific io period which rolls off during the hold and you just do a normal amort schedule and start that on maturity of the io period. Penciling io debt is the best tbh bc it takes two seconds.

 

In est quod veniam non tempora delectus voluptatum. Sequi magnam necessitatibus quo facere. Eos et molestiae ad nemo ut odit a id. Eum vel expedita voluptatem vero aperiam rerum. Fugiat neque quam est sint temporibus ut.

Id qui quaerat sed pariatur tenetur. Voluptatibus eum voluptas ut assumenda fugiat omnis. Amet laborum maiores veniam cumque neque tempore dolor. Tempore tempora deleniti sit voluptas. Eligendi corporis eos ipsum incidunt vel officiis. Mollitia expedita minima sequi eaque. Ut voluptas alias debitis.

Career Advancement Opportunities

March 2024 Private Equity

  • The Riverside Company 99.5%
  • Warburg Pincus 99.0%
  • Blackstone Group 98.4%
  • KKR (Kohlberg Kravis Roberts) 97.9%
  • Bain Capital 97.4%

Overall Employee Satisfaction

March 2024 Private Equity

  • The Riverside Company 99.5%
  • Blackstone Group 98.9%
  • KKR (Kohlberg Kravis Roberts) 98.4%
  • Ardian 97.9%
  • Bain Capital 97.4%

Professional Growth Opportunities

March 2024 Private Equity

  • The Riverside Company 99.5%
  • Bain Capital 99.0%
  • Blackstone Group 98.4%
  • Warburg Pincus 97.9%
  • Starwood Capital Group 97.4%

Total Avg Compensation

March 2024 Private Equity

  • Principal (9) $653
  • Director/MD (21) $586
  • Vice President (92) $362
  • 3rd+ Year Associate (89) $280
  • 2nd Year Associate (204) $268
  • 1st Year Associate (386) $229
  • 3rd+ Year Analyst (28) $157
  • 2nd Year Analyst (83) $134
  • 1st Year Analyst (246) $122
  • Intern/Summer Associate (32) $82
  • Intern/Summer Analyst (313) $59
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...”