Advanced Excel Modeling Workshop June 7-8, 2008

June 7-8, 2008
9:00am - 5:00pm

CLICK HERE for the workshop agenda

This 2-day workshop is the same workshop Josh Kahr taught through the Urban Land Institute. It is designed especially for real estate professionals who want to build complex financial models using Excel. Students will develop their own spreadsheets for different property types that will allow them to model any real estate investment scenario quickly and effectively.

What you will learn.

• Integrate statistical tools into your real estate investment models.
• Build sensitivity tables that quantify changes in variables.
• Learn how to use hidden functions in Excel to handle uneven cash flows.
• Control model using custom-built forms, checkboxes, and menus.
• Integrate Excel with other modeling software.
• Develop reusable models and audit existing models.

Students will learn advanced tools in Excel and apply them immediately to their own Excel models. Important skills such as building construction loan and development models, using statistical skills to better understand real estate investments, developing reusable models, and auditing existing models will be addressed in detail.

Students taking this workshop are expected to have a basic knowledge of Excel and a firm grasp of basic real estate finance concepts such as time value of money, internal rate of return (IRR), and net present value (NPV).

A laptop with a CD drive and Excel 2000 or later is required.

Enrollment is limited and fills to capacity each time it is held, so register early to ensure your attendance.