Free Excel templates

A free HVAC flat rate pricing calculator in Excel

A residential HVAC contractor's selling rate, built from the burdened labor cost, technician efficiency, overhead and a target net profit, then turned into a flat-rate price book for eight repairs and the average ticket against time and material.

A cost per billable hour of $78.55 plus $52.50 of overhead, at a 20% target profit, gives a selling rate of $164 an hour. A run capacitor becomes a $220 flat price, and the average repair ticket rises from $376.22 on time and material to $432.20.

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.

HVAC_Flat_Rate_Pricing_Calculator.xlsx (15 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 HVAC Contractor 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

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

Price Book
Checks

What the worked case returns

MeasureValue
Cost per billable hour$78.55
Overhead per billable hour$52.50
Target net profit, share of price20%
Selling hourly rate$164
Parts multiplier1.75x
Flat price, replace run capacitor$220
Flat price, replace blower motor$815
Average ticket, time and material$376.22
Average ticket, flat rate$432.20
Flat-rate average after member discount$410.81

The selling rate is built from the bottom up: the burdened cost of a paid hour divided by efficiency, plus the overhead each billable hour must carry, grossed up for the target profit. Each flat price is book hours plus diagnosis time at that rate, plus parts at the multiplier, rounded up.

How to use it on your own case

  1. Enter the service composite labor cost, efficiency, overhead, service share and billable hours on Selling Rate.
  2. Enter the target net profit as a share of the price.
  3. Enter book hours, parts cost and share of repairs for each task on Price Book.
  4. Read the flat prices and the average ticket against time and material.

Questions people ask about it

How do you calculate an HVAC hourly rate?

Divide the burdened cost of a technician's paid hour by efficiency to get the cost per billable hour, add the overhead each billable hour must carry, and gross the total up for the target net profit.

What is flat rate pricing in HVAC?

A fixed price per task, quoted before the work, built from standard book hours and parts at a multiplier, instead of billing actual time and material.

Why does efficiency matter so much?

Drive time, shop time and callbacks are paid but not billed. A technician who bills 58% of paid hours costs almost twice the hourly wage per billable hour.

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 HVAC Contractor 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 HVAC Contractor Business Owner. See the book.