The new investment earns $24,000 a year, but the mortgage + the equity loan cost will be $22,332—and that’s before you account for taxes, insurance, maintenance, capital expenditures, vacancies, etc.

Even assuming you paid cash and had NO capital expenditures and did NO necessary renovations, the $240K purchase price would put you at a 4.5% cash-on-cash return!

While it can have an effect on yields and mortgage rates if it comes in higher or lower than expectations, it typically has a much smaller effect on yields and rates than the CPI report.Personal Consumption Expenditures (PCE)The Personal Consumption Expenditures (PCE) report is another measure of inflation.

I am planning in acquiring my first house hack within the next 3-5 months after I save enough for the downpayment and the capital expenditures. 

Do you have the financial stability to do it right now with enough reserves to account for potential capital expenditures?

Unfortunately, you also need to  account for expenditures other than your debt service…I.e. repairs, vacancy, etc. usually people assume these as a percentage into their calculation.

The new investment earns $24,000 a year, but the mortgage + the equity loan cost will be $22,332—and that’s before you account for taxes, insurance, maintenance, capital expenditures, vacancies, etc.

They will help you plan out the next year and capital expenditures and other tax advantages. 

That appreciation is great, it sounds like that investment is performing very well right now and will likely continue to do so.Some things I don't see listed in your example are vacancy and capex for the big expenditures.

While it can have an effect on yields and mortgage rates if it comes in higher or lower than expectations, it typically has a much smaller effect on yields and rates than the CPI report.Personal Consumption Expenditures (PCE)The Personal Consumption Expenditures (PCE) report is another measure of inflation.