REAL ESTATE EXCEL MODELING

REALEST 410

Fundamentals of real estate finance and investment. Qualitative and quantitative characteristics of commercial real estate. Developing and analyzing commercial property cash flow projections. Introduction to three approaches to valuation with emphasis on investing in commercial real estate. In-depth exposure to debt and equity investor returns.

REALEST 412

Introduction to real estate modeling using ARGUS. ARGUS will be used to build a real estate model for acquisition transactions for office and retail mall properties. Learn how to input assumptions, make decisions using reports, perform sensitivity analysis on model inputs and explain terminology used in Office and Retail real estate.

REALEST 702

Introduction to various techniques to analyze commercial real estate value and investment risks. Analysis of real property through an understanding of the legal, physical, and economic characteristics of a site and building. Analyze real estate markets to forecast future rental income and vacancies. Develop an operating pro forma and basic investment model, forecast future cash flows, and learn to estimate the market value of commercial properties.

REALEST 770

A capstone focused on advanced topics in commercial real estate finance. The course is broken into three parts: 1) Financial Derivatives, 2) Risk Management, and 3) Structured Finance. Lectures will address relevant topic areas and develop methodological skills. Industry professionals will provide real world markets perspective. case studies will be used to reinforce material presented in class.

REALEST 750

Creating industrial real estate, office space, shopping centers, and hotel/recreation facilities, including strategy, market and feasibility analysis, site planning/design, capital cost analysis, construction, and financial structuring. Emphasis on case studies and project analysis.