FIN4571 Real Estate Finance and Advanced Modeling
4 Advanced Management Credits
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 learn and apply the 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 ARGUS software applications in the process of modeling 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. ARGUS is a widely accepted unique and complex modeling software that is very frequently required by employers in real estate finance. This course includes explanations 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.
Prerequisites: SME2021