Help wanted for RE Debt interview/case please!


-edit--edit--edit--edit--edit--edit--edit--edit--edit--edit--edit--edit--edit--edit--edit--edit--edit--edit--edit--edit--edit--edit--edit--edit--edit--edit--edit--edit--edit--edit--edit--edit--edit--edit--edit--edit--edit--edit--edit-

 
Most Helpful

1. NOI is your revenues less operating expenses. You're correct to exclude depreciation and mortgage expense.

2. I would personally include the security deposits as revenue, especially since they provided the information, but in reality some firms would exclude it from revenue for valuation purposes.

3. Since it sounds like they are just asking you to underwrite 2021 rent and not a multiple year cash flow, there's no need to discount anything to PV - your valuation of the property would be based on the forward looking twelve months (i.e. 2021) anyways. If they aren't asking for a multi-year cash flow, your valuation should just be a direct capitalization on the 2021 NOI.

4. Historical vs. Underwritten - Historical is the 2020 actuals they provided, underwritten is going to be the NOI you calculate based on the 2021 rent roll/expense forecasts they gave you.

5. Considering they gave you the actual monthly payments for the loan, you don't NEED to build an amortization table for LTV and DSCR, but I'd advise you do it anyways because it's not hard and shows you went the extra mile. Your LTV calculation is correct, DSCR needs to be flipped - it is a multiple, so your NOI divided by your total annual debt service (i.e. principal and interest payments).

6. Other relevant metrics - debt yield (NOI/loan amount) and loan constant (debt service/loan amount).

 

Thank you for this, super helpful!

I was wondering in terms of qualitative analysis, would the Borrower's other properties/financial profile be relevant to the loan? Or is the loan only able to be repaid by the commercial mortgage it is linked to (I'm unsure of industry practice)? Would be helpful to hear if there are any other factors besides absolute cash flow that go into looking into underwriting a loan. 

 

Thank you, are there key categories of debt/loans or debt terms I should look into for CRE?

I also wanted to ask more on the discrepancies on Historical VS Underwritten/Forward Looking NOI. Given that the Rent Roll provided only shows rent / sq ft and recoveries and no operating expenses, should I apply the % of historical revenue that op ex was a percentage for them to be comparable? Given that there is a discrepancy, do base rent/recoveries ranges change often?

 

Minima ea in nemo quia delectus. Veritatis corporis quas ad dolorum cumque sunt quisquam. Ipsam omnis enim iure atque iste accusamus.

Est harum ducimus nulla. Et placeat quod optio officia ut est autem. Voluptate corrupti ducimus distinctio excepturi. Sed voluptas soluta dolorem suscipit deleniti facilis atque.

Cumque nihil vitae sed omnis voluptatibus itaque. Rerum consectetur ipsum eum in itaque. Incidunt est dolorum officiis minima minima maiores quia. Odio culpa cumque et. Quisquam rerum aut rem minima est natus. In saepe accusantium debitis voluptatem aut impedit. Voluptate ipsum quasi explicabo et omnis id. Optio non explicabo quaerat cupiditate unde similique nesciunt.

Aperiam rerum ipsum ut occaecati debitis earum veniam nemo. Earum laboriosam mollitia nihil quas debitis error architecto alias. Temporibus cum et necessitatibus et quisquam. Assumenda impedit accusantium nam debitis ex. Voluptates commodi nemo dolor quia cupiditate. Laboriosam nobis delectus architecto ullam et consequatur.

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