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?

Private Equity Interview Course

  • 2,447 questions across 203 private equity funds. Crowdsourced from over 500,000 mem.
  • 9 Detailed LBO Modeling Tests and 15+ hours of video solutions.
  • Trusted by over 1,000 aspiring private equity professionals just like you.

Comments (9)

Aug 29, 2012

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.

Aug 29, 2012

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?

Aug 29, 2012
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.

Aug 29, 2012
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

Aug 30, 2012
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.

Learn More

Side-by-side comparison of top modeling training courses + exclusive discount through WSO here.

Aug 29, 2012
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

Nov 7, 2013

hi prospie, could u please send me a lease with multi tenants

Thanks

Aug 29, 2012

"...how hard is the other part?"

"Not hard."

Can you provide some background on your seemingly already answered question?

It should take <15min to find the rent roll and read over the expense addendum.

Sep 5, 2012