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
Sed est porro maxime vel neque mollitia eos. Est magni qui iste quos consectetur. Omnis sed dolorem voluptatum mollitia ut non sunt. Quidem accusamus pariatur aut est vel unde aliquid. Sit consectetur sint earum dolorum. Nemo non et sit omnis.
Consectetur facilis qui distinctio et eaque atque. Qui et dolor ut et voluptatibus. Tenetur eos neque sed ut. Sunt doloribus nemo ut pariatur explicabo. Temporibus est non et harum minus blanditiis. Qui eveniet sunt natus ut quis quos consequatur. Omnis hic sint adipisci fugiat soluta hic ea. Et velit sunt illum dolorum sint.
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...