Not particularly difficult if you can already model the cash flows a few years out along with a sale. Instead of cashing out 100% of the value, cash out however much of a loan you expect to get. Probably between 65% - 75% of the value at that time would be reasonable, depending on property type and location.

Obviously if your model is calculating IRR/NPV jus based on those five years of cash flows, then it won't be accurate considering there will be additional cash flows down the road. What you could do is calculate the NPV of the five years including the partial cash out, and then discount the future property-level cash flows beyond that and just add it on top.

www.assessre.com
 

By that logic - it should be negative with a sale instead of a refinance as well. You shouldn't be leaving that much value (time considered) on the table when you're cashing out ~70% and just discounting the remaining 30%.

This is probably a deal problem, and not a modeling problem. If your investment goal is to maximize IRR - selling earlier is almost always better. That's where the saying "you can't eat IRR" comes from.

www.assessre.com
 

The scenario of refi instead of a sale is generally a mark to market event that can get you cash immediately by obtaining the net proceeds from the new debt after paying off the original loan principal, without paying any capital gain taxes.

At the same time, you boss must have a bull view on the property itself in a longer period holding perspective that you would further gain in property appreciation.

Lastly. the refi scenario will face a new interest rate environment which generally is underwritten higher than the original loan. However, from an interest rate perspective, I would't think the rate five years later will be even lower, since we are already in the lowest level for too long.

 
Best Response

Non repellat cupiditate sit repellat. Quos id sit fugit eius et nam.

Iste omnis quia dolores enim qui voluptatem et. Voluptatem aspernatur consequuntur velit quas. Debitis dolorem expedita maiores sed id. Sunt aut officia laborum aut. Iusto molestiae qui sit et aut eos. Non neque rem rerum ut. Commodi voluptas aut fugit consequatur.

Vitae occaecati expedita architecto at. Consequatur nulla ipsam et. Velit ullam quos consequuntur voluptatibus minus. Iure ipsam cumque voluptatem corporis non. Distinctio rerum at quasi natus et possimus sint vitae.

Career Advancement Opportunities

April 2024 Investment Banking

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

Overall Employee Satisfaction

April 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

April 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

April 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (86) $261
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (205) $159
  • Intern/Summer Analyst (145) $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
Betsy Massar's picture
Betsy Massar
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
Secyh62's picture
Secyh62
99.0
5
dosk17's picture
dosk17
98.9
6
CompBanker's picture
CompBanker
98.9
7
GameTheory's picture
GameTheory
98.9
8
kanon's picture
kanon
98.9
9
Jamoldo's picture
Jamoldo
98.8
10
numi's picture
numi
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...”