Рет қаралды 5,087
A section-by-section walkthrough to our Commercial Real Estate Lease Analysis Tool in Excel. This is an Excel financial model for analyzing lease cash flows from the perspective of the landlord and the tenant. Includes a comprehensive Lease Abstract, from which tenant and landlord cash flows are modeled and then metrics such as net effective rent and net present value of lease cash flows are calculated. Learn more and download the model here: www.adventuresincre.com/comme...
00:00 - Introduction to Commercial Real Estate Lease Analysis Tool and Tool Overview
01:33 - Navigating the Versions Tab and the Lease Abstract Tab
03:28 - Tenant Description and Basic Lease Provisions
05:47 - Understanding the Rent Schedule and Lease Term Details
09:12 - Configuring Detailed Rent Schedules and Lease Periods
12:07 - Setting Up Rent Bumps and Extended Lease Options
16:11 - Other Tenant Rent Contributions and Operating Expenses Breakdown
21:34 - Tenant and Landlord Responsibilities in Lease Scenarios
27:39 - Preparing Lease Abstract for Print and Analyzing Lease Cash Flows
33:17 - Tenant vs. Landlord Cash Flow Analysis and Summary Tab Overview
38:19 - Conclusion and Invitation for Feedback on the Lease Analysis Tool
View all of the models in our Library of Real Estate Excel models: www.adventuresincre.com/libra...
Learn to build institutional-quality real estate models: www.adventuresincre.com/accel...
SUBSCRIBE: kzfaq.info...