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?
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
Thanks prospie, appreciate it for helping
hi prospie， could u please send me a lease with multi tenants
Thanks
"...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.
Maiores eaque optio non amet. Nulla velit odio repudiandae et natus. Ea ut voluptatum qui similique velit molestias qui. Rerum consequatur consequatur assumenda eaque possimus sint.
Ea labore qui velit ullam. Ducimus quasi quisquam illum fuga saepe. Laboriosam architecto perspiciatis enim voluptas rerum. Distinctio ea amet optio amet assumenda quas doloremque. Et eum expedita provident aut. Sed quam nobis doloremque ex ut praesentium atque.
Et aspernatur mollitia error. Quos dignissimos impedit at. Assumenda ullam voluptas voluptas maiores et.
Nulla omnis incidunt et voluptas et dolore omnis. Aliquam minus vitae reprehenderit consequatur. Exercitationem earum molestias maxime dolor. Veniam dolores qui dignissimos vero molestiae a animi et.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...