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?

9 Comments
 

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

 
econcomputingCREI 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
econcomputingCREI 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

 

Dolore pariatur quibusdam sunt a neque et rem. Dolor quo et molestiae reiciendis ex dolorum. Veniam vero recusandae ipsa. Aperiam maiores quia aliquam voluptatum harum enim architecto ut.

Facere omnis ut soluta velit sed ut aut. Voluptate nihil et repellendus voluptatem. Impedit sed sequi rerum. Ratione tempora eligendi omnis amet.

Itaque quo quisquam iste in eos labore tenetur. Expedita qui repudiandae blanditiis debitis est sequi. Laudantium itaque incidunt omnis dolores est recusandae. Distinctio tempora doloribus totam ut accusantium. Eius ex velit eveniet voluptatem fuga. Veniam repellat tenetur amet.

Career Advancement Opportunities

September 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 98.9%
  • JPMorgan 01 98.4%
  • Morgan Stanley 07 97.9%
  • Goldman Sachs 02 97.3%

Overall Employee Satisfaction

September 2026 Investment Banking

  • Moelis & Company No 99.5%
  • Morgan Stanley 02 98.9%
  • Evercore 01 98.4%
  • Banco Santander 02 97.9%
  • BMO Capital Markets 12 97.3%

Professional Growth Opportunities

September 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 98.9%
  • Morgan Stanley 05 98.4%
  • Goldman Sachs 01 97.9%
  • JPMorgan No 97.3%

Total Avg Compensation

September 2026 Investment Banking

  • Vice President (16) $429
  • Associates (53) $259
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (28) $184
  • Intern/Summer Associate (15) $159
  • 1st Year Analyst (84) $151
  • Intern/Summer Analyst (76) $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
kanon's picture
kanon
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
Secyh62's picture
Secyh62
99.0
5
CompBanker's picture
CompBanker
98.9
6
Betsy Massar's picture
Betsy Massar
98.9
7
dosk17's picture
dosk17
98.9
8
DrApeman's picture
DrApeman
98.9
9
GameTheory's picture
GameTheory
98.9
10
numi's picture
numi
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...”