Parking Garage Acquisition Model

Real Estate Financial Model (Free Excel Download)

Evaluate a parking garage investment with spaces, utilization, hourly and monthly pricing, event demand, operating costs, capital needs, financing, and exit value.

Loading...

Used by professionals from

KPMG logoWharton logoColumbia logoESSEC logoPwC logoHEC logo

About this model

This model follows a parking garage from purchase through operations and sale. It separates monthly contract parking, transient visitors, and ancillary income so you can see what drives revenue and how costs flow through to property income.

Use it to test occupancy, pricing, financing, and exit assumptions before committing capital. It is designed for real estate investors, operators, and lenders reviewing an acquisition or refinance.

What every model includes

Live formulas, no hardcoded values

Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.

All assumptions in one tab

Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.

Statements always balancing

For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.

Distinct schedules for clarity

Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.

No hidden macros or external links

There are no unexplained external workbook links or macros to undermine auditability or portability.

Changes flow through the model

Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.

What's inside the Parking Garage Acquisition Model

  • Facility inputs: total spaces, monthly space share, monthly oversell
  • Revenue drivers: monthly rate, transient turns, operating days, transient ticket, ancillary %, revenue growth
  • Operating costs: staffing, management fee %, property tax, insurance, utilities, repairs per space, card fees %, G&A, cost inflation, capex reserve
  • Deal inputs: going-in cap rate, acquisition costs %, loan-to-value, mortgage rate, amortisation term
  • Exit inputs: exit cap rate, selling costs %
  • Revenue sheet: monthly contract, transient, ancillary, total revenue, revenue per space
  • Operating_Costs sheet: full cost stack to total opex
  • NOI sheet: revenue, opex, NOI, NOI margin, NOI per space, identity check

How the Parking Garage Model Calculates Acquisition Returns

This parking garage model projects a ten-year hold for a single urban parking structure, from purchase through operations and sale. It builds revenue from monthly contracts, transient parking, and ancillary income, then flows through operating costs to net operating income.

The model sizes debt and equity, calculates levered cash flows, and solves for equity IRR and multiple to evaluate acquisition feasibility.

Revenue Drivers and Operating Assumptions

Revenue begins with the physical facility: total spaces, the share allocated to monthly contracts, and an oversell factor reflecting that not all contract holders park simultaneously. Monthly accounts are spaces times monthly share times oversell.

  • Remaining spaces serve transient parkers, with daily transactions derived from transient spaces and turns per space per day. This volume-driver block feeds three revenue streams: monthly contract revenue (accounts times monthly rate times twelve), transient revenue (daily transactions times operating days times ticket price), and ancillary income (a percentage of parking revenue from sources like EV charging or advertising).
  • Each stream escalates annually at the revenue growth rate.

Operating Costs and Net Operating Income

The operating cost stack includes staffing, management fee, property tax, insurance, utilities, repairs and maintenance, card fees, and general and administrative expenses.

  • Fixed-dollar lines escalate at the cost inflation rate, while management fee (a percentage of gross revenue) and card fees (a percentage of transient revenue) float with revenue.
  • Total operating costs are subtracted from total revenue to produce net operating income (NOI).
  • The model also reports NOI margin, NOI per space, and includes an identity check ensuring NOI equals revenue minus operating costs.

Acquisition, Financing, and Debt Service

The purchase price is calculated as Year-1 NOI divided by the going-in cap rate. Acquisition costs are added to determine total uses, which are funded by a senior loan at a specified loan-to-value and sponsor equity for the remainder.

  • The mortgage schedule uses a level annual debt service based on the mortgage rate and amortisation term. Interest accrues on the opening balance, principal is the difference between debt service and interest, and the closing balance declines over time.
  • The debt service coverage ratio (DSCR) is NOI divided by debt service, with the model checking that DSCR stays above a minimum threshold. The capital expenditure reserve is applied in the levered cash flow, not in NOI, to avoid double-counting.
The purchase price = Year-1 NOI ÷ the going-in cap rate

Exit, Levered Returns, and Dashboard Outputs

Exit sale price is Year-10 NOI divided by the exit cap rate, with selling costs and loan payoff subtracted to arrive at net sale proceeds. Levered equity cash flows include a Year-0 equity outflow and annual cash flows from Year 1 to Year 10 equal to NOI less debt service less capital expenditure reserve.

  • The Year-10 net sale proceeds are added as a final inflow. These cash flows are used to calculate equity IRR and equity multiple, and a Year-1 cash yield is also reported.
  • A dashboard summarises purchase price, Year-1 and stabilised NOI, DSCR, equity invested, equity IRR, equity multiple, exit sale price, and Year-10 revenue mix, with traffic-light indicators for DSCR and IRR.
