Free Excel templates

A free estate sale commission and minimum fee calculator in Excel

An estate sale company's year of on-site sales: tagged value at opening against gross sales, the sell-through rate, a commission on gross sales with a minimum fee per sale, the gross sales below which the minimum applies, and what the minimum adds over a year.

$1,262,110 of gross sales on $1,972,047 of tagged value is a 64% sell-through. At a 35% commission with a $3,000 minimum, the minimum applies below $8,571.43 of gross sales: on 6 of 58 sales, adding $705 over the year.

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.

Estate_Sale_Commission_and_Minimum_Fee_Calculator.xlsx (17 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 Estate Sale 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.

Sell-through
Minimum fee
Checks

What the worked case returns

MeasureValue
Tagged value at opening, FY2025$1,972,047
Gross sales on site, FY2025$1,262,110
Sell-through64.0%
Tagged value left unsold$709,937
Commission on gross sales35%
Minimum fee per sale$3,000
Gross sales below which the minimum applies$8,571.43
Sales where the minimum applies6
Revenue added by the minimum$705

The minimum applies when the commission at the percentage would fall below it: below the minimum divided by the commission rate. It protects the company on small sales but adds little over a year if most sales are larger.

How to use it on your own case

  1. Enter the commission rate and the minimum fee per sale on Inputs.
  2. Enter tagged value at opening and gross sales for the year.
  3. Enter the gross sales of each on-site sale.
  4. Read sell-through, the minimum threshold and the revenue the minimum adds.

Questions people ask about it

What commission do estate sale companies charge?

Commissions on gross sales commonly range from about 30% to 50% depending on the market and services, often with a minimum fee; the 35% and $3,000 here are the case company's own terms.

What is sell-through in an estate sale?

Gross sales divided by the tagged value of the items at opening: the share of priced goods actually sold.

When does a minimum fee apply?

When the commission at the percentage would be lower than the minimum, which happens below gross sales equal to the minimum divided by the commission rate.

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 Estate Sale 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 Estate Sale Business Owner. See the book.