Underwriting Help

So a MD from a large brokerage (think JLL , Cushman, CBRE etc.) asked me to underwrite an old deal they did pretty much as a test. They sent me the model they use, the assets past year financials (rent roll, debt quotes, and income statement), and location market data. My question is where should I begin as I am a bit confused. Am I just inputting the income state lines into the model and then the model will generate the next month /years pro forma? Or should all the inputs be new things I calculate? Thanks in advance for any help. 

Comments (8)

 
Most Helpful
Feb 22, 2021 - 8:13pm

You're definitely definitely going to want to find out whether or not they're sending the model as a example or a tool to help you with valuation. 

I feel like a brokerage would just want you to analyze the deal by inputing data into their current model. If that's the case, then find the value of the property by determining NOI and apply a reasonable cap rate to it based off the asset class and market. Input the financing assumptions and see if it would check out with lenders basic criteria. Try to find any potential hiccups in a deal and think about how the landlord could maximize their property's value.

If they want you to build out your own model than they're probably just making sure your competent in excel. In that case focus less on property assumptions and more on creating a sophisticated spreadsheet with correct formulas. Use the example model as a format guide and to see what KPI's the MDs are looking at.

 
Feb 22, 2021 - 8:36pm

Thanks so much for the response. Yea they just want me to analyze it with their in house model. Its a student housing asset, So im assuming I use the last school years          ( sept. 2019-August 2020) income statement as my inputs? Or do I need to use the last months ( August 2020) inputs and then apply growth assumptions based on market data?

 
Feb 22, 2021 - 9:12pm

Both

If it's a cash flowing asset and doesn't have a value add component to it, use last years income statement to find out NOI. Do some market research, look at comps, and apply a cap rate that you think it would transact at. The cap rate is the tricky part, you need to be able to justify why you chose it. This is going to determine a reasonable sales price. 

Input all the assumptions into the pro forma that projects out future cash flow as well. The assumptions might already be in place but if they aren't don't worry too much about making the right growth assumptions. They won't expect you to be an expert. 

Input all the lending assumptions into the model as well. Make sure the property will meet the lenders basic requirements like debt to income ratio. 

At the end of the exercise you should ultimately be able to speak to why the property would transact at the sales price you came up with. The pro-forma and lending portion is really just to make sure the investments future outlook checks out number-wise. 
 

 
Feb 22, 2021 - 9:45pm

Prefect will do, they want it for 2020-2021 school year so I started the model date Sept 20 and ended it Aug. 21 The income statement ends on August 2020, so im going to use all the inputs from that month and then find the growth assumptions to add to that for the rest of the year. Will find an exit cap rate for 2021 like you said. Thanks man 

Start Discussion

Popular Content See all

LETS FKING GO BOYS
+133IBby Intern in Corporate Finance">Intern in CorpFin
You Did it Citi
+120OFFby 2nd Year Analyst in Investment Banking - Industry/Coverage">Analyst 2 in IB - Ind
HELP: Sticky Situation with Boss
+115OFFby 2nd Year Analyst in Investment Banking - Mergers and Acquisitions">Analyst 2 in IB-M&A
Idgaf anymore
+31IBby 1st Year Analyst in Investment Banking - Industry/Coverage">Analyst 1 in IB - Ind
Anyone else just want out of this shit?
+30IBby 2nd Year Analyst in Investment Banking - Generalist">Analyst 2 in IB - Gen
Evercore Target Schools?
+26BSCHby Prospective Monkey in Investment Banking - Mergers and Acquisitions">Prospect in IB-M&A
To Snitch or not to Snitch?
+21OFFby 2nd Year Analyst in Investment Banking - Industry/Coverage">Analyst 2 in IB - Ind

Total Avg Compensation

March 2021 Investment Banking

  • Director/MD (9) $911
  • Vice President (31) $349
  • Associates (162) $231
  • 2nd Year Analyst (97) $151
  • Intern/Summer Associate (92) $144
  • 3rd+ Year Analyst (23) $145
  • 1st Year Analyst (370) $131
  • Intern/Summer Analyst (306) $82

Leaderboard See all

1
LonLonMilk's picture
LonLonMilk
98.5
2
Jamoldo's picture
Jamoldo
98.4
3
Secyh62's picture
Secyh62
98.3
4
redever's picture
redever
97.8
5
CompBanker's picture
CompBanker
97.8
6
frgna's picture
frgna
97.6
7
Addinator's picture
Addinator
97.6
8
NuckFuts's picture
NuckFuts
97.5
9
Edifice's picture
Edifice
97.5
10
bolo up's picture
bolo up
97.5