Hi @Jeffrey240,
I did setup my version of the Excel sheet myself – from scratch. And which is very specific to my situation (I.e. it is useless to someone else).
It does forecast on basis of things, such as:
- Duration
- Number of persons in a group
- Season
- Tax-impact
- Depreciation
- Unit-prices, determined from experience
Once the actuals do come in, they will replace the forecast.
And I can also adjust my parameters (because of inflation and adjusted legislation).
With all this in place, I can quite accurately forecast turnover and associated costs – for about a year or so.
Due to all the VBA programming in this sheet, it really needs a bit of time to calculate everything through.
I only do Short Term Rentals, as Long Term Rentals is a completely different ball-game.
Sorry, I can’t help you with that.
Just try to work out what the Pros and Cons are – of both scenarios are.
Learn as you go, which does unfortunately mean: You will stumble, so once and a while.
And sometimes, you just have to be lucky.
There are no of the shelf instructions. As each situation is specific.
And you really need to have local presence! Can’t do without it!
I do not have a paid subscription at Airdna (as I find it, a bit expensive).
But even without it, it will provide you with some good insight.
I understood, they are nowadays trying to incorporate VRBO data as well.
They are using web-scraping techniques to gather data. So their data is not perfect (but I think the level of quality of their data is at about 98% of the truth).
And it is much better, than what Airbnb provides hosts with (as they supply hardly any data at all).
Success!