REAL ESTATE FINANCIAL MODELING
FIN7527: Real Estate Financial Modeling
3 Elective credit
This course will address the practical and theoretical issues involved in estimating cash flows and values of a wide variety real property, financial interests, investment interests and deal structures using discounted cash flow (DCF) techniques and sensitivity analyses. Students will solve real estate cash flow and DCF problems using models for property, portfolio, debt and equity interests for a variety of commercial real estate property types. Students will detailed modeling applications necessary to estimate both cash flows and values in the world of real estate finance and capital markets. Students will use and learn both Excel and industry standard software applications in the process of modelling lease by lease cash flows at the property level, portfolio cash flow consolidations, related debt structures, including first mortgage and mezzanine debt, and equity waterfall structures. This course includes explanation of the theoretical issues and concepts involved in these practical applications. This course is intended for students who have an interest in real estate or who desire to expand their knowledge of finance to include real estate.
Prerequisite: FIN7200 or FIN7800 or students enrolled in the MSF
Course Level:MSF Elective (Grad),Graduate Elective (Grad)