BENEFITS OF DOCUMENT
DESCRIPTION
Single tenant property is 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 Monthly Cash Flow Report for Acquisition and Operating phases, 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 you 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.
Got a question about the product? Email us at support@flevy.com or ask the author directly by using the "Ask the Author a Question" form. If you cannot view the preview above this document description, go here to view the large preview instead.
Source: Best Practices in Real Estate Excel: Single Tenant Net Lease (NNN) - Investment & Valuation Model Excel (XLSX) Spreadsheet, Profit Vision
Download our FREE Strategy & Transformation Framework Templates
Download our free compilation of 50+ Strategy & Transformation slides and templates. Frameworks include McKinsey 7-S Strategy Model, Balanced Scorecard, Disruptive Innovation, BCG Experience Curve, and many more. |