Financial Model for Sale-leaseback Analysis - Tenant and Landlord Views

This template was a tough build. It took mental stamina to complete in the way that maximizes usefulness. We are talking about getting down into the details of tax, NOL carryforwards, depreciation recapture effects, and a whole bunch of other assumptions that make the model flexible for sale-leaseback analysis from any point of view.

$45.00 USD

After purchase, the template will be immediately available to download. It is also included in the real estate and accounting template bundles as well as the Super Smart Bundle.

sale-leaseback

Template Features:

  • Model up to 20 years, annual periods.
  • Four points of view (tenant sale-leaseback, tenant buy and finance, landlord sale-leaseback, and landlord 3rd party tenant)
  • Assumptions for original cost basis, appreciation, rent / lease values plus escalations, debt assumptions, tax rates, opex items, and more.
  • The tenant sale-leaseback view has two starting point options. They are buy and sell in period zero or sell an already owned building and lease back.
  • Output analysis includes discounted cashflow analysis with NPV, IRR (relevant for landlord), option for tenant to reinvest period 0 net positive cash proceeds in sale scenarios.
  • Option to enter other business taxable income in order to see how owning vs. leasing can have certain tax benefits.
  • Net Operating Loss Carryforward waterfall logic and if any is left at exit, it will apply to depreciation recapture (relevant for buy and finance tenant option).
  • There is also a DCF Analysis for the tenant scenarios as that shows which option is cheaper.
  • Includes three cost segregation slots for more accurate depreciation expense forecast, as well as useful life inputs.

This financial model template lets you quickly compare and evaluate real estate ownership versus lease scenarios from both the tenant’s and the landlord’s perspectives. Simply enter your data into the highlighted cells to see which option yields the highest net present value (NPV)—and therefore the lowest overall cost or best return. Four distinct views are available:

Tenant Views (Tabs 1 & 2):

  • Tenant buys and eventually sells the building.
  • Tenant conducts a sale-leaseback: sells the property right away (or at period 0) and then leases it back. In this option, the tenant may also sell an existing property (relevant inputs are available for this, including the original cost basis, accumulated depreciation, and more in order to understand tax effects).

Landlord Views (Tabs 3 & 4):

  • Landlord purchases the property from a third party and collects rent.
  • Landlord does a sale-leaseback transaction with the tenant.

Annual cash flow summaries for both the Tenant View and the Landlord View show at a glance how your assumptions shape profitability and cash requirements, so you can confidently make the best decision for your situation.

Similar Templates: