Single-tenant property is a property that is fully occupied by a single user. Single-tenant properties often feature a triple-net (NNN) lease structure and generally have remaining lease terms of at least 10 years. Single-tenant, net-leased properties, which sometimes use the acronym STNL, can be attractive to individual investors due to their low management responsibilities, predictable cash flow, and often long lease terms.
This Financial Model presents a business scenario of a Single Tenant Net Lease Property, details monthly cash inflow/outflow, and calculates the maximum equity required to execute the investment. It includes assumptions for purchase and residual price, tenant’s credit rating, rental income, operating and capital expenses, and financing through Debt & Equity, etc. Return metrics include unlevered and levered internal rate of return and equity multiple, cash on cash return, net equity profit, and more.
Outputs of the template include a Monthly Cash Flow Report for Acquisition and Operating phases, an Annual Cash Flow report (incl. operating cash flow, property’s residual value, and annual returns), Investors Returns Waterfall, and a Project Summary Dashboard summarizing investment results.
The structure of the template follows Financial Modeling Best Practices principles and is fully customizable.
Model Structure
• General Setup Tab
Investment-related inputs, including Property Metrics, Timing, Acquisition, and Residual Value Assumptions, Tenant’s Credit Rating, Rental, Opex & CapEx Assumptions, and Financing Assumptions
• Monthly Cash Flow Tab
Presents all the cash flows over monthly periods from the acquisition of the property to operating cash flow calculated from the inputs in the General
• Annual Cash Flow Tab
A roll-up of the monthly cash flows into annual periods, including Operating Cash Flow, Property Residual Value, Debt Schedule, calculation of annual returns on an unlevered and levered basis, and project valuation based on Credit and Residual Discount Rates.
• Investor Returns Waterfall Tab
Includes a standard 4-tier IRR hurdle waterfall model to distribute proceeds between investors.
• Project Summary
A professional dashboard presenting the summary of the cash flow and returns of the proposed investment
Detailed instructions on the use of the model are included in the Excel file.
Help & Support
Committed to high quality and customer satisfaction, all our templates follow best-practice financial modeling principles and are thoughtfully and carefully designed, keeping the user’s needs and comfort in mind.
No matter if you have no experience or are well versed in finance, accounting, and the use of Microsoft Excel, our professional financial models are the right tools to boost your business operations!
If you, however, experience any difficulty while using this template and you are not able to find the appropriate guidance in the provided instructions, please feel free to contact us for assistance.
If you need a template customized for your business requirements, please e-mail us and provide a brief explanation of your specific needs.
Similar Products
Other customers were also interested in...
Condominium Development – Dynamic 10 Year Fi...
A condominium (or condo for short) is a building structure divided into several units that are each ... Read more
Prefabricated Buildings Manufacturer – Dynam...
Financial model presenting a development scenario for a Prefabricated Buildings Factory including co... Read more
Land Development Financial Model – Dynamic 1...
A Financial model presenting a development scenario for raw Land. Suitable for residential land d... Read more
Mixed-Use Real Estate Model: Leverage / JV Options
A general real estate model to plan all assumptions for up to 7 'uses' for a given property. Include... Read more
Acquisition Model for Commercial Property
This is the Quintessential Commercial Property Acquisition Model that allows you to compare up to 20... Read more
Real Estate Acquisition-Rent-Sell Comprehensive An...
An integrated, dynamic and ready-to-use Real Estate Acquisition-Rent-Sell Comprehensive Analysis Mod... Read more
Multi-Family Housing Rental Renovation Model
The Multi-Family Housing Rental Renovation model projects monthly future cash flows from the renovat... Read more
Real Estate Financial Model Bundle
This is a collection of financial model templates that provides the financial projections and valuat... Read more
Real Estate Multi-Family Development Excel Model
Real Estate Financial Model to evaluate a development project, with Equity Waterfall and Advanced Sc... Read more
The Realtors Quintessential ALL-IN-ONE Toolkit
Professional Realtors need a professional Toolkit which allows them to operate at a higher level. Th... Read more
You must log in to submit a review.