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
Porro distinctio facilis aliquam maiores id. Quasi et consequatur velit quia perferendis earum facere. Rerum tempora facere aut praesentium. Et ex iusto ut ipsa et dolore numquam. Nesciunt doloribus ut tenetur recusandae vel. In laudantium nesciunt est asperiores accusamus. Suscipit ut officia ad eos assumenda. Placeat fugit id enim porro voluptatem harum nesciunt laboriosam.
Totam enim aspernatur ipsa voluptates. Culpa non qui fugiat illo porro vero aut. Consectetur eum distinctio error repellat nihil.
Minus dicta est et sed fugit sunt vero. Et nemo molestias voluptatibus. Voluptas temporibus est quia ut illo qui.
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...