income_statement.xlsx
Income statement, brown brand palette
income_statement.xlsx
Income statement, green brand palette
income_statement.xlsx
Income statement, red brand palette

Formatted to IB standards

Named theme colors repaint the whole workbook in one click, on top of an investment-banking structure with clear input, output, and cross-sheet reference styling - brand-ready, institutional-grade, and fully auditable.

Alex Tapio, ex-Deloitte financial modelling expert

Created by ex-finance professionals

Hey, I’m Alex and I created Finamodel.

Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.

Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.

I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.

Having a template library on hand cuts a first build from hours to minutes.

Need help finding your model? You’ll find me in the Finamodel app!

Frequently asked

What is a parking-garage model?+

A parking-garage model captures the ten-year acquisition-and-hold economics of a single fee-simple urban parking structure. It splits a space count into monthly contract and transient demand, builds gross parking plus ancillary revenue, runs the operating-cost stack to NOI, sizes the purchase off a going-in cap rate, amortizes a senior mortgage, and solves the levered equity IRR and equity multiple on a cap-rate exit. It is how a real-estate acquisitions analyst, parking-operator CFO, or infrastructure fund underwrites a parking deck.

Why split monthly from transient?+

Monthly contract parkers and transient (hourly/daily) parkers have completely different economics. Monthly accounts are a stable, oversold base (around 1.05-1.25 accounts per allocated space because not everyone parks at once) at a fixed monthly rate; transient revenue is turns × ticket × operating days and carries most of the upside and most of the volatility. A blended-rate model hides the demand mix that drives NOI.

How is the purchase price set?+

Purchase price equals Year-1 (in-place, stabilised) NOI divided by the going-in cap rate, plus acquisition costs. The model defaults to a 6.5% going-in cap, producing about $74,600 per space on the base assumptions - within the typical $40,000-100,000 per space range for urban structured parking. The exit takes Year-10 NOI at a 6.75% exit cap, 25 bps of conservative cap-rate expansion.

How does the capex reserve interact with NOI?+

NOI is a before-reserve figure (revenue less operating costs only), consistent with how cap-rate valuation works. The per-space capex reserve is deducted in the levered equity cashflow on the Returns sheet, not in NOI - double-deducting it would understate both the going-in cap-rate value and the DSCR. The reserve defaults to $150 per space per year.

Can I extend it to a multi-asset parking portfolio?+

Not directly. This template is a single-asset acquisition model. For a multi-deck portfolio, build one copy per asset and roll the NOI and equity cashflows up, or layer a fund template on top. For a ground-leased rather than fee-simple deck, add a ground-rent line to the Operating_Costs sheet, which will compress the NOI margin toward the operator-run 40-50% range.

What is the difference between monthly and transient parking?+

Monthly parking is contracted recurring revenue from account holders; transient parking is walk-up demand priced per stay (transactions per day times an average ticket). The model builds them separately because their risk profiles differ.

How is the acquisition priced?+

Purchase price equals Year-1 NOI divided by a going-in cap rate, plus acquisition costs, split into a senior loan at a loan-to-value and sponsor equity. The exit is the stabilised NOI capitalised at an exit cap rate, net of selling costs and loan payoff.

How is DSCR calculated?+

Net operating income divided by annual debt service on the amortising senior mortgage. DSCR is tracked each year with a traffic-light status so a covenant breach is obvious.

What are the headline value drivers?+

Transient demand intensity (turns times ticket), the NOI margin, and the spread between the going-in and exit cap rates. Together they drive the going-in yield, DSCR, and equity IRR.

Who uses a parking garage acquisition model?+

Real estate acquisitions analysts, parking-operator CFOs, and infrastructure fund associates underwriting a deck owned or operated by names like SP Plus, ABM, Premier Parking, LAZ, and Interpark.

Have more financial modelling questions? Contact us

Go further

Build the financial model you need with Fina

Browse templates, examples, and downloadable Excel models for the analysis you are trying to build. If you can't find your model, ask Fina to build a model for your specific needs.

Start for free
Excel financial model spreadsheet preview showing Customer Rollforward
Fina interactive chat interface preview