Small question on cash flow modeling in CRE

If you wanted to build a cash flow forecasting model of an institutional grade property in Excel or Argus, how hard is the actual part where you're extracting the information from the leases (assuming you have them), income statements, etc, vs. the actual modeling in excel or argus?

 

Not hard. If you have the correct information, it is just a matter of knowing where to look in order to get that info.

Typically, you will want to know:
Annual Income
Annual Expenses
Capital Expenditures
Lease Terms (Dates, Rental Increases, Options, is it NNN, MG, or Gross, etc)

You will be able to get all of that information from the forms you stated above. If you know where and what to look for it wont take long.

Modeling in Excel and Argus: Again, depends on how complex/how well you know Argus. Many times your model should already have some amount of a template in excel

If you ask something more specific in regards to those, I can be more specific as well.

 

Thanks. I just mean -- if you've never seen a lease for space in institutional grade properties, how long would it take to dig out all the relevant information? Or in other words, assuming you know the Excel/Argus modeling piece very well (at least for tenant cash flow, not necessarily debt modeling), how hard is the other part?

 
Best Response
econcomputingCRE:
Thanks. I just mean -- if you've never seen a lease for space in institutional grade properties, how long would it take to dig out all the relevant information? Or in other words, assuming you know the Excel/Argus modeling piece very well (at least for tenant cash flow, not necessarily debt modeling), how hard is the other part?

I cannot really answer this since I dont know your background, prior real estate knowledge, how sharp you are... I would say for the average person to go through an average lease and dissect it so you have the correct information out of it, it should take 20 minutes give or take. The "hardest" part of reading a lease, is reading the lease...some legal jargon in there you might have to reread to make sure you understand it. It's really not difficult though.

 
Nobama88:
econcomputingCRE:
Thanks. I just mean -- if you've never seen a lease for space in institutional grade properties, how long would it take to dig out all the relevant information? Or in other words, assuming you know the Excel/Argus modeling piece very well (at least for tenant cash flow, not necessarily debt modeling), how hard is the other part?

I cannot really answer this since I dont know your background, prior real estate knowledge, how sharp you are... I would say for the average person to go through an average lease and dissect it so you have the correct information out of it, it should take 20 minutes give or take. The "hardest" part of reading a lease, is reading the lease...some legal jargon in there you might have to reread to make sure you understand it. It's really not difficult though.

Thanks. I just wasn't entirely sure on the answer because your first response seemed qualified with the statement "if you know where to look" or something like that. Thanks. I was just wondering--I've never seen the leases for institutional grade property and wondered if it was some legalese nightmare

 
econcomputingCRE:
I was just wondering--I've never seen the leases for institutional grade property and wondered if it was some legalese nightmare
if you're really curious, i can easily send you a lease or two for some decent-sized tenants - just PM. they're not written in chinese or anything.
 
prospie:
econcomputingCRE:
I was just wondering--I've never seen the leases for institutional grade property and wondered if it was some legalese nightmare
if you're really curious, i can easily send you a lease or two for some decent-sized tenants - just PM. they're not written in chinese or anything.

Thanks prospie, appreciate it for helping

 

Quam qui dolorem ducimus sunt. Nisi alias numquam et ipsa magni. A odit doloribus assumenda recusandae est optio.

Consequatur repudiandae nisi voluptatem vel et vel voluptas dolorem. Sint temporibus amet quod aperiam eaque. Blanditiis enim sunt vero quasi. Et quam eos maxime voluptates id.

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 (86) $261
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (205) $159
  • Intern/Summer Analyst (145) $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

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