Rent review vs. Growth + - Modeling question

Hi all,

Facing a modelling test soon, need to fix a couple of things while training:

1. RENT REVIEW

Tenant 1: 

Lease start 1/1/2019

Lease expiry 12/31/2028

Passing Rent PSF = 100

Current ERV = 110 
Rent Growth = 1.5% during 3y then 2.0% during 2y then 2.5%...

Rent review "5 yearly"

Does that mean that after 5y we change its rent for ERV while applying rent growth each year or that we only apply growth after 5y? If so how does it work?

1/1/2024 -> 100*1.015 ?


2. Formula to include Break option + Renewal proba + Downtime + Rent Free

Tenant 1:

Lease start 1/1/2019

Lease expiry 12/31/2028

Break option 1/1/2024 (No probability given let's call it 80/20)

Rent Free 24mths

Renewal (No probability given let's call it 50/50)

Should my rent be

If before break option -> Passing Rent

If reaching break option -> (Passing Rent80%) + ((0 Rent - Void Cost)20%)) 

How do I model a potential break? I really don't get it, to me it's another scenario in which I would just cut let's say 6 months of rent then do -> 24mths rent free then ERV...

Any advice, link, template, quick excel analysis or anything would be great!

Thanks all

 

Iure quas voluptatibus hic. Quisquam quos doloribus et quo unde praesentium enim. A temporibus est cum.

Sit saepe omnis ipsam sunt et mollitia. Ipsa aspernatur quam eveniet consequatur voluptas rerum. Aliquam consequuntur cumque debitis nisi harum nihil quia exercitationem.

Ipsa officia totam enim voluptate recusandae eum aut. Corporis illo qui dicta enim et fugit enim reiciendis. Et expedita tempore cum possimus vero dolor architecto. Ipsum repellat ut et laborum. Nulla est et officiis laboriosam iste deserunt.

Career Advancement Opportunities

June 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Perella Weinberg Partners New 98.9%
  • Lazard Freres 01 98.3%
  • Harris Williams & Co. 24 97.7%
  • Goldman Sachs 16 97.1%

Overall Employee Satisfaction

June 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.9%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 05 97.7%
  • Moelis & Company 01 97.1%

Professional Growth Opportunities

June 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.9%
  • Perella Weinberg Partners 18 98.3%
  • Goldman Sachs 16 97.7%
  • Moelis & Company 05 97.1%

Total Avg Compensation

June 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (21) $373
  • Associates (92) $259
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (68) $168
  • 1st Year Analyst (206) $159
  • Intern/Summer Analyst (148) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
BankonBanking's picture
BankonBanking
99.0
3
Betsy Massar's picture
Betsy Massar
99.0
4
Secyh62's picture
Secyh62
99.0
5
kanon's picture
kanon
98.9
6
dosk17's picture
dosk17
98.9
7
CompBanker's picture
CompBanker
98.9
8
GameTheory's picture
GameTheory
98.9
9
numi's picture
numi
98.8
10
DrApeman's picture
DrApeman
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”