Essentials of Real Estate Excel Modeling
Courses Certificates Corporate Education I-20 Visa Programs ESL American Business Program Sign In / Register
Sign In   |   View Cart   |     |   Help
 
Print Course information
E-mail to a friend
Return to Course Catalog

Course Catalog > Real Estate

Essentials of Real Estate Excel Modeling  

This course is dedicated to teaching students the fundamentals in building a real estate model using Excel. By enrolling in this course, students will understand how to organize and present data to analyze real estate investments in multifamily, retail, and office properties. Topics to be covered include reconstructing an operating statement (rent roll, income & expenses), loan amortization schedule, sources and uses of capital, selling price of property, estimating the property's value, financial ratios, cap and discount rates for unlevered and levered calculations of net present value (NPV) and internal rate of return (IRR). Excel functions, tools, and formulas include SUM, SUMIF, SUMPRODUCT, COUNT, MIN, MAX, AVERAGE, DATE, ROUND, IF, DOUBLE IF STATEMENTS, AND, OR, PV, FV, RATE, NPER, NPV, IRR, PMT, PPMT, IPMT, VLOOKUP, HLOOKUP, GOAL SEEK, and DATA TABLE; relative and absolute cell references; conditional statements; Boolean logic (true/false); formatting; and keyboard shortcuts.

 

SP19NCPEL10501 $429.00
(5 Sessions) Day(s): Tu Th
3/19/2019-4/14/2019 6:00 PM-9:15 PM