This web page contains a live and functional spreadsheet created with
SpreadsheetConverter
. Please enable JavaScript in your web browser for the live calculations to work properly.
Airbnb Calculator: Cap Rate
Calculate the cap rate, an unlevered rate of return, for an Airbnb investment property.
Purchase price
$
Purchase price:
Enter the total cost to acquire the property plus applicable closing costs (e.g., real estate broker, mortgage broker and legal fees) and set-up costs (e.g., furniture).
Cap Rate
Daily rate
$
Daily rate:
For each season, enter the average rate charged to the guest per night booked.
Monthly operating costs
$
Monthly operating costs:
Enter the monthly costs related to operating a property, excluding mortgage costs.
Monthly operating costs could include: utilities, cable, internet, property taxes, insurance, maintenance, cleaning, security and HOA fees.
Occupancy rate - very busy
Occupancy rate - busy
Occupancy rate - above average
Occupancy rate - average
Occupancy rate - below average
Occupancy rate - slow
Occupancy rate - very slow
Occupancy rate - custom
Occupancy rate:
Percent of total nights with a guest in occupancy and paying the daily rate. Default occupancy rate assumptions are based on U.S. hospitality data.
Example: if you expect to have a guest in occupancy 3 weeks out of 4 weeks in a month, then the occupancy rate for that month is 75% (3 / 4 weeks).
Enter occupancy rate
Service fee - standard
Service fee - host-only
Service fee - custom
Service fee:
Select the service fee that Airbnb collects for listing on their platform. The fee is applied as a percentage of total booking revenue.
Enter service fee