• Enrollment system is currently unavailable. We apologize for the inconvenience.┬áPlease try again later.

Real Estate Financial Modeling Essentials

Learn the fundamentals of building a real estate financial investment model using Excel. Discover how to organize and to present data in order to analyze real estate investments more efficiently. Topics include income and expense assembly; multiple lease analysis, including effective rent; sizing debt with lender parameters and calculating levered and unlevered net present values (NPV) and internal rates of return (IRR); pro forma forecasting; and discounted cash flow (DCF) analysis. Multifamily, interest only (I/O), and office models are presented. Excel functions, tools, and formulas covered include SUM, ROUND, IF, AND, OR, PV, FV, RATE, NPER, NPV, XNPV, IRR, XIRR, PMT, PPMT, IPMT, VLOOKUP, HLOOKUP, and SUMIF; relative and absolute cell references; conditional statements; Boolean logic (true/false); formatting; and keyboard shortcuts.

More details

You'll Walk Away with

  • The skills to perform real estate calculations in Excel
  • The ability to develop a basic Excel model for real estate

Ideal for

  • Real estate owners and investors
  • Real estate professionals

6 sections

  • Fall 2018
    • Section

      002
    • Semester

      Fall 2018
    • Date

      Sep 12 - Oct 17
    • Day

      Wednesday
    • Time

      6:00PM-8:40PM
      • In-Person
    • Format

      In-Person
      • In-Person
    • Sessions

      6
    • Faculty

      Lam, Hillman
    • Location

      Midtown Center
  • Fall 2018
    • Section

      001
    • Semester

      Fall 2018
    • Date

      Sep 17 - Oct 29
    • Day

      Monday
    • Time

      6:00PM-8:40PM
      • In-Person
    • Format

      In-Person
      • In-Person
    • Sessions

      6
    • Faculty

      Feurich, Dieter
    • Location

      Midtown Center
    • Section

      003
    • Semester

      Fall 2018
    • Date

      Sep 17 - Oct 29
    • Day

      Self-Paced
    • Time

      Self-Paced
      • Online
    • Format

      Online
      • Online
    • Sessions

      N/A
    • Faculty

      Meo, Anthony
    • Location

      Self-Paced
    • Section

      004
    • Semester

      Fall 2018
    • Date

      Oct 20 - Nov 10
    • Day

      Saturday
    • Time

      9:00AM-1:00PM
      • In-Person
    • Format

      In-Person
      • In-Person
    • Sessions

      4
    • Faculty

      Lam, Hillman
    • Location

      Midtown Center
    • Section

      005
    • Semester

      Fall 2018
    • Date

      Oct 31 - Dec 12
    • Day

      Wednesday
    • Time

      6:00PM-8:40PM
      • In-Person
    • Format

      In-Person
      • In-Person
    • Sessions

      6
    • Faculty

      Nihalani, Amit
    • Location

      Midtown Center
    • Section

      006
    • Semester

      Fall 2018
    • Date

      Nov 5 - Dec 17
    • Day

      Self-Paced
    • Time

      Self-Paced
      • Online
    • Format

      Online
      • Online
    • Sessions

      N/A
    • Faculty

      Meo, Anthony
    • Location

      Self-Paced
Toggle

Closed

    • Section

      2
    • Semester

      Summer 2018
    • Date

      Jun 18 - Jul 30
    • Day

      Self-Paced
    • Time

      Self-Paced
      • Online
    • Format

      Online
      • Online
    • Sessions

      N/A
    • Faculty

      Meo, Anthony
    • Location

      Self-Paced
    Tuition $795
    • Section

      3
    • Semester

      Summer 2018
    • Date

      Jul 18 - Aug 22
    • Day

      Wednesday
    • Time

      6:00PM-8:45PM
      • In-Person
    • Format

      In-Person
      • In-Person
    • Sessions

      6
    • Faculty

      Nihalani, Amit
    • Location

      Washington Square
    Tuition $795
    • Section

      9
    • Semester

      Summer 2018
    • Date

      May 30 - Jul 11
    • Day

      Wednesday
    • Time

      6:00PM-8:45PM
      • In-Person
    • Format

      In-Person
      • In-Person
    • Sessions

      6
    • Faculty

      Nihalani, Amit
    • Location

      Washington Square
    Tuition $795
    • Section

      10
    • Semester

      Summer 2018
    • Date

      Jun 4 - Jul 16
    • Day

      Self-Paced
    • Time

      Self-Paced
      • Online
    • Format

      Online
      • Online
    • Sessions

      N/A
    • Faculty

      Meo, Anthony
    • Location

      Self-Paced
    Tuition $795
    • Section

      11
    • Semester

      Summer 2018
    • Date

      Jun 11 - Jul 23
    • Day

      Monday
    • Time

      6:00PM-8:45PM
      • In-Person
    • Format

      In-Person
      • In-Person
    • Sessions

      6
    • Faculty

      Lam, Hillman
    • Location

      Midtown Center
    Tuition $795