Sale-Leaseback Real Estate ModelFree Financial Model Download
Model sale-leaseback economics including valuation, lease terms, Section 1031 tax impact, and investor returns without buried assumptions. Covers both the seller liquidity case and the buyer underwriting in a single workbook.
Free download. No sign-up required.
About this model
Model sale-leaseback economics for property owners unlocking capital while retaining occupancy, and for buyers acquiring yield-backed assets. From the seller side: compute net proceeds after transaction costs, compare ongoing lease payments to prior mortgage + opex, and measure NPV of lease obligation vs continued ownership. From the buyer (lessor) side: project annual base rent with escalators, model NNN pass-throughs (property tax, insurance, maintenance paid by tenant), and calculate Yield on Cost, levered IRR, and equity multiple at a target exit cap rate after 10-15 years.
The model applies going-in cap rates (5.5%-8.0% typical) to determine Year 1 rent; escalates rent 1.5%-3.0% annually (fixed or CPI-linked); and handles purchase price allocation to land (non-depreciated) and building (30-40 year life). Debt schedule tracks senior mortgage (55%-70% LTV), calculates DSCR (1.2-1.4x minimum), and models refinance or balloon risk at maturity. Exit value uses forward NOI (next year's rent divided by exit cap rate) to account for lease maturity.
Essential for corporate treasurers, REITs, and institutional real estate investors evaluating sale-leaseback opportunities. Works with private credit lenders assessing credit strength and coverage ratios.
Recolor to your brand.
Formatted to IB standards.
Named theme colors repaint the whole workbook in one click, on top of an investment-banking structure with blue inputs, black formulas, and green cross-sheet links.
- Brand-ready
- Institutional grade
- Fully auditable
What's included
- Property valuation and cap rate comparison
- Lease terms, escalators, and renewal options
- Sale proceeds and reinvestment strategy
- Section 1031 exchange tax deferral mechanics
- Investor IRR and cash-on-cash returns
Built for sale-leaseback transactions
Use this model when you need to evaluate both seller proceeds and buyer returns in a single integrated framework rather than two separate analyses.
Tax deferral and reinvestment mechanics
Section 1031 exchange timing and reinvestment rules are modeled explicitly, showing how they affect net proceeds and effective seller yield.
Tenant credit and lease coverage
Lease coverage ratios and default probability are driven by lessee creditworthiness, which is the key risk lever for investor return stability.
Frequently asked
What is a sale-leaseback?+
The property owner sells real estate to an investor at fair market value and leases it back. The owner gets cash proceeds; the investor gets rental income and appreciation upside.
What is a typical cap rate in a sale-leaseback?+
Cap rates typically range from 4% to 8% depending on tenant quality, location, and market. Investment-grade tenants command lower cap rates; single-tenant triple-net leases often pay higher rates.
Can Section 1031 be used in a sale-leaseback?+
Yes, if the proceeds are reinvested in similar-kind real estate within 180 days. This defers capital gains tax, making sale-leasebacks an attractive liquidity tool for real estate-heavy owners.
Who uses sale-leaseback models?+
Real estate operators freeing up working capital, corporate finance teams monetizing property, REIT investors evaluating acquisitions, and tax advisors structuring 1031 exchanges.
What does the investor receive in a sale-leaseback?+
The investor receives contracted rental income over the lease term plus residual property value at expiration. Returns are driven by cap rate at acquisition, lease escalation, and hold period.
Alex Tapio
Founder of Finamodel • Professional Financial Modeller • Ex-Deloitte
Related templates
Real Estate Development Pro Forma Model
Land cost, construction budget, lease assumptions, and project IRR for commercial and residential development.
REIT Portfolio and NAV Analysis Model
Property-level valuations, NOI, debt, and REIT net asset value (NAV) per share for public and private REITs.
Equipment Leasing Model
Financial model for equipment leasing cash flows, accounting treatment, and lessor/lessee analysis.
Hotel Operating Model
Operating model for hotel properties including occupancy rates, average daily rate (ADR), RevPAR optimization, and facility-level profitability.