Inspiration

Our client, a fictional fund called DDD, has $10M for short-term rentals in British Columbia and wants to know where to put it. The obvious answer is "buy condos in Vancouver and list them on Airbnb". We wanted to find out whether that answer survives the actual rules and the actual numbers. It does not.

What it does

Our analysis recommends a specific portfolio and says what it will earn in 2027:

  • Tranche 1, now: 6 Whistler one-bedroom condos ($5.6M), rented nightly
  • Tranche 2, once the City confirms a licence: 5 Downtown Vancouver condos ($4.1M), rented nightly in summer and monthly in winter
  • Expected 2027 net yield: 2.2%, with a range of 1.3% to 3.6%
  • If Vancouver refuses licences: 2.1%

A 5-year government bond pays 3.46%, so the base case does not beat it. We say that on our first slide.

How we built it

We started from the mandated dataset: one Inside Airbnb snapshot of 6,509 Vancouver listings. We cleaned it down to 3,196 active entire homes, estimated each listing's booked nights from its reviews, and built a cost model for a single unit (platform fee, management, cleaning, strata, property tax, vacancy taxes). We then screened nine BC markets on their local by-laws, compared five portfolios under the same budget, and stress-tested the winner.

Everything is a Python pipeline that rebuilds from raw data with one command. The slide figures are generated from the pipeline's output, so the deck matches the analysis.

What we learned

  1. Vacancy taxes sink nightly rentals in Vancouver. A Downtown one-bedroom pays about $24k a year in vacancy taxes against $13k of income. Renting it monthly for six months removes both taxes, and the same unit goes from -1.8% to 2.4%.
  2. A fair comparison changed our answer. 39% of active listings have under a year of history, so the median understates a full year. Once every market was measured the same way, Kelowna fell from 2.4-2.7% to 0.7-1.0% and left our plan.
  3. Local by-laws matter more than the provincial rule. The case waives one provincial rule, but Burnaby, Richmond, Surrey and Victoria each close the door with their own. Whistler is zoned for nightly rental and has no vacancy tax.
  4. The first year is protected. Both vacancy taxes exempt a property in the calendar year it is bought, so closing in January 2027 means neither tax can apply that year.

Challenges we ran into

  • Our first draft was wrong. It showed 3.3%. An audit found the platform fee was 15.5%, not 3%, and that two markets had been measured on different bases. Rebuilding gave 2.2%.
  • The data has no bookings. Nights are estimated from reviews, which is the largest uncertainty and the reason we report a range.
  • Whistler is not in the dataset. We estimated it from a market-wide ratio and tested what happens if that ratio is 20% too high (1.7%).
  • One legal question has no published answer: whether a company can hold a Vancouver licence. We built the plan to hold up either way.

What's next

Ask the City of Vancouver in writing whether a corporate owner can be licensed, and price each Whistler unit on its own booking history before buying.

Data: Inside Airbnb, Vancouver, 15 June 2026, CC BY 4.0. AI tools were used for code and drafting, and their output was checked by the team.

Share this project:

Updates

Submission history