Updated some of the details. Removed COL reference as I don’t think it’s a pertinent detail. Hoping to get some additional opinions as it seems we are getting near a decision to buy a new house.
I’m not entirely sure what the end game would be. Either sell when I get old enough and don’t want to deal with it, or maybe gift it to my child. In either scenario I should be FIRE so income would only be from dividends/withdrawals to cover expenses. In the event I’m still working at that time it’s likely I would have 50x expenses and wouldn’t be too worried about maximizing/optimizing every dollar.
If I sell now and net ~$65K, the hypothetical $8K/yr is a 12.3% ROE. While certainly not a passive investment, that’s not a bad return and above historic stock market yields. That also wouldn’t take into account principal pay down.
Based on the information you provided, it looks like you put 5% down. Is that correct? When I enter your information into a mortgage calculator, I get $1551 for the PI. You put $1590 for PI. Does that mean $39 for mortgage insurance? Not a big deal, but that seems a little low to me.
You are correct that the 1% rule does not factor in mortgage rates, property taxes or insurance. The 1% rule is a "proxy" for cash flow, but it doesn't directly measure cash flow. Because of your low mortgage rate and reasonable taxes and insurance, it looks like you have a spread of about $900/month. Based on your amortization schedule, your principal pay down at the moment is around $705/month. This deal is also unique, because it looks like you only put 5% down.
As a pure investment, I would keep it. However, you also need to consider the hassle factor. For me personally, the hassle factor would be worth it to keep it. If you work 2500 hours/year at a high paying corporate gig, the hassle factor might not be worth it. Are you able to do any simple repairs yourself? I replaced a p-trap in a bathroom sink for $4 and took me 10 minutes. A professional plumber would cost $250.
I put 5% down on a primary in January 2012 with an original mortgage rate of 4% that is now a rental. Original purchase price was 95K and I had 16K worth of rehab. Original PITI was $685/month, including $42 of PMI. Original mortgage today would be around $900/month with increases to taxes and insurance. The rental is now worth about 375K and rents for $2550/month. My actual mortgage is $1519/month because I did a 107K cash out re-fi to buy my current primary home in 2019.