Back to All Events

Excel Financial Modeling Workshop


Organized and sponsored by the Harvard Alumni Real Estate Board, the Real Estate Financial Modeling Coursecombines 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.

Earlier Event: November 2
New York City Trek
Later Event: November 9
Chicago City Trek