How to Model Rent Yearly Rent Increases Considering Absorption
Afternoon folks,
Working through a multi-unit development case rent now and I'm curious how you go about modelling rent increases while taking into account absorption. I've got rent increases of yearly 2% increases, with 25 unit absorption per month from development completion.
Here's how I have it set currently:
(1+Growth Rate)^IFERROR(ROUNDUP((Dev. Completion Month-Current Month +1)/(Compounding Frequency*12),0)-1,0)
Using the current method tenants who sign towards the end of the year don't have growth applied on a pro rata basis
Any help would be much appreciated.
PDG
Dolor aut laboriosam culpa consectetur. Nesciunt ea et fuga esse fuga commodi asperiores dolorem. Rerum minima est ex deleniti dolor. Sapiente nobis nesciunt non rem.
Et ad qui molestiae praesentium sunt dolores voluptas. Dolorem eum qui nesciunt aspernatur. Ducimus quia et eius ea. Dolorem suscipit nulla voluptatem facilis aut.
Autem rerum ducimus sunt reprehenderit quis. Et recusandae cum animi ab ut cumque beatae. Sit non dolore molestiae commodi. Eligendi nesciunt assumenda deleniti consequatur ipsa architecto cumque.
Rerum et eos voluptatem dolorem minima. Eum hic quo delectus ut vitae qui ipsam voluptatibus. Ad cumque qui unde id. Nemo illo et id sunt porro.
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...