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

Comments (1)

Start Discussion

Popular Content See all

HELP: Sticky Situation with Boss
+156OFFby 2nd Year Analyst in Investment Banking - Mergers and Acquisitions">Analyst 2 in IB-M&A
Arranged Marriage
+41OFFby Intern in Real Estate - Commercial">Intern in RE - Comm
Ask a girl
+38OFFby 1st Year Analyst in Investment Banking - Generalist">Analyst 1 in IB - Gen
tipping point - mental breakdown
+34IBby 1st Year Analyst in Investment Banking - Industry/Coverage">Analyst 1 in IB - Ind
To Snitch or not to Snitch?
+32OFFby 2nd Year Analyst in Investment Banking - Industry/Coverage">Analyst 2 in IB - Ind
Would you date a girl without a college degree?
+31OFFby Intern in Consulting">Intern in Consulting
Caught relaxed vibing to music by my MD
+17OFFby 1st Year Analyst in Investment Banking - Corporate Banking">Analyst 1 in IB - CB

Total Avg Compensation

March 2021 Investment Banking

  • Director/MD (9) $911
  • Vice President (31) $349
  • Associates (168) $231
  • 2nd Year Analyst (98) $151
  • Intern/Summer Associate (93) $145
  • 3rd+ Year Analyst (23) $145
  • 1st Year Analyst (371) $131
  • Intern/Summer Analyst (308) $82

Leaderboard See all

1
LonLonMilk's picture
LonLonMilk
98.5
2
Jamoldo's picture
Jamoldo
98.4
3
Secyh62's picture
Secyh62
98.3
4
CompBanker's picture
CompBanker
97.8
5
redever's picture
redever
97.7
6
frgna's picture
frgna
97.6
7
Addinator's picture
Addinator
97.6
8
Edifice's picture
Edifice
97.5
9
bolo up's picture
bolo up
97.5
10
NuckFuts's picture
NuckFuts
97.5