Free Excel templates

A free vacation rental management fee calculator in Excel

A vacation rental management company compares its old plan, a commission on net rent, with a new plan, a lower commission plus a monthly fee per home, finds the net rent where the two meet, and measures the revenue given up on three home types.

Moving from a 25% commission to 20% plus $95 a month, the two plans meet at $22,800 of net rent a year. A two-bedroom condo now brings $8,219 instead of $8,849; a five-bedroom house $16,054 instead of $18,642.

Get the template

One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other 181 free models.

Vacation_Rental_Management_Fee_Calculator.xlsx (12 KB)

You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.

The book behind this model

This model goes with The Vacation Rental Management Business Owner, which explains the method behind it, chapter by chapter.

Get the book on Google Play →

Or the DRM-free PDF, $19.99 →

Want every model at once?

The Financial Model Library: all 182 models from this site in one download, organised by theme, plus two modelling books in DRM-free PDF (Financial Modeling from First Principles and Real Estate Financial Modeling).

Get the Library, $79 →

This free file stays free. Secure checkout by Stripe.

Not on Amazon: 24 paperbacks by Julian R. Sterling on insurance and retirement, printed on demand and shipped worldwide. Browse the bookshop →

What is in the file

3 sheets. Inputs can be changed; everything else is a formula, and the last sheet checks the figures against the book.

Meeting point
Home types
Checks

What the worked case returns

MeasureValue
Old plan commission25%
New plan commission20%
New plan monthly fee per home$95
Net rent where the plans meet$22,800
Two-bedroom condo, old plan$8,849
Two-bedroom condo, new plan$8,219
Three-bedroom cottage, old plan$12,642
Three-bedroom cottage, new plan$11,253
Five-bedroom house, old plan$18,642
Five-bedroom house, new plan$16,054

The meeting point is the year of monthly fees divided by the commission given up. Above it, the new plan earns the manager less; below it, more. The onboarding fee is set aside because it does not repeat.

How to use it on your own case

  1. Enter the old plan's commission on Inputs.
  2. Enter the new plan's commission, monthly fee and onboarding fee.
  3. Enter the net rent of the average home of each type.
  4. Read the meeting point and the company revenue under each plan.

Questions people ask about it

What do vacation rental managers charge?

Most charge a commission on rental revenue, often between about 15% and 35% depending on the service level and market; some add or substitute flat monthly fees.

Is a lower commission plus a monthly fee better for owners?

For high-earning homes, usually yes; for homes with low rent, the monthly fee can make the total higher. The meeting point tells which.

What is net rent in a vacation rental management agreement?

Rent less channel costs such as booking platform fees, the base on which the commission is often charged; agreements define it differently, so read the definition.

Is this template really free?

Yes. You enter an email address, the download opens at once, and you can leave the reader list in one click.

Go further

The free workbooks of The Vacation Rental Management Business Owner go further: the full companion set, blank models and the worked cases of the book.

See the book and its free files →

Other free templates

This template goes with The Vacation Rental Management Business Owner. See the book.