Loading...

Course Description

In this course, you will gain an overview of real estate financial modeling, focusing on properties with multi-year leases. Using the models and frameworks established as today’s industry standards in real estate, you will explore deriving basic valuations and performance calculations. You’ll discover how a discounted cash flow model can be used to deliver sound real estate investment and financial decision-making through hands-on practical exercises.

As part of this process, this course will introduce the various Excel functions required to develop dynamic models to assist decision-makers. To be successful, these tools must be simple to use and interpret, must offer realistic outcomes to complex hypothetical real estate situations, and must be capable of handling a wide range of scenarios. High-stakes decision-making requires a comprehensive understanding of the options and their associated risk. Therefore, the first step is to adopt best practices then apply the essential building blocks in Excel that will be covered in this course, creating a foundation for your future work in this area.

Faculty Author

Daniel Lebret

Benefits to the Learner

  • Navigate the Excel ecosystem by way of a discounted cash flow model
  • Derive valuation and infer future cash flows by utilizing the tools in Excel
  • Identify when to use IF statements and LOOKUP, TRUE/FALSE, INDEX/MATCH, and OFFSET functions, strategically applying these conditional functions to your model according to your audience
  • Develop a lateral and critical-thinking mindset for solving challenges in real estate with financial models
  • Review a discounted cash flow model and articulate the elements included in a full model

Target Audience

  • Acquisition and asset managers
  • Financial analysts
  • Real estate investors
  • Real estate development professionals
  • Individuals looking to invest in commercial real estate
  • MBA students
  • City and regional planning professionals

Accrediting Associations

Applies Towards the Following Certificates

Loading...
Enroll Now - Select a section to enroll in
Type
3 week
Dates
Nov 26, 2025 to Dec 16, 2025
Total Number of Hours
15.0
Course Fee(s)
Standard Price $1,199.00
Type
3 week
Dates
Jan 21, 2026 to Feb 10, 2026
Total Number of Hours
15.0
Course Fee(s)
Standard Price $1,199.00
Type
3 week
Dates
Mar 18, 2026 to Apr 07, 2026
Total Number of Hours
15.0
Course Fee(s)
Standard Price $1,199.00
Type
3 week
Dates
Apr 01, 2026 to Apr 21, 2026
Total Number of Hours
15.0
Course Fee(s)
Standard Price $1,199.00
Type
3 week
Dates
May 13, 2026 to Jun 02, 2026
Total Number of Hours
15.0
Course Fee(s)
Standard Price $1,199.00
Type
3 week
Dates
Jun 10, 2026 to Jun 30, 2026
Total Number of Hours
15.0
Course Fee(s)
Standard Price $1,199.00
Type
3 week
Dates
Jul 08, 2026 to Jul 28, 2026
Total Number of Hours
15.0
Course Fee(s)
Standard Price $1,199.00
Type
3 week
Dates
Aug 19, 2026 to Sep 08, 2026
Total Number of Hours
15.0
Course Fee(s)
Standard Price $1,199.00
Type
3 week
Dates
Sep 02, 2026 to Sep 22, 2026
Total Number of Hours
15.0
Course Fee(s)
Standard Price $1,199.00
Type
3 week
Dates
Oct 28, 2026 to Nov 17, 2026
Total Number of Hours
15.0
Course Fee(s)
Standard Price $1,199.00
Type
3 week
Dates
Dec 23, 2026 to Jan 12, 2027
Total Number of Hours
15.0
Course Fee(s)
Standard Price $1,199.00
Required fields are indicated by .