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

Note: Registering at least two weeks prior to the start of the course date is highly recommended. Popular classes fill up quickly and more specialized classes need sufficient enrollment.

For general information about this course, please call 212-992-3336 or email sps.realestate@nyu.edu.

If you are registered for an online course and are not able to access/view your course in Brightspace, please note the following:

  • It may take at least 24 hours from the time you registered for your information to be transferred into Brightspace.
  • New students registering two days or LESS before the start date of the course may experience delayed access.

For additional technical support, contact the IT Service Desk (available 24/7/365) at 212-998-3333 or AskITS@nyu.edu.

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

3 sections

  • Summer 2024

    • Section

      002
    • Semester

      Summer 2024
    • Date

      Jul 1 - Aug 12
    • Day

      Self-Paced
    • Time

      Self-Paced
      • Online
    • Format

      Online
      • Online
    • Sessions

      N/A
    • Faculty

      Hovsepian, Rafi
    • Location

      Self-Paced
  • Fall 2024

    • Section

      001
    • Semester

      Fall 2024
    • Date

      Sep 3 - Oct 15
    • Day

      Self-Paced
    • Time

      Self-Paced
      • Online
    • Format

      Online
      • Online
    • Sessions

      N/A
    • Faculty

      TBA
    • Location

      Self-Paced
    • Section

      002
    • Semester

      Fall 2024
    • Date

      Oct 28 - Dec 2
    • Day

      Monday
    • Time

      6:20PM-9:00PM
      • Online
    • Format

      Online
      • Online
    • Sessions

      6
    • Faculty

      TBA
    • Location

      Instructor Led
Toggle

    • Section

      4
    • Semester

      Summer 2024
    • Date

      May 28 - Jul 9
    • Day

      Self-Paced
    • Time

      Self-Paced
      • Online
    • Format

      Online
      • Online
    • Sessions

      N/A
    • Faculty

      Meo, Anthony
    • Location

      Self-Paced
    Tuition $843
    • Section

      5
    • Semester

      Summer 2024
    • Date

      Jun 11 - Jul 16
    • Day

      Tuesday
    • Time

      6:00PM-8:40PM
      • Online
    • Format

      Online
      • Online
    • Sessions

      6
    • Faculty

      Siddiqui, Ali
    • Location

      Instructor Led
    Tuition $843