I'm a multifamily guy that is trying to learn office modeling.
I've tried several ways of modeling this and can't quite figure it out. I have the BIWS modeling course, but their office model is way more complex than the relatively simple scenario I'm trying to figure out. Here's what I'm trying to model:
I want to model a market rental rate that starts at time 0 and grows each year by x%. I then want to model x individual tenants whose leases all start at different months at the then market rental rate. I then want increase each of these tenants' rents every 1 year from the start of their individual leases by x% (so if Tenant 1 starts in month 6, their rent would increase by x% in month 18) through the end of the hold period.
How do you dynamically model this type of scenario in Excel?
