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.
Friday, October 21, 2016 - Saturday, November 5, 2016 9:00 AM - 5:00 PMEastern Time
Woolworth Building15 Barclay StreetLab 322New York, New York 10013
Cvent Online Event Registration Software | Copyright © 2000-2017 Cvent, Inc. All rights reserved.