Live Webinar: Bruce Kirsch Teaches Excel for Real Estate Finance – Tue 3/28 & Wed 3/29/23

In this 2-session live course from Real Estate Financial Modeling, you will learn about the foundations of real estate finance as well as advanced techniques and topics. You will follow along in Excel in real time and perform exercises to ensure you are grasping the lesson and are mastering the technical skills being taught.

• The Time Value of Money Model
• The Discounted Cash Flow Model
• Net Present Value
• Residential Property Refinancing Feasibility Case Study
• Back of the Envelope Residual Land Valuation of Development Sites
• Acquisition and Development Transaction Capital Structuring
• Senior Construction Loan Mechanics
• Multi-Party Transaction Equity Structures
• Senior and Mezzanine Loan Funding and Repayment Dynamics
• Staggered and Pari Passu Equity Player Funding
• Maximum Refinance Loan Amount Calculation
• Equity Player Profit Sharing Introduction
• Preferred Return, Internal Rate of Return Waterfall and Promote Theory Basics

• Compounding and Discounting (FV, PV)
• Net Present Value (NPV)
• Conditional Statements (IF, AND)
• Cumulative Principal (CUMPRINC)
• Minimum (MIN)

This is a hands-on-the-keyboard course. You will watch the video and pause it to complete exercises in the associated Excel; you will repeat this process.

Our approach to help you learn is to walk through a series of mini case studies that illustrate key dynamics of real estate finance. In the interest of getting you to learn efficiently in your limited study time, we give you “skeletons” of the analysis set-ups and teach from that point of progress forward. You are of course welcome to re-build the spreadsheets from scratch at any time.

Rest assured that you will work very hard in this course, and you will learn a tremendous amount about real estate finance and financial modeling in the process.

The video running time is 1 hour 48 minutes. Watching all the video (replaying parts where desired) and completing the exercises will take approximately 3 to 5 hours, depending on the individual.

The sample questions and 39-question Certification exam will take approximately an additional 2 hours to complete.

This course will prepare you to pass the associated 39-question Certification exam, which is available online 24/7/365, and is open book. The exam has questions similar to these sample questions.

Passing the exam requires a score of 70% or better, and passing With Distinction requires a score of 85% or better. You can retake the exam if you are unsatisfied with your score.

Upon passing, you will be listed automatically on the Certification Holders page.

Upon successful completion of this course, you will:

• Have gained a critical understanding of basic and intermediate capital structuring for real estate transactions
• Be able to project property cash flows, and discount them at both constant and variable discount rates to solve for the NPV
• Be able to back-solve for the residual land value of a site for a potential office building development
• Be able to model the funding and repayment of up to 5 equity and debt layers in a development transaction analysis context, and size a refinancing loan on an existing owned property