• 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

5 sections

  • Summer 2018
    • Section

      001
    • 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

      Woolworth Building
  • Summer 2018
    • Section

      003
    • 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
    • Section

      002
    • Semester

      Summer 2018
    • Date

      Jun 11 - Jul 16
    • Day

      Monday
    • Time

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

      In-Person
      • In-Person
    • Sessions

      6
    • Faculty

      Lam, Hillman
    • Location

      Midtown Center
    • Section

      004
    • 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
    • Section

      005
    • 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

      Midtown Center
Toggle

Closed

    • Section

      2
    • Semester

      Spring 2018
    • Date

      Apr 2 - May 7
    • Day

      Monday
    • Time

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

      In-Person
      • In-Person
    • Sessions

      6
    • Faculty

      Feurich, Dieter
    • Location

      Midtown Center
    Tuition $795
    • Section

      3
    • Semester

      Spring 2018
    • Date

      Apr 7 - Apr 28
    • Day

      Saturday
    • Time

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

      In-Person
      • In-Person
    • Sessions

      4
    • Faculty

      Hovsepian, Rafi
    • Location

      Midtown Center
    Tuition $795
    • Section

      8
    • Semester

      Spring 2018
    • Date

      Feb 5 - Mar 26
    • Day

      Monday
    • Time

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

      In-Person
      • In-Person
    • Sessions

      6
    • Faculty

      Feurich, Dieter
    • Location

      Midtown Center
    Tuition $795
    • Section

      9
    • Semester

      Spring 2018
    • Date

      Feb 12 - Mar 26
    • Day

      Self-Paced
    • Time

      Self-Paced
      • Online
    • Format

      Online
      • Online
    • Sessions

      N/A
    • Faculty

      Meo, Anthony
    • Location

      Self-Paced
    Tuition $795
    • Section

      10
    • Semester

      Spring 2018
    • Date

      Mar 26 - May 7
    • Day

      Self-Paced
    • Time

      Self-Paced
      • Online
    • Format

      Online
      • Online
    • Sessions

      N/A
    • Faculty

      Meo, Anthony
    • Location

      Self-Paced
    Tuition $795