Intermediate Financial Modeling (Excel) Workshop

Summary

 

This workshop will build on basic key real estate concepts that students should already be familiar with and how Excel can aid in understanding and quantifying these concepts. This workshop will provide students with the advanced tools to create their own financial models (in Excel) in order to both value and analyze real estate debt/equity transactions. Concepts covered in the workshop include: Basic Review TVM PV, FV, RATE, NPER, PMT Accumulating a future Sum (sinking fund) Implied discount rates (wining the lottery) Nominal Equivalent Rates (annual, quarterly, monthly, daily) Mortgage Math PMT function (self liquidating, balloon, negative amortizing, and interest only mortgages) IPMT/PPMT CUMPRINC/CUMIPMT Future balance Creating a floating rate amortization schedule Lenders Yield Incremental Cost of capital Loan Combinations/Blended Yield Pricing loans to achieve a yield (points + rate) Advanced Modeling Functions Search functions: VLOOKUP, HLOOKUP, INDEX, and MATCH Date functions: TODAY, EOMONTH, EDATE, and DATEDIF Scenario Functions: IF, AND, and OR Misc. functions: COUNT, COUNTA, COUNTIF, ISBLANK, CONCATENATION, SUMIF, and ISERROR Loan Sizing Senior Debt: LTV (going In/Exit), DSCR, Debt Yield Mezz Debt: LTV and DSCR Basic Equity Promote Modeling Promote Allocation: GP/LP/Promote calculations and review Waterfall Distribution: IRR based dynamic calculation ALL STUDENTS MUST HAVE A WORKING KNOWLEDGE OF EXCEL TO ATTEND THIS WORKSHOP

  • When

  • Saturday, October 22, 2016 - Friday, November 18, 2016
    9:00 AM - 5:00 PM
    Eastern Time

  • Where

  • Woolworth Building
    15 Barclay Street
    Lab 322
    New York, New York 10013

Planner

Assistant Director, Academic Services NYUSPS Schack Institute of Real Estate
11 West 42nd Street, Room 518 New York, NY 10036

Outlook Outlook
iCal iCal
Google Google
Yahoo! Yahoo!
MSN MSN
Top