Free Excel templates

A free home builder house budget and margin model in Excel

A small production builder's house budget by plan, one house from contract to closing with its gross margin before and after interest, then three years of starts, specs, closings, overhead, pre-tax profit, house loans and cash.

One 2,300 square foot house sells for $466,510 and costs $373,100 before interest: a 20.0% gross margin, 18.3% after interest. Across fiscal 2025 the builder closes 67 houses at a 19.4% gross margin, and keeps 6.5% as pre-tax profit.

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.

Home_Builder_House_Budget_and_Margin_Model.xlsx (332 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 Home Builder 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

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

Case inputs
Month by month
Houses
Loan balances
Results
Checks

What the worked case returns

MeasureValue
One house: revenue$466,510
One house: cost before interest$373,100
One house: gross margin before interest20.0%
One house: gross margin after interest18.3%
FY2025 closings67
FY2025 revenue$31,058,601
FY2025 gross margin before interest19.4%
FY2025 overhead$2,280,000
FY2025 pre-tax profit$2,022,832
FY2025 pre-tax profit, share of revenue6.5%

Gross margin per house is only the start: interest on the house loan, sales commissions, closing costs, warranty and overhead come out before profit. In the slowdown year of the case, a 17% gross margin leaves almost no pre-tax profit.

How to use it on your own case

  1. Enter plans, square feet, list prices, lot prices, direct cost per square foot and fees on House budget.
  2. Enter options, incentives, selling costs and the house loan terms.
  3. Enter the starts, specs and sales pace on Case inputs.
  4. Read one house's margin, then three years of results, cash and loans.

Questions people ask about it

What is a good gross margin for a home builder?

It varies with market and size; small builders often target around 20% before interest on each house, but overhead, interest and selling costs decide what is left as profit.

Why show margin before and after interest?

Because construction loan interest depends on how long each house takes to build and sell. Slow sales cut the margin after interest even when the house budget is met.

What is a spec house?

A house started before a buyer signs. Specs speed sales in a strong market and tie up cash and loans in a slow one.

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 Home Builder 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 Home Builder Business Owner. See the book.