Rent Bumps

  • Lizzie Boyer
    Keymaster
    7 years, 9 months ago #2608

    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?

    Spencer Burton
    Keymaster
    7 years, 9 months ago #3090

    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.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.