Originally held over two sessions this programwill provide students with the tools necessary to create their own financial models in Excel in order to both value and analyze real estate debt and equity transactions. Beginning with a blank spreadsheet, students will combine theory with practice to explore the basic building blocks upon which all financial modeling is based. The program will run the gamut from time-value of-money (TVM) analysis to derivation of returns and basic mortgage analysis.
Program Information
Program Date:
July 22, 2014
Introduction to Real Estate Financial Analysis Session 1
Session I
  • Understanding present value (PV), future value (FV), RATE, NPER, and PMT functions
  • Accumulating a future sum (sinking fund)
  • Nominal equivalent rates (annual, quarterly, monthly, daily)
  • Understanding net present value (NPV) vs. XNPV
  • Understanding internal rate of return (IRR) vs. XIRR
  • Partitioning the IRR
  • How return measures are derived
Speaker Information
David Eyzenberg   [ view bio ]
Introduction to Real Estate Financial Analysis Session 2
Session II
  • How to size a loan using four stress tests (LTV, DSCR, Debt Yield, Exit LTV)
  • Modeling floating and fixed interest rate amortization tables
  • Using the PMT function (self-liquidating, balloon, negative amortizing, and interest only mortgages)
  • Future balance analysis using FV and PV
Speaker Information
David Eyzenberg   [ view bio ]
Individual topic purchase: Selected
Share This
Preview
Preview Introduction to Real Estate Financial Analysis Session 1Preview Introduction to Real Estate Financial Analysis Session 1
Products
Streaming
Public Member: $195.00
Member: $215.00
Public Nonmember: $265.00
Full Price: $295.00