# Parking Garage Acquisition Model

Understand how parking demand, pricing, costs, and financing affect an investment in a parking garage.

- Canonical: https://finamodel.com/templates/parking-garage
- Excel download: https://finamodel.com/templates/parking-garage.xlsx
- Category: Real Estate
- Model type: Underwriting
- Difficulty: Intermediate
- Audiences: Developers & sponsors, Investors & analysts, RE acquisitions analysts, Parking operator CFOs, Infrastructure funds, Real estate lenders, Real estate acquirers, Parking operators, Infrastructure fund associates, Lenders
- Tags: parking, real estate, noi, cap rate, irr, NOI, mortgage, levered IRR

## Overview

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's included

- 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
- Debt sheet: sources and uses, senior loan, sponsor equity, amortising mortgage schedule, DSCR
- Returns sheet: Year-0 equity, levered annual cashflow, Year-10 exit, equity IRR, equity multiple, cash yield
- Dashboard with purchase price, NOI, DSCR, equity IRR, equity multiple, exit price, revenue mix, traffic-light status
- Debt sheet: sources & uses, senior loan, sponsor equity, amortising mortgage schedule, DSCR
- Volume-driver block: monthly accounts, transient spaces, and transient transactions per day
- Revenue by stream: monthly contract, transient, and ancillary income
- Operating cost stack (staffing, management fee, property tax, insurance, utilities, repairs, card fees, G&A) to NOI
- NOI with NOI margin and NOI per space
- Acquisition sizing off a going-in cap rate, a senior loan at a loan-to-value, and an amortising mortgage with DSCR
- Levered return: Year-0 equity, annual levered cash flow, a cap-rate exit, and equity IRR and equity multiple

## 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.

Calculation summary:

