Quick question on the All in One model regarding rent bumps, if I’m looking at Cash Flows on a monthly basis, it incorporates rent bumps according to the analysis start date. Is there any way to link it to the actual lease end date instead?
You are correct, that is one of the limitations of this model. However, if you select to model bumps as a percentage per year or an amount per square foot/meter per year, the bumps do occur on the anniversary of the lease start date each year.
With that said, if you’d like to model more detail into a specific tenant(s), the advantage to Excel (as you know) over non-Excel options like ARGUS is that you can manipulate the guts of the model. To do this, set the Calculation tabs to ‘Show’ on the Summary tab, go to ORI-Calc, and then edit the 1st Gen Rent (columns MM:RN) of the tenant(s) in question. My only recommendation would be to set the font color of the cells you change to red to remind yourself later that you changed those cells.