I've made plenty of mistakes so take my advice more of a learning opportunity rather than a "this is how you do it".
Appreciation:
My first investment was right after the 2008 crash. Not an ideal entry point. Prices had dropped something like $40k on a slightly more than $200k new home and we jumped in. Appreciation was great in general the prior few years... until we bought the house. Prices continued down and we lost a good portion of its value, eventually the market bottomed out, and then very slowly appreciated again for many years. So many people just walked away and gave the home to the bank. We kept ours. Then shortly before Covid hit, the appreciation went up significantly. There was a slight bump down, but its been going up more recently again. This was not a good entry point but I was inexperienced and have since learned. That's just what the market was like in this area at the time. I bet on appreciation and with my poor timing it wasn't the best. On the other hand, my last investment doubled in value in under 5 years.
There are many factors to investing in a property, but appreciation and profit (from rent) are two big components. Appreciation is a bet. And it can pay off very nicely. Appreciation here toward the west coast is a bigger factor than in the Mid-West typically. It is very typical out here to have near zero initial profit from investing in a MLS listed property as a rental. Anything juicy is scooped up by insiders and door knockers and those never hit the market. My neighbor has a real-estate friend. The friend finds the deals and the neighbor manages the rehab and they flip the properties. These never see the MLS until the flip is done. Even in our current high priced market this is happening.
Rent profit out of the gate has historically been more of a factor in the mid-west. Its not my area so I don't know why, but people will pay $1400 a month to rent a $100k property. It doesn't make sense to me, but it seems to be the case. I can't really comment on this except in these areas, the numbers you are looking at usually make more sense.
People need a place to live and if they have a job, their income will dictate the amount they are willing to pay and that will partially dictate values of property. Property values and rent prices can become greatly disconnected here. In my area out in the desert with minimal greenery and dubious water sources, the area has become a mini tech center. Households bringing in over $200k now are common. These are also generally buyers (too live in it) and not renters. 10 years ago, prior to most of the tech arriving, I'll speculate the average household income in the area was under $75k. Houses that were $300k back then are now sometimes in excess of $650k. There are million dollar houses around here. If you buy one of these at this price, is there potential for immediate rent profit? For the most part its no, but 5 years ago I was looking at MLS properties that I could squeeze maybe $100 to $200 a month out of and were selling for $225k (with a substantial down payment also) I thought that was pretty good. Once again, the bet on appreciation is always present here. As tech keeps building, prices continue to rise.
Rent:
Back to my 1st investment and the poor timing, rent was stagnant for a good 10 years at the exact same rate. No joke. The area was on the outskirts of town and was expanding rapidly and then with the 2008 crash. It literally froze for a good 10 years. It really took a long time to recover. We had a decent enough income and no kids so we could afford the $200 a month deficit. About 6 years ago I was able to raise rent and it has been rapidly going up since then. It even has continued to go up over the past year. With a refinance to a good rate a few years back and the climbing rent, this buy and hold property now is performing well.
My most recent investment from 5 years ago is also paying double the mortgage. Another buy and hold. Some of my properties I have bought as a primary residence and when I move on, I just hold them and convert them to rentals.
Long story short, not all buyers are assessing a property's value with your numbers. Most are not. Your numbers are valid for your goals, so I'm not telling you to change your formula. Just know you are competing with people who have different numbers and goals. Most home buyers just need a place to live and really aren't calculating in the numbers significantly. Mom and dad with 3 kids and a good paying job come to town having left their million plus dollar home in California probably won't hesitate slapping down 50k or more than you or I are willing to pay on a home if that's what they want to live in. As more and more come in, prices will naturally rise. High interest rates just make it even more difficult. Local renters may to some degree not be able to absorb higher rents ant if the market can't bear it, rents can become disconnected from property values.