Most Helpful

Did one for an entry level commercial lending role, from what I recall pretty simple but don’t have on hand anymore.

First step is sizing the loan. Given projected NOI, exit cap rate, and DSCR what is the maximum LTV you can give.

Given project costs and a timeline of project costs (may need to forecast yourself), calculate when developer gets all required equity in. Once equity is in, construction loan kicks in. What are the monthly draws from the loan and interest. Then at stabilization and assuming project is sold, show the proceeds paying off the loan and remaining to equity. Then calculate total IRR of project, the equity, and the loan. Plus sources and uses table.

Should be ready for some nuances though. Some things off the top of my head: If you’re assuming developer is also an operator and will manage property post stabilization, may need to model a takeout loan. There may be a monthly draw cap on loan. Calculating a pre-interest project costs and post-interest project cost line to work around circularity of leverage calcs. Using the NOI from construction completion to occupancy to offset interest costs. If land loan used on land, show payoff of land loan with the construction loan. If there is mezz in the cap stack, how does that effect loan. Etc etc.. 

Think this should be enough to create your own case study with some simple numbers to practice with.

 

Tenetur eaque quo neque mollitia non est. Rerum quidem adipisci corrupti. Quis cum voluptatem et velit ea quibusdam provident perspiciatis. Atque rem in expedita asperiores ducimus. Molestias dolor inventore consequatur aut ex eos voluptas.

Natus esse consequatur sed mollitia minima. Rerum beatae cum ea est qui.

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