REAL ESTATE EXCEL MODELING

Prerequisites & course information

Requisites: REAL EST 410 , 710 , or concurrent enrollment Course Designation: Core GenEd - Mathematics & Quantitative Reasoning Grad 50% - Counts toward 50% graduate coursework requirement Repeatable for Credit: No Last Taught: Fall 2026 Learning Outcomes: 1. Demonstrate key components required to model a real estate transaction program summary, sources and uses of funds, income statement, debt and equity waterfall. Audience: Both Grad & Undergrad 2. Demonstrate key functions in excel that are used in the real estate profession including, PMT (payment), PV (present value), NPV (net present value), IRR (internal rate of return), EM (equity multiple), Sumproduct, Round, Solver, Data Table, named Ranges, charts, error bars and circular references. Audience: Both Grad & Undergrad 3. Model acquisition and development transactions for residential and commercial real estate. Audience: Both Grad & Undergrad 4. Perform management reporting and sensitivity analysis on PV (present value) and IRR (internal rate of return) for various debt and occupancy metrics. Audience: Graduate Learning Outcomes: 1. Demonstrate key components required to model a real estate transaction program summary, sources and uses of funds, income statement, debt and equity waterfall. Audience: Both Grad & Undergrad 2. Demonstrate key functions in excel that are used in the real estate profession including, PMT (payment), PV (present value), NPV (net present value), IRR (internal rate of return), EM (equity multiple), Sumproduct, Round, Solver, Data Table, named Ranges, charts, error bars and circular references. Audience: Both Grad & Undergrad 3. Model acquisition and development transactions for residential and commercial real estate. Audience: Both Grad & Undergrad 4. Perform management reporting and sensitivity analysis on PV (present value) and IRR (internal rate of return) for various debt and occupancy metrics. Audience: Graduate