Annual Rental Growth Rate Question

Hi Guys,

I was hoping  someone could help me with writing  my formula  for rental growths.

I have a Y1 price per sqft. with Y1, Y2, Y3 growth rates alongside varying occupancy rates.

I am trying to project out monthly cashflows  but have now confused myself on how to proceed...

I was doing   =SUM(Rent  Psf    * Occupancy/12)*  (1+r)^(Y-1)

But there are   a few different ways to do this - which is correct....

- (1+r)^(M-1)

-(1+r)^(1/12)

I want to know what is best to use for monthly growing - or at the start of each year growth  - which I think is incorporated here somewhere.

*Note I have a vlookup for the actual rate since it varies depending on year but for simplicity have left this out.

Y = Year

M = Month

I cannot take last month's revenue since it was dependent on occupancy which moves (i.e. it is not stabilised) 

Real Estate Modeling Course

  • Real-life RE Modeling Tests from actual Interviews
  • Various asset classes including multi-family, commercial and more
  • Huge discount - until more tests and cases added

Comments (5)

Jul 27, 2021 - 9:55pm

If this a monthly model, for rent growth monthly, starting in month 2, look back at the previous month, and multiply by (1+.03/12) and if you want to do annual rent growth, in month 13, look back to month 1 and multiple by (1+.03) and drag the formula across. If you want to adjust rent growth, create a table and use a lookup function to find the right growth rate. 

Jul 30, 2021 - 4:30am

Dicta omnis eius necessitatibus quod. Illo exercitationem fugit veniam perferendis vitae. Officia neque a enim. Deleniti laudantium nisi quod modi numquam ad dolorem.

Qui ea accusamus ut iure pariatur. Iure ut assumenda ut odit magni vel mollitia. Voluptatem occaecati fugiat blanditiis nihil doloremque eum dolores.

Start Discussion

Total Avg Compensation

November 2021 Investment Banking

  • Director/MD (10) $853
  • Vice President (40) $360
  • Associates (236) $235
  • 2nd Year Analyst (145) $156
  • 3rd+ Year Analyst (34) $154
  • Intern/Summer Associate (107) $146
  • 1st Year Analyst (514) $136
  • Intern/Summer Analyst (394) $84