IRR - 3 Year vs 5 Year Hold

As a Financial Analyst, I am frequently modeling commercial real estate deals. Typically, I will do a 3 Year and 5 Year analysis. Most of the time, the 3 year analysis will yield a higher IRR than the 5 Year analysis. However, in the current deal I am modeling, the 5 year analysis is yielding a higher levered IRR than that of the 3 year by 5 points! In this case, the deal is a single-tenant, Triple-Net long-term lease with 2% annual income growth. No rent abatement, tenant improvements, or leasing commissions. I would share the debt assumptions, but I don't think that will be necessary because the unleveraged IRR for the 5 year analysis is still 133 bp higher than the 3 year analysis.

I would appreciate any insight that any of you may have.

 
Best Response

Is your exit cap higher than your unleveraged IRR? I'm not sure that will always make a difference but just testing a $1000 purchase price, $100 rents escalated annually 2%, and a 10 cap at reversion I get a lower IRR for the 3 year hold (8.23%); however, if you change your exit to an 8 cap in the same scenario you will see the 5 year is lower.

 

I played around with the numbers and did find examples of exit caps which were lower than the unleveraged IRR, but still resulted in the 3 year IRR being lower. I guess what you said can't be used as a golden rule.

 

Ut incidunt quaerat exercitationem recusandae iure illum et. Est in numquam et nulla explicabo in rerum labore.

Est et labore officia sit quisquam omnis. Sit dolorem error aliquid reiciendis consequatur. Est quia rerum vero est nostrum soluta earum voluptatem. Voluptate dolorem aut corrupti consequatur deleniti maxime deserunt ipsum. Quae alias atque maiores in voluptas nisi. Qui molestiae deserunt dolore aut molestiae vel.

Career Advancement Opportunities

March 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. (++) 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

March 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

March 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

March 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (86) $261
  • 3rd+ Year Analyst (13) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (202) $159
  • Intern/Summer Analyst (144) $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
DrApeman's picture
DrApeman
98.9
7
dosk17's picture
dosk17
98.9
8
GameTheory's picture
GameTheory
98.9
9
CompBanker's picture
CompBanker
98.9
10
Jamoldo's picture
Jamoldo
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...”