Basic Financial Modeling (Excel) Workshop



We are offering a one-day workshops on Basic Real Financial Modeling (Excel) to all students enrolled in the NYU Schack Institute of Real Estate. These workshops will provide students with the basic tools to create their own financial models (in Excel) in order to both value and analyze real estate. Concepts covered in the workshop include: Navigating and using Excel: Formatting best practices, editing, inserting, deleting, text formulas, hiding Modeling best practices. Single source for inputs Proper path naming ,header / footer Filling and copying (transpose) printing and print ranges and creating range names Splitting windows, freezing and side by side views Creating multiply worksheets within a Workbook Linking References and Editing links Dates and time Notes Naming Cells Five functions of a Dollar 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 value (balance) Creating an amortization schedule (fixed/floating) Lenders Yield Loan Combinations/Blended Yield Pricing loans to achieve a yield (points + rate) Valuation and Returns Fixed Payments: PV, FV, RATE Uneven Payments: NPV/IRR (XNPV and XIRR) Going in and Exit Cap Rates Partitioning the IRR Goal Seek Manipulating data Data tables (one/two ways) Pivot Tables Auditing Formulas Using formulas/functions provided by Excel Statistical functions: Max, Min, COUNT; Look up (H and V) SUMIF Logic functions: IF/AND/OR statements Camera.

  • When

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

  • Where

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


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!