Free Excel templates

A free parking lot revenue, NOI and break-even calculator in Excel

Spaces, permits, tickets, event nights, parking tax, card and app fees, attendants, operating lines, ground rent and the operating mode. Net parking revenue, NOI, revenue per space per day, occupancy and the break-even.

A lot of 120 spaces with 70 monthly permits at $140, 110 transient tickets a day at $7.50 and 5 event nights of 90 cars at $18 makes $39,809 of net parking revenue a month once the parking tax is out, and keeps an NOI of $26,845 when the owner runs it. Its revenue per space per day is $10.91 against a break-even of $3.26. The calculator lays it out, ready for your own figures.

Get the calculator

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

Parking_Lot_Calculator.xlsx (10 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 calculator

This calculator uses the same cells as Workbook 3 of The Parking Lot Owner, which follows three parking lots through two fiscal years: permits and tickets on one base, the parking tax out of revenue, a ground rent with a percentage rent, attendants, accessible spaces, a third lot and its loan, and what each lot is worth.

Paperback PDF edition, $19.99

What is in the file

Three tabs. Inputs are blue; everything else is a formula; the Checks tab adds up the controls that fail.

1. Inputs
Spaces, days and hours open; monthly permits and their price; transient tickets a day, the average ticket and the hours parked; event nights, cars and the event rate; the parking tax rate inside posted prices; the card and app share, the processing fee, app transactions and their fee; pay stations and license plate recognition; attendant hours, pay and payroll taxes; maintenance, lighting and power, insurance, property tax and the reserve; a ground rent with its percentage rent; the operating mode and its fees or rents; the presence of monthly parkers; a cap rate and a loan payment.
2. Calc
Gross and net parking revenue; variable and fixed payment fees; attendants; management or the operator's fees; the ground rent; NOI of an operated lot and NOI under a lease; revenue per space per day and occupancy; the fixed costs of the month, the break-even per space per day and in occupancy, the debt-service break-even and an indicative value.
3. Checks
Rates between 0 and 1, the operating mode allowed, NOI rebuilt from its lines, the break-even reinjected, thresholds and occupancy within bounds, and inputs not negative. Checks!B2 adds up the failures.

What the worked example returns

MeasureExample
Gross parking revenue a month$42,994
Net parking revenue a month$39,809
NOI a month$26,845
Revenue per space per day$10.91
Occupancy25.2 percent
Break-even, revenue per space per day$3.26
Break-even in occupancy7.5 percent
Indicative value at 8 percent$4,026,809

The example is fictional and separate from the book's case: 120 spaces, 70 monthly permits at $140, 110 transient tickets a day at $7.50, 5 event nights of 90 cars at $18, a parking tax of 8 percent inside posted prices, 90 percent paid by card or app, and the owner operating.

How to use it on your own lot

  1. Enter posted prices as drivers pay them, parking tax included, and the tax rate of your city: the calculator takes the tax out before anything else.
  2. Enter your own management cost in mode 1, so that NOI can be compared with an operator's offer on the same base.
  3. On leased land, enter the base ground rent and any percentage rent with its threshold; on owned land, the property tax.
  4. Read the Checks tab before any figure: a count above zero means a cell to fix.

Education only, not legal, tax or financial advice: your own lot, leases and books govern, and your advisers decide.

Questions people ask

What does the parking lot calculator do?

From the spaces, monthly permits and their price, transient tickets and the average ticket, event nights, the parking tax inside the posted price, the card and app share and their fees, pay stations, attendants, maintenance, lighting and power, insurance, property tax, the reserve, a ground rent and the operating mode, it returns gross and net parking revenue, payment fees, NOI, revenue per space per day, occupancy, the break-even and an indicative value.

Which break-even does it compute?

The book's one definition: the revenue per space per day at which NOI is zero, the fixed costs of the month divided by one less the variable payment fee ratio, then by spaces x days; and the same point in occupancy. A debt-service break-even adds the loan payment.

Can it compare a management agreement and a lease?

Yes. The operating mode cell switches between you operate, a management agreement (fixed fee and incentive on net parking revenue above a threshold) and a lease to an operator (base rent and percentage rent), on the same net parking revenue, with monthly thresholds; Workbook 5 of the book reads yearly ones.

Can I rely on it for a business plan?

Use it for a first pass and to learn the mechanics. Your prices come from your own lot, your costs from your own books, your parking tax from your own city, and the conclusions belong to you and your advisers.

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 eight free workbooks of The Parking Lot Owner go further: one lot's month, monthly permits and oversell, an attendants' workweek, three operating modes on one base, a third lot and its loan, what each lot is worth, and accessible spaces counted from Table 208.2.

See the book and its free files →

Related reading