And, you can't prove that Tenant #1 is the cause...it's an assumption and one that you don't want to rely on. 

Viking appliances adorn the gourmet kitchen which features marble surfaces, custom inset furniture grade kitchen cabinetry, pot filler, wine fridge, and built-in micro/drawer.

Professional Jenn Air appliances adorn the gourmet kitchen which features marble surfaces, custom kitchen cabinetry, pot filler, &wine fridge.

You can view/download the spreadsheet here:https://docs.google.com/spreadsheets/d/1eWquKpM8cd...Here are my Assumptions:Market; West Coast (say San Fran )Cap rate at purchase: 5% NOI: 200,000 Purchase price: $4 mill LTV: 65% Down: $1.4 mil Finance: 2.6 million Terms: 5% for 5 year term 25 year amort NOI Increase 3%/yearNOI end of year 5: 225,101.76Net cash flow years 1-5: 149,867.16Principal Reduction years 1-5: 296,915.00Debt Principal end of year 5: 2,303,085.00Cap rate at end of year 5: 8%'Renewal terms: 8% for 5 year term 25 year amort Exit strategy 1: sell in 5 years Exit Strategy 2: hold for 10 years with refi in 5 years Based on above assumptions here is what I see:Exit Strategy 1 End of Year 5 sell building for 2,813,772.03 Less O/S Debt of 2,303,085.00 Net Profit 510,687.03 Plus 5 Year Cash Flow of ` 149,867 *Principle Reduction (Included) 0 Total Net Proceeds 660,554.19 Less Down Payment 1,400,000.00 Net Loss:  (739,445.81) * Note-Principal reduction is already included in the reduced O/S debt amountExit Strategy 2 End of Year 10 sell building for 3,261,932.96 Less O/S Debt of 2,125,147.00 Net Profit 1,136,785.96 Plus 10 Year Cash Flow of 314,281.00 *Principle Reduction (Included) 0Total Net Proceeds 1,451,066.82 Less Down Payment 1,400,000.00 Net Gain 51,066.82 * Note-Principal reduction is already included in the reduced O/S debt amountGiven the above scenario, in my view, it does not seem to make any sense to buy now.

Some custom houses, yes but most of them are also using LVP.  

My brain is spinning thinking about splitting deposits, classifying properties, and creating custom reports, but if I can get it set up properly I can see it being a great option.

I've used the following assumptions, which I think are broadly reasonable, depending on your asset's location/deal profile:5.5% cap rate65% LTV IO financing @ 3.5%Net Operating Income of $203,500This gets you to necessary equity slug of ~$1.3-1.4MM after closing costs to get to $120k/annually of NCF after debt service. 

My assumption is that the pandemic fueled vacation rental boom, both in terms of users and owners is going through a bit of a rebalancing.

You are correct I have a responsibility to my employer but also to my customers.

If you prefer to have the property updated or customized you would spend extra money and see NO gain in profits because of the rental pool.