Free Excel templates

A free golf course revenue per round and break-even calculator in Excel

Type your rounds by type, green fees, the share that rides and the cart fee, food and pro shop spend and margins, passes and their price, course maintenance a hole, clubhouse staff hours and cost, fixed costs, card fees, a maintenance reserve, debt service and player slots: the sheet returns revenue per round, the contribution of a paid round, the pass holders' block, EBITDA after the reserve, the break-even in paid rounds, the coverage of your loans, utilization and two sensitivities, with three checks.

The worked example runs on simplified inputs the book draws from its fictional 18-hole public course's FY2026: 33,300 rounds (16,400 full rate, 4,900 twilight, 8,500 by pass holders, 3,500 in groups), green fees of $51, $32 and $46, 205 passes at $1,550, course maintenance of $31,968 a hole and $577,030 of fixed costs. The calculator shows revenue of $75.68 a round and a contribution of $67.94 a paid round. It shows EBITDA of $684,764 after a maintenance reserve: a break-even of 14,720.7 paid rounds and a coverage of 1.33 on $513,900 of debt service.

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 212 free models.

Golf_Course_Revenue_per_Round_and_Break_Even_Calculator.xlsx (13 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 Golf Course Owner, which explains the method behind it, chapter by chapter.

Get the PDF edition → See the book

Want every model at once?

The Financial Model Library: all 213 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.

Inputs
Rounds by type and the total; green fees by type; the share that rides and the cart fee; food and beverage and pro shop spend a round and their margins; passes and their price; course maintenance a hole and the holes; clubhouse and tee staff hours and their cost an hour with burden; fixed costs; card fees; the maintenance reserve a hole; debt service; player slots.
Results
Paid rounds, average green fee a paid round, contribution a paid round (rounded to the cent), the pass holders' block (rounded to the dollar), revenue by line, costs that do not move with rounds, EBITDA after the reserve, break-even paid rounds, debt service coverage, 2,000 more paid rounds, $3 more on every green fee and utilization.
Checks
Three tests that return TRUE or FALSE (rounds by type add up to the total entered, shares and margins between 0 and 100 percent, a positive contribution a paid round before a break-even is shown), and an All checks line.

What the worked case returns

MeasureValue
Revenue per round$75.68
Contribution a paid round$67.94
Pass holders' block$501,973
Costs that do not move with rounds$1,502,094
Calculator EBITDA, after the maintenance reserve$684,764
Break-even paid rounds14,720.7
Debt service coverage1.33
2,000 more paid rounds$135,880
$3 more on every green fee$72,168
Utilization (rounds / player slots)57.0%

Every pre-filled figure is the calculator's, on inputs simplified from the book's fictional case, a teaching assumption and not a market norm. The calculator uses one ride share and one food spend for every round, counts the season's passes as sold and takes a maintenance reserve: it gives $684,764 of EBITDA where the book's case, which follows every round type month by month, reports $719,592 for FY2026 (chapter 12 bridges the two line by line), and a buyer would pay on the case's transaction EBITDA, $535,160 (chapter 15).

How to use it on your own case

  1. Type your rounds by type and the total from the tee sheet report, and your green fees.
  2. Type the share that rides, the cart fee, food and pro shop spend and margins, and your passes and their price.
  3. Enter course maintenance a hole, clubhouse staff hours and cost, fixed costs, card fees, a reserve, your loan payments and your player slots.
  4. Read revenue per round, the contribution of a paid round, EBITDA, the break-even, the coverage, the two sensitivities and the checks.

Questions people ask about it

How many rounds does a golf course need to break even?

Count paid rounds, not all rounds: costs that do not move with rounds, less what pass holders bring, divided by the contribution of a paid round. On its pre-filled inputs this calculator gives 14,720.7 paid rounds; the book's case, on its own figures, gives 14,289 paid rounds before debt service.

What is a pass holder worth in this calculator?

Pass holders pay once, ahead of the season, so the calculator keeps them out of the paid-round count and adds their whole contribution as one block: on the pre-filled inputs, $501,973 (the calculator's figure, Results sheet).

Why is the calculator's EBITDA lower than the book's case?

The calculator takes a maintenance reserve of $2,500 a hole that the case's books do not, leaves out the storm, the insurer and a property tax refund, and simplifies carts, food and passes. Chapter 12 of the book bridges its $684,764 to the case's reported $719,592 line by line, and chapter 15 restates the case's own EBITDA to $535,160 before the course is valued.

Is this calculator 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 Golf Course 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 Golf Course Owner. See the book.