@Sean Bramble, to estimate revenue when I underwrote my existing duplex, I went on Airbnb in my area and did a deep dive on listings to find comparable properties and what they were charging. You have to play around with the dates to get a sense of discounts for longer stays and also seasonally changing rates. I then looked at the reviews for the properties that had a ton of them. I was less interested in what the reviews said, but more concerned with WHEN they were posted. This helped to show what months of the year I could expect renters (in addition to the obvious ski season).
I also ran a report on AirDNA which allows you one analysis for free without signing up to get another perspective on occupancy. They estimated that I could expect occupancy 50% of the year..
Finally, I connected with a friend who has an Airbnb in the area about what occupancy she was seeing, and she told me that she was seeing closer to full occupancy (90%+).
Combining all of that together, I figured that I'd see 50% occupancy on average at the low end for a traditional Airbnb that had at least 1 BR, kitchen and living room, but with upside as high as 90%.
For this motel, we would do a combo of rooms and suites. We are estimating the suites that would have a full kitchen and living area as equivalent to a standard Airbnb at 50% average occupancy and the standard rooms at closer to 30% occupancy. I further supported these assumptions by figuring that at worst, the standard rooms would see 2x nights per week (Friday + Saturday) with once a month getting a 3-night stay. 2 nights/week x 4 weeks per month. = 8 nights + 1 = 9 nights / 30 days = 30% occupancy.
Based on my knowledge of the area, I got a little more granular on the above, digging into the seasonality of travel there (with Christmas Week through end of March being super-packed and longer stays, April being totally dead and the rest of the year being somewhere between). I also know that aesthetically, the comps are mostly in terrible shape with dated properties still doing a decent business. There are 3x modern comps in the area that are charging on average 2.5x the dated rooms and as high as 5x. Long story short, the above numbers checked out and actually seem to be conservative.