Fundamentals of Real Estate Financial Modeling
Learn the fundamentals of building a real estate financial investment model using Excel. Discover how to organize and to present data in order to analyze real estate investments more efficiently. Topics include income and expense assembly; multiple lease analysis, including effective rent; sizing debt with lender parameters and calculating levered and unlevered net present values (NPV) and internal rates of return (IRR); pro forma forecasting; and discounted cash flow (DCF) analysis. Multifamily, interest only (I/O), and office models are presented. Excel functions, tools, and formulas to be covered include SUM, ROUND, IF, AND, OR, PV, FV, RATE, NPER, NPV, XNPV, IRR, XIRR, PMT, PPMT, IPMT, VLOOKUP, HLOOKUP, and SUMIF; relative and absolute cell references; conditional statements; Boolean logic (true/false); formatting; and keyboard shortcuts.
You'll Walk Away with
- The skills to perform real estate calculations in Excel
- The ability to develop a basic Excel model for real estate