About this badge
Learn to build financial models for the acquisition and refinancing of commercial real estate, in this hands-on Excel course. Discover how to organize and to present data in order to analyze real estate investments more efficiently. Topics include annual property operating statements, pro forma forecasting and preparation, discounted cash flow analysis, before- and after-tax NPV and IRR calculations, integration of risk analysis into financial models, scenario and sensitivity analysis, cost of capital, and portfolio management. Also, hone your Excel skills, including the use of data tables, goal seek, solver functions, and statistical tools. Spreadsheet design and formula composition are emphasized.
