# Sale-Leaseback Real Estate Model 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. - Canonical: https://finamodel.com/templates/sale-leaseback-model - Excel download: https://finamodel.com/templates/sale-leaseback.xlsx - Category: Real Estate - Model type: Underwriting - Difficulty: Advanced - Audiences: Developers & sponsors, Bankers & advisors, Real estate operators, Corporate finance teams, REIT investors, Tax advisors - Tags: leasing, financing, tax-deferral, reit ## Overview 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. ## 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 - Lessee creditworthiness and default risk ## Sale-Leaseback Model for Commercial Real Estate This sale-leaseback model evaluates the financial implications of a sale-leaseback for both the seller-lessee and the buyer-lessor. It covers transaction pricing, lease terms, tax effects, and investor returns. The workbook includes separate schedules for the lease, property operations, debt, buyer cash flow, seller analysis, and validation checks. ### Operating Drivers Behind Modeled Cash Flows The model's core drivers are defined in the Assumptions sheet as named ranges. Property value, land and building split, useful life, and hold period anchor the transaction. - Lease inputs include the going-in cap rate, annual escalation, and NNN charges. Buyer-lessor costs include asset management and capex reserve percentages, plus a buyer tax rate. - Financing assumptions cover LTV, interest rate, loan term, interest-only period, and amortisation period. A scenario toggle (base, upside, or downside) applies changes to several key inputs without altering prior years. The effective drivers then reflect the adjusted values used throughout the model. This setup allows sensitivity testing of the main operating variables while keeping all calculations linked. ### Calculation Flow and Key Relationships The calculation flow begins with Year 1 base rent, equal to purchase price times the going-in cap rate. Subsequent rents grow by compounding the escalation rate. - Landlord costs for asset management and capex reserves are applied to an escalating property value, so the NOI margin remains flat over the hold period. NOI equals base rent less those landlord-retained costs. - Debt draws at LTV, with interest on the opening balance and principal amortisation that is zero during any interest-only period. Depreciation is straight-line on the building value only. - Taxable income is NOI less interest and depreciation; cash tax is the positive taxable income times the buyer tax rate. After-tax operating cash flow nets out debt service and cash tax. - At exit, the sale value is forward NOI divided by the exit cap rate, less selling costs and loan payoff. The exit-year cash flow combines operating cash flow and net sale proceeds without double-counting NOI. Seller analysis separately computes net capital freed and compares the net present value of leasing versus owning, including an IFRS-16 right-of-use liability schedule. Calculation summary: ```text NOI = base rent − those landlord-retained costs ``` ### Outputs and Performance Metrics The model reports after-tax unlevered and levered IRR, equity multiple, stabilised cash-on-cash return, and yield-on-cost. It also produces a sensitivity grid showing levered IRR across exit cap rate and interest rate combinations. - For the seller-lessee, the key output is the net advantage of the sale-leaseback, calculated as the NPV of the leasing path minus the NPV of the owning path, with a finite figure confirming the comparison is meaningful. The debt schedule provides DSCR, debt yield, and LTV metrics. - A checks sheet validates sources and uses, covenant compliance, the NOI margin band, return targets, IRR sanity, yield-on-cost, amortisation, seller net advantage, the ROU liability tie to present value, and the scenario toggle. All checks reference named thresholds from the Assumptions sheet. ### Practical Use for Evaluating the Transaction This model supports a dual perspective within a single workbook: the seller-lessee weighing whether to monetise the property, and the buyer-lessor underwriting a stabilised, income-producing asset. Users can flex the scenario toggle to see how changes in key drivers affect outcomes. - The model is intended for commercial real estate sale-leaseback transactions and is not designed for other property strategies. The accompanying downloadable file is a values-only preview of the underlying calculations; it does not contain live formulas. - Nonetheless, the design allows users to understand the relationships and inputs that determine the financial results. The model's structured check suite helps ensure internal consistency, making it a useful template for analysing a sale-leaseback decision. ## 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. ## 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. ## Features - **Lease economics and credit analysis:** Model tenant credit quality, lease coverage ratios, and default probability to validate investor return stability. - **Tax deferral optimization:** Show Section 1031 exchange benefits and how reinvestment timing affects seller's tax liability and cash flow. - **Investor return alignment:** Calculate IRR, equity multiple, and cash-on-cash returns for different buyer leverage levels and hold periods. ## Use cases - **Corporate liquidity planning:** Free up working capital from real estate while maintaining tenant operations and passing tax liability to the investor. - **REIT or investor acquisition:** Evaluate sale-leaseback offers from REITs by comparing proceeds, lease rates, and control retention to outright asset sales. - **Tax-efficient monetization:** Use Section 1031 exchanges to defer taxes and redeploy capital into higher-growth assets or markets. ## Frequently asked questions ### 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. ## Related templates - [Real Estate Development Pro Forma Model](https://finamodel.com/templates/real-estate-model) - [REIT Portfolio and NAV Analysis Model](https://finamodel.com/templates/reit-portfolio-model) - [Equipment Leasing Model](https://finamodel.com/templates/leasing-model)