What I'm really trying to wrap my head around is "how would the equity we have in this rental have otherwise performed if we sold at different times and invested the money?" I don't want to buy other rentals. I just want to know if this rental has held its own vs. the stock market or is it a dog.
I *think* what I've landed on is determining the sale proceeds from a hypothetical sale each year and then using appreciation, mortgage pay down, and cash flow values to calculate a return. That's a true apples to apples comparison. I can even take this a step further and compare the amount we would have received had we sold the house when we moved out at the end of 2017, and subsequent market returns had we invested those funds, compared to the gains in appreciation, mortgage pay down, and cash flow over the last 6.5 years.
If that's the comparison, the rental is actually the winner by a significant margin. Had we sold the house at the end of 2017 and invested the proceeds, our total return (if invested 100% S&P 500) would have been 93%. By contrast, the appreciation, mortgage pay down, and cash flow amounts represent a 225% return on the proceeds of having sold the house in 2017. Mortgage pay down and cash flow are 84% of that and appreciation is the other 141%. Selling costs and taxes will be slightly higher now that the house is worth more and more depreciation has been taken so we could knock a few percentage points off of that 225% figure but that's still a pretty compelling number.
I suppose the wildcard is how you view housing and price appreciation. It doesn't have to appreciate. The area this house is in actually lagged behind the bigger pandemic home price explosion so the appreciation hasn't been as extreme as some other places. Without that component, the house under-performed the S&P and, considering the additional risk compared to index fund investing, that's a dog.
Something for me to chew on a little more.