The Complete Step-By-Step Guide To Building Dynamic Commercial Real Estate Lease Models in Microsoft Excel
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 workbook and 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 an institutional-quality, dynamic commercial real estate lease model from scratch
Learn key Excel shortcuts to double your real estate financial modeling speed
Model multiple lease structures and quickly and easily model complex reimbursement structures (NNN, FSG, MG, & BYS)
Use renewal probability to accurately drive your future cash flows at a commercial property
Build a dynamic lease structure that models irregular rent increases (or decreases) and dynamically changes cash flows with the click of a button
Model dynamic leasing commissions on a commercial deal, even if you have different agreements for different periods of a lease
Build out percentage rent formulas to model percentage rent payments for retail tenants based on net sales
Create easy-to-view annual 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 you head 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 to buy real estate on the side and want to be able to confidently analyze a commercial dealÂ
You're an existing real estate professional looking to advance 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 into bigger commercial properties and want to feel confident 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!
Learn how to build dynamic, institutional-quality CRE models incorporating reimbursement structures, rent escalation schedules, re-leasing assumptions, and more
Learn how to replace ARGUS and use Excel to perform the calculations necessary to model commercial leases
Learn how to create institutional, professionally formatted models for retail, office, and industrial deals to present to investors and partners
6 Lectures
17 Lectures
8 Lectures
28 Lectures
8 Lectures
10 Lectures
1 Lectures
1 Lectures
Master real estate financial modeling, advance your career, and earn more money.If you’re an aspiring real estate investment professional looking to break into the real estate investment field, or a current real estate professional looking to advance your career and increase your compensation, you’re in the right place.My name is Justin Kivel, and I’m a real estate investment professional with...
Fantastic course covering much detials.
Basic stuff but making it dynamic is extremely meticulous. The step by step videos helps look the complex end sheet so easy to build. Thank you very much.
Good so far
Very informative, this course brought out a lot of Excel functions I have not used before. Overall, excellent preparation for CRE
This course was a great match for me. I am a new CRE analyst focusing an transactional analysis for tenants. I took this course because I want to improve my analysis and modeling skills.
Jason's use of CRE terminology is the correct industry standard, the concepts are explained clearly, and the modeling techniques are very helpful.
My goal is to make my models more dynamic so I can quickly analyze multiple tenants and create valuations for LL's.
I think it would be very helpful if there were supplemental documents for excel formulas. For example for the nested if functions, it would be awesome if the professor provided a text example of how the if statements are nested.
This can be a lot to take in especially if you are new to CRE / modeling like me, but stick through and practice. This is exactly what I need on the tenant representation leasing side of brokerage.
Well Explained
It was concise and professionally presented.
Will be taking more courses like this one.
Instructor speak fast. It would be great if instructor speak in tempo and a handout.
Can't begin to say how helpful this class was. I've taken REFM and Breaking into Wallstreet, as well as Justin's entire course load of modeling classes. Justin's classes are by far the most sophisticated, and yet they are the easiest to learn because he's that great of an instructor. These classes gave me the knowledge & tools to go from a Government major with zero finance background to succeeding in my first CRE role as the senior analyst at a small investment/development shop. To anyone looking to break into CRE... just know that IT IS possible with these classes to easily transition into an analyst role, but for those without a business degree you'll have to NETWORK your a** off to get a job. Best of luck to all and thank you Justin, I owe you much more than just the cost of these classes.
Your email address will not be published. Required fields are marked *
Seth P.
Easy to follow and well organized.