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

Fundamentals of Real Estate Financial Modeling

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 to be 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

2 sections

  • Spring 2018
    • Section

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

      003
    • Semester

      Spring 2018
    • Date

      Mar 28 - May 2
    • Day

      Wednesday
    • Time

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

      In-Person
      • In-Person
    • Sessions

      6
    • Faculty

      Nihalani, Amit
    • Location

      Washington Square
Toggle

Closed

    • Section

      3
    • Semester

      Spring 2018
    • Date

      Feb 7 - Mar 21
    • Day

      Wednesday
    • Time

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

      In-Person
      • In-Person
    • Sessions

      6
    • Faculty

      Nihalani, Amit
    • Location

      Washington Square
    Tuition $795