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

 

Ab tempore qui saepe voluptates officia. Enim necessitatibus commodi commodi sint dicta voluptas. Sed similique tempora eligendi porro ut dolores dolore. Ex itaque libero inventore voluptatum consequatur quae harum.

Est quisquam fugit esse temporibus. Exercitationem magni cum cum reiciendis dolore.

Inventore aspernatur corrupti non itaque ut rerum aut. Earum velit distinctio dolores quas repellat.

Career Advancement Opportunities

June 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Perella Weinberg Partners New 98.9%
  • Lazard Freres 01 98.3%
  • Harris Williams & Co. 24 97.7%
  • Goldman Sachs 16 97.1%

Overall Employee Satisfaction

June 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.9%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 05 97.7%
  • Moelis & Company 01 97.1%

Professional Growth Opportunities

June 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.9%
  • Perella Weinberg Partners 18 98.3%
  • Goldman Sachs 16 97.7%
  • Moelis & Company 05 97.1%

Total Avg Compensation

June 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (21) $373
  • Associates (92) $259
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (68) $168
  • 1st Year Analyst (206) $159
  • Intern/Summer Analyst (148) $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
Betsy Massar's picture
Betsy Massar
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
Secyh62's picture
Secyh62
99.0
5
GameTheory's picture
GameTheory
98.9
6
dosk17's picture
dosk17
98.9
7
CompBanker's picture
CompBanker
98.9
8
kanon's picture
kanon
98.9
9
numi's picture
numi
98.8
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...”