The Commercial Real Estate Lease Modeling Master Class

Want to learn how to model complex commercial real estate leases in Microsoft Excel from scratch, even without ARGUS? 

This course is a complete, step-by-step guide to modeling commercial leases for retail, office, and industrial real estate. This is a project-based course, meaning you’ll start with a blank Excel workbookand walk away with a fully-functional, dynamic, commercial lease model that YOU’VE created – from scratch.

By the end of this course, you’ll be able to build a dynamic, professional-quality commercial real estate lease model from scratch, and your first one will be done by the time you finish the last lecture.

This course will teach you how to model things like multiple tenant lease terms and expiration dates, complex reimbursement structures, renewal probability and downtime, tenant improvement allowances, leasing commissions, and much, much more. At the end of this course, you will be able to:

• Build aninstitutional-quality, dynamic commercial real estate lease model from scratch

• Learn key Excel shortcuts todouble your real estate financial modeling speed

• Model multiple lease structures and quickly and easily model complex reimbursement structures (NNN, FSG, MG, & BYS)

• Userenewal probability to accurately driveyour future cash flows at a commercial property

• Build adynamic lease structure that models irregular rent increases (or decreases) and dynamically changes cash flows with the click of a button

• Modeldynamic leasing commissionson a commercial deal, even if you have different agreements for different periods of a lease

• Build outpercentage rent formulas to model percentage rent payments for retail tenants based on net sales

• Createeasy-to-viewannual cash flow roll-ups to quickly review your work and present to investors or colleagues

This course is perfect for you if:

• You’re a college student or graduate student looking to break into real estate investment after graduation, and you’re looking to add the key technical skill sets to your arsenal that will put youhead and shoulders above the competition and allow you to land a lucrative career opportunity in the field

• You’re a professional in a different field, but looking tobuy real estate on the side and want to be able toconfidently analyze a commercial deal 

• You’re an existing real estate professional looking toadvance your career, increase your compensation, and break into the real estate investment industry.

• You’ve bought rental homes or duplexes, and now you’re looking to move intobigger commercial properties and want to feelconfident in your ability to analyze deals.

Here’s what some of our students have had to say:

★★★★★ “Justin really takes a deep dive into crucial concepts that play a huge role in the practical modeling portion of the course. The content is clear and concise, and he makes sure you understand things before moving onto more advanced material. I’ve taken a few of Justin’s courses and every one of them has been indispensable in my REPE analyst intern role.”

★★★★★“Brilliant Justin. Each course I do I get more confident and regularly use the skills and formula writing at work. The great think about these courses is that they revolve around the same base. Each time you complete a different course the base knowledge is reinforced and then built upon.”

★★★★★“This course I found to be complete in all aspects of Commercial Lease Modeling, combined with Justin’s teaching style, really enables me to look at Commercial lease modeling opportunities with a renewed sense of understanding, and confidence.”

If you have a basic understanding of real estate finance, and you’re looking to apply that knowledge to analyze new commercial real estate investment opportunities, enroll now and let’s get started building this model together today. Looking forward to having you in the course!

Rating Distribution

• 1 stars: 0 votes
• 2 stars: 3 votes
• 3 stars: 24 votes
• 4 stars: 125 votes
• 5 stars: 310 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!