Single family is restricted to single family, no income generation.

The property is worth exactly what it is with zero STR rental income.

This creates two loan payments ($100,000 of equity and $300,000 on the new mortgage).Key NumbersHome Equity Loan Interest Rate: 6%Mortgage Interest Rate: 7%Rental Income: $3,000 per monthExpenses (management, taxes, insurance, maintenance): $800 per monthIncome and ExpensesMonthly Rental Income: $3,000Monthly Expenses: $800Monthly Mortgage Payment: $2,000ExplanationThe investor earns $3,000 in rent each month.They pay $2,000 on the investment property mortgage and $800 on other expenses.This leaves $200 profit each month or $2,400 per year.However, you have to pay $6,000 interest on the equity borrowed.This leaves you with an annual loss of $3,600.While the rental property generates positive monthly income, the interest cost of borrowing the initial $100,000 results in an overall loss.

I'm looking more for an overarching portfolio spreadsheet to track asset performance over the lifetime of holding the asset.If you have the property manager paying the mortgages, taxes, insurances, doing all the accounting, etc why not just ask them to generate whatever report you want?

MTRs often have lower management demands compared to platforms like Airbnb while still generating higher returns than long-term rentals.

Wyoming has no state income tax.4.

My goal per property is to generate a minimum of $500 cashflow per month. 

It seems there’s a common misconception largely influenced by social media, online courses, and influencers who oversimplify the process that real estate is an easy, passive way to generate income with minimal effort.

Agents on teams will get leads, learn the business and leverage the team for their higher income and future business success. 

If you wanted to diversify you could use the income and purchase other properties, slowly add other properties.