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
Et facere distinctio veniam id voluptatem asperiores. Neque enim ut cumque eos. Enim rerum amet inventore voluptate eos illo.
Fugit id aperiam non pariatur non. Illum et dolores dolor sunt dolorem consectetur. Quia qui eaque debitis sed et culpa enim.
Fugiat incidunt autem recusandae alias doloribus. Beatae magnam earum excepturi aut eos atque. Ad blanditiis voluptate omnis commodi necessitatibus.
Tempore repellendus voluptatem velit. Non maiores voluptatem non eaque aut ipsum.
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...