I found a freshly remodeled duplex in my city and ran the numbers (see attached). The property exceeds the 1% rule, looks nice with granite counters and new bathrooms, and is in a stable and quiet grade-C neighborhood of duplexes and small SFHs. Appreciation is not expected to be a significant factor. I have enough cash idling in 4.6% yielding US treasuries to buy the thing without a mortgage if I wanted to.
Assuming I could get a 6.5% mortgage (probably a low estimate, Zillow is offering 7% and a lot of websites show no offers), and the other assumptions on the spreadsheet, the total ROI amounts to:
Y1: 3.60%
Y5: 7.00%
Y10: 12.27%
If I set the down payment to 100% and change nothing else - not even estimated closing costs - the cash ROI equals:
Y1: 5.70%
Y5: 6.37%
Y10: 7.38%
The unleveraged ROI is higher in the short term and lower in the long term. Thus the decision to get a mortgage or pay cash for this duplex comes down to one's estimate about whether there will be rate cuts in the next few years. One would NOT want to get a 6.5% or 7% mortgage now, paying a couple grand for the privilege, only to refinance in 2 or 3 years when rates are much lower and get to pay those same costs again.
If rates fell significantly after one paid 100% cash for the duplex (like to 4.5% for example), one would mortgage the duplex to enjoy leveraged returns and be happy they did not pay the costs of getting a mortgage a few years ago when it was bought. Plus, in that world one might be glad to have tied up their money in a modest-yielding duplex rather than stocks, because a recession was probably the cause of the rate cuts.
If rates rise significantly, one might regret not getting a mortgage at a lower rate when that was possible. One might also regret tying up their money earning a 6-7% ROI from mortgage avoidance when treasuries now yield that much. It might now be uneconomical to extract one's money from the duplex using a mortgage.
What are your thoughts? Am I misusing the spreadsheet? Has anyone changed their investment property buying behavior due to higher mortgage rates?