Hello @Evan R. ,
Thanks a lot for your analysis...
The sweet spot you mention is exactly what most people tell me down here. Playa Del Carmen has A LOT of 2 and 3 bedroom condos since thats all the con developers were building during the boom days so studios that accommodate 2 people comfortably and 4 if necessary is what I think is the way to go.
Regarding the vacancy rate - My understanding is that you can choose to use the calendar on AirBnB to show where you are booked or not and a lot of users choose not to because they are listed on all the other sites like HomeAway, FlipKey etc.
But where do you get the 79% ?
When I play around in my Excel sheets I can still make decent money if I keep my vacancy rate at 50% or above. This is calculated at a weekly price of the studios at $500 USD per week year round. That is some of the lowest prices here in Playa for studios and since it´s year round I do not calculate the high seasons where I can charge almost double.
So in reality my vacancy rate could be lower but the high season rates would adjust for that.
I put of 40% of my rental income to expenses like staff, maintenance, taxes etc. Wages are low here and I would go for one cleaning lady, one manager and a half time fix-it guy.
I dont know if that is too low - I read that it should be 50% ?
So if I can keep those numbers then it should be a fairly profitable business.
But again I have never run a building full of studios for vacation rental so I could and most likely are wrong :D