```text
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.

## Built on parking unit economics

When the question is "what NOI and levered return does this deck generate at a given space count, demand split, and rate?", a monthly-plus-transient revenue build to NOI, sized off a cap rate and levered with an amortizing mortgage, is the answer. This template gives real-estate acquisitions analysts, parking-operator CFOs, and infrastructure funds a one-page bridge from per-space demand to equity IRR.

## Designed for one-edit responsiveness

Every input - total spaces, monthly share, oversell, monthly rate, transient turns, ticket, ancillary %, the full cost stack, going-in and exit cap rates, LTV, mortgage rate, and amortisation term - is a named-range cell. Edit one and the revenue, NOI, debt schedule, returns, and dashboard all recompute. No formula rewrites needed to test a demand shock or a cap-rate expansion.

## Honest about the debt and the exit

A senior mortgage is sized at a loan-to-value and amortized on a 25-year schedule: level debt service via PMT, interest on the opening balance, principal as the plug, and a declining closing balance that becomes the exit loan payoff. The exit takes Year-10 NOI at a cap rate set 25 bps wider than the going-in, so the user can isolate NOI growth from cap-rate movement in the levered return.

## Demand to revenue

A volume-driver block (monthly accounts, transient spaces, transactions per day) feeds three revenue streams - monthly contract, transient, and ancillary - capturing both the contracted base and the walk-up upside.

## Operating stack to NOI

Staffing, management fee, property tax, insurance, utilities, repairs, card fees, and G&A build to total opex and a net operating income with NOI margin and NOI per space.

## Acquisition, debt, and exit

Sizing off a going-in cap rate, an amortising senior mortgage with DSCR, and a cap-rate exit on stabilised NOI solve to the levered equity IRR and equity multiple.

## Workbook structure

### Cover

Workbook overview, sheet legend, and tab-colour key for navigation.

- Title and scope framing
- Sheet-by-sheet purpose summary
- Tab-colour legend

### Assumptions

Every driver in one sheet: facility, revenue, costs, deal, exit, and status thresholds.

- Total spaces, monthly share, oversell
- Monthly rate, transient turns, operating days, ticket
- Ancillary %, revenue growth
- Cost stack: staffing, fees, tax, insurance, utilities, repairs, G&A, inflation, capex reserve
- Going-in cap, acquisition costs, LTV, mortgage rate, amortisation term
- Exit cap rate, selling costs
- DSCR and equity-IRR status thresholds

### Revenue

Volume drivers and revenue by stream.

- Monthly accounts = spaces × monthly share × oversell
- Transient spaces = spaces × (1 − monthly share)
- Transient transactions/day = transient spaces × turns
- Monthly contract = accounts × rate × 12 × (1 + growth)^t
- Transient = transactions/day × operating days × ticket × (1 + growth)^t
- Ancillary = (monthly + transient) × ancillary %
- Total revenue and revenue per space

### Operating_Costs

The cost stack to total opex.

- Staffing, property tax, insurance, utilities, G&A - inflated
- Repairs = spaces × repairs per space - inflated
- Management fee = gross revenue × fee %
- Card fees = transient revenue × fee %
- Total opex = sum of all lines

### NOI

Net operating income build.

- Total revenue from Revenue sheet
- Operating costs from Operating_Costs sheet
- NOI = revenue − opex
- NOI margin and NOI per space
- Identity check resolves to zero

### Debt

Acquisition sizing and amortising mortgage.

- Purchase price = Year-1 NOI / going-in cap rate
- Acquisition costs and total uses
- Senior loan = price × LTV; sponsor equity = uses − loan
- Sources-less-uses check resolves to zero
- Opening balance, level debt service via PMT
- Interest on opening balance, principal as plug, declining closing balance
- DSCR = NOI / debt service

### Returns

Levered equity cashflow and returns metrics.

- Year-0 equity outflow = sponsor equity
- Annual NOI − debt service − capex reserve (Years 1-10)
- Year-10 net sale proceeds inflow
- Exit sale price = Year-10 NOI / exit cap rate
- Net sale = sale price − selling costs − loan payoff
- Equity IRR, equity multiple, Year-1 cash yield

### Dashboard

Headline metrics with traffic-light status and revenue mix.

- Purchase price, Y1 NOI, stabilised (Y10) NOI and margin
- Y1 DSCR with On-track / Watch / Tight flag
- Equity invested, equity IRR with On-track / Watch / Below-hurdle flag
- Equity multiple and exit sale price
- Y10 revenue mix: monthly contract / transient / ancillary

## Features

- **Built on parking unit economics:** The model is structured around how a parking asset actually earns: a monthly contract base (oversold because not all contract holders park at once) plus a transient layer (turns × ticket × operating days) plus ancillary income. Flex the monthly share, the transient turns, or the ticket and watch revenue per space, NOI, and the going-in yield move together.
- **Cap-rate in, cap-rate out:** The purchase is sized off a going-in cap rate on Year-1 NOI and the exit is taken on Year-10 NOI at an exit cap rate set deliberately 25 bps wider, so the user can isolate how much of the levered return is NOI growth versus cap-rate movement. Both cap rates and the selling costs are named-range inputs.
- **Honest about the debt:** A senior mortgage is sized at a loan-to-value and amortised on a 25-year schedule: level debt service via PMT, interest on the opening balance, principal as the plug, and a declining closing balance that becomes the exit loan payoff. DSCR is shown every year, and the levered equity cashflow nets debt service and a per-space capex reserve out of NOI before the exit.
- **Monthly versus transient demand:** Revenue splits into contracted monthly parkers and walk-up transient demand (transactions per day times ticket), so the stable base and the volatile upside are modeled separately.
- **NOI to levered equity return:** An explicit operating-cost stack drives NOI margin and NOI per space; an amortising senior mortgage and a cap-rate exit convert NOI into a levered equity IRR and multiple.
- **Cap-rate spread and DSCR:** Acquisition is sized off a going-in cap rate and exited on a stabilised NOI at an exit cap rate; DSCR is tracked against the mortgage so the financing risk is visible.

## Use cases

- **Acquisitions underwriting:** Drop in a target deck's space count, monthly/transient split, and in-place rates, set a market going-in cap rate, and read the implied price per space, the equity check at a target LTV, the DSCR, and the levered IRR. The going-in vs exit cap spread makes the valuation risk explicit.
- **Operator hold-period plan:** Take a real facility, set realistic rate escalation and cost inflation, and read the stabilised NOI, NOI margin, and DSCR trajectory over a 10-year hold. Flex the management fee or staffing to see the NOI-margin and DSCR impact.
- **Demand stress test:** Cut transient turns or the monthly share to model a work-from-home demand shock and read the NOI, DSCR, and equity-IRR impact. The traffic-light flags on DSCR and equity IRR make the breach visible without rebuilding the dashboard.
- **Acquisition underwriting:** Size the purchase off Year-1 NOI and a going-in cap rate, layer senior debt, and read the levered equity IRR and multiple.
- **Demand and pricing sensitivity:** Flex transient demand intensity (turns times ticket) and monthly penetration and watch the going-in yield, DSCR, and IRR move together.
- **Financing and exit structuring:** Test loan-to-value, amortisation, and the spread between going-in and exit cap rates against DSCR and the equity return.

## Frequently asked questions

### 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.

## Related templates

- [Real Estate Development Pro Forma Model](https://finamodel.com/templates/real-estate-model)
- [Self-Storage Operations Dashboard](https://finamodel.com/templates/self-storage-ops-model)
- [Office Building Investment Model](https://finamodel.com/templates/office-building-model)
- [Self-Storage Facility Model](https://finamodel.com/templates/self-storage-model)
- [Mixed-Use Real Estate Development](https://finamodel.com/templates/mixed-use-model)