Organized and sponsored by the Harvard Alumni Real Estate Board, the Real Estate Financial Modeling Course combines lectures with hands-on exercises. The course will begin with the fundamentals of using Microsoft Excel for real estate financial modeling, with an emphasis on those formulas, shortcuts and strategies most applicable to discounted cash flow analysis. As the course progresses, students will put these skills to use in a case study format, with financial modeling exercises based on hypothetical real estate development scenarios. Students will learn how to model unlevered and levered property-level cash flows for a mixed-use development as well as waterfall cash flows for an equity joint venture for an individual property transaction.

Registration is now open! Seats are limited and registration is on a first-come first-serve basis.