Sale-leaseback Template – Multiple Points of View

All Industries, Financial Model, General Excel Financial Models, Real Estate

10-year Financial Projections, 5-year Financial Projections, Accounting, Amortization, Calculator, Cap Rate (Capitalization Rate), Cash Flow Analysis, Cash Flow Projections, Cash-on-Cash Multiple, CFO, DCF Model, Debt Amortization, Debt Schedule, Discount Rate, Excel, Financial Analysis, Financial Due Diligence, Financial Feasibility, Financial Model, Financial Modeling, Financial Planning, Financial Projections, Forecast, Forecasting, Income Statement, Investing Cash Flows, Investment Multiple, IRR (Internal Rate of Return), Know-How, NPV (Net Present Value), Private Equity, Pro-Forma, Profitability Analysis, Real Estate Valuation, Return on Invested Capital (ROIC), Return on Investment (ROI), Revenue Projections, Scenario Analysis, Sensitivity Analysis, Startup Financial Models, Tax Assets, Terminal Value

Video Overview:

Description of the Template

This comprehensive financial model is specifically designed to handle the complexities of real estate sale-leaseback transactions from both the tenant’s and the landlord’s perspectives. It allows for up to 20 years of annual cash flow analysis, incorporates detailed tax considerations (including NOL carryforward and depreciation recapture), and provides four distinct scenario views (two for the tenant and two for the landlord). With the flexibility to input original cost basis, appreciation, rent schedules, debt assumptions, and other operating details, the template delivers a robust framework to compare buying, financing, selling, and leasing options—ultimately helping stakeholders determine which path offers the most favorable economics.

Key Features

Four Scenario Views
- Tenant Buy and Finance: Illustrates the cash flows, tax implications, and overall profitability if a tenant purchases a building and eventually sells it.
- Tenant Sale-Leaseback: Allows users to model a sale-leaseback in two ways:
  - Selling at period zero and then leasing back immediately.
  - Selling a building the tenant already owns and leasing it back.
- Landlord 3rd Party Tenant: Models a landlord purchasing a property from a third party and generating rental income.
- Landlord Sale-Leaseback: Analyzes how a landlord would structure a sale-leaseback transaction with the tenant.
Detailed Assumptions
- Original Cost Basis & Accumulated Depreciation: Ensures accurate tax calculations and gain/loss recognition.
- Rent, Lease Values, & Escalations: Lets you factor in future rent increases for more realistic projections.
- Debt Assumptions: Incorporates financing details to measure leveraged vs. unleveraged returns.
- Tax Rates & Other Business Income: Examines the effect of various tax rates and additional taxable income, showing how owning vs. leasing may alter tax liabilities or benefits.
- Operating Expenses & Capital Expenditures: Provides a flexible structure to input annual operating and capital costs that impact net cash flows.
Advanced Tax Logic
- NOL Carryforward Waterfall: Tracks net operating losses year-over-year and applies any remaining amounts to exit-year depreciation recapture, which is crucial for gauging true after-tax results.
- Cost Segregation Slots: Up to three distinct cost segregation schedules allow for more accurate depreciation expense forecasting, reflecting different asset-class useful lives.
Robust Output Analysis
- Discounted Cash Flow (DCF), NPV, & IRR: Each scenario calculates key metrics, enabling quick comparison of returns or costs over the model period.
- Tenant Reinvestment Option: In sale scenarios, the template can model reinvesting the net cash proceeds, showing how the released capital might yield alternative returns.
- Annual Cash Flow Summaries: Easy-to-read overviews of each scenario’s profitability, cash requirements, and tax impacts.
Ease of Use & Comparison
- Single Tool, Multiple Perspectives: Switch between tenant and landlord views without the need for multiple models.
- Highlighted Input Cells: Provides clear guidance on where to enter data, reducing user error and saving time.
- Customizable Period Length: Model any holding or lease term up to 20 years, accommodating a broad range of real estate strategies.

Why This Template Is Useful

Comprehensive Analysis: By covering both tenant and landlord angles, the model shows the complete financial impact of a sale-leaseback—or a straightforward buy/lease—across every major variable.
Tax-Efficient Insights: The detailed tax treatment (including depreciation recapture and NOLs) helps stakeholders understand the true after-tax cash flows and ultimate economic outcomes.
Time-Saving & Flexible: The pre-built structure with highlighted inputs enables quick scenario testing, so users can rapidly adjust assumptions (rent escalations, loan terms, purchase price, etc.) without rebuilding from scratch.
Decision Clarity: Side-by-side comparisons of NPV, IRR, and other metrics make it easier to see which strategy (own vs. lease, or sale-leaseback) produces the best financial results under different assumptions.
Professional-Level Detail: Despite its user-friendly interface, the model captures professional-level detail and rigor, making it useful for both high-level strategic decisions and deep-dive transactional analysis.

This template provides a powerful, user-friendly way to evaluate and compare real estate ownership versus leasing scenarios—whether you’re a tenant considering a buy or sale-leaseback strategy, or a landlord looking to acquire and lease out a building. By simplifying complex tax rules and cash flow projections into clear metrics (NPV, IRR, etc.), it facilitates confident decision-making grounded in thorough financial analysis.

You must log in to submit a review.