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.
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.
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.
Three tabs. Inputs are blue; everything else is a formula; the Checks tab adds up the controls that fail.
| Measure | Example |
|---|---|
| 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 |
| Occupancy | 25.2 percent |
| Break-even, revenue per space per day | $3.26 |
| Break-even in occupancy | 7.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.
Education only, not legal, tax or financial advice: your own lot, leases and books govern, and your advisers decide.
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.
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.
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.
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.
Yes. You enter an email address, the download opens at once, and you can leave the reader list in one click.
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.