My ULI | Find Events | Buy Books | Join | Give print this page
Session RecordingsThe Next Best Thing to Being There

Playback Now offers a complete library of recordings from ULI programs. These CDs include ULI Spring and Fall Meetings and are available in multiple media formats. To order, call (800) 241-7785 or visit www.iPlaybackULI.com.
Basic Pro-forma Modeling Using Excel
Date: April 12 - 13, 2012
Location: Chicago, IL
Google Map


Constructing an accurate pro-forma is a crucial step in any real estate development venture. But without a background in finance, real estate professionals often do not completely understand their construction and function.

Now, even non-finance professionals can develop and manipulate a pro-forma like a pro! In this intensive two-day workshop, you’ll learn the techniques to program and develop a real estate pro-forma using Excel software. Get step-by-step instruction in the inputs, formulas, and techniques to construct and manipulate a pro-forma using basic principles of real estate finance. Gain a deeper understanding of the pro-forma as you apply new concepts in a structured, hands-on learning environment.

From site selection to cash flow to financing and valuation, you’ll leave this workshop with the tools, techniques, and skills to confidently use Excel to analyze various real estate development and investment scenarios.

Who Should Attend
Designed especially for non-finance professionals who want to use Excel software to develop and program a real estate pro-forma.

Requirements
Course participants are expected to be familiar with basic Excel functions, including formatting, adding, subtracting, multiplying, and dividing.

A laptop with a CD drive and Excel 2003 or later is required. Please notify ULI if your laptop does not have a CD drive. Instruction is presented using Excel 2007.

Schedule
Registration: 8:00 a.m. to 8:30 a.m. on day 1
Program: 8:30 a.m. – 5:00 p.m. both days
Lunch: 12:00 p.m. – 1:00 p.m. both days
Instructor
Richard Haney Richard L. Haney, Jr.
Professor of Real Estate and Finance
Mays Business School
Texas A&M University
College Station, TX

Dick Haney, PhD, is a specialist in real estate finance, development, and appraisal and a professor of real estate and finance. His teaching responsibilities include graduate courses in real estate finance, development, valuation, and mortgage market analysis. He has published widely in academic and professional journals and has extensive experience teaching professional development courses, including more than 20 years as an instructor in the ULI Real Estate School.

Accommodations and Workshop Location
Hotel accommodations are not included in the registration fee. Please note that ULI does NOT have a room block at the meeting hotel.

Chicago, Illinois Program
April 12-13, 2012

Holiday Inn Chicago Mart Plaza
350 West Mart Center Drive
Chicago, Illinois 60654
312-836-5000

Registration Fee


or call 800-321-5011 with credit card information.

ULI Member: $650
Nonmember: $750
Government and non-profit: $595

Registration fee includes tuition, course materials, luncheons, and refreshments. There is an additional $100 charge for on-site registrations.

Cancellations, which must be made in writing or email to ULI’s Customer Service Department, will be subject to a $100 administrative fee. Cancellations must be received at least seven days prior to the start of the workshop to be eligible for a refund. No refunds will be granted thereafter. You may, however, transfer your registration, without penalty, to another member of your organization.

Group discounts apply if three or more employees from the same company or organization attend the same program. Call David Mulvihill at 202-624-7122 for a special price.
Program Highlights
Excel features, functions, calculations, and best practices.

Excel design guidelines for property pro-forma models.

Constructing simple and complex Excel property development pro-formas and Excel income pro-formas.

Applying different sensitivity analysis tools to Excel property development pro-forma spreadsheets and Excel income pro-forma spreadsheets.

Calculations, built-in functions, best practices, and exercises.

Pro-forma financial statement preparation.

Reverse engineering an existing spreadsheet’s formulas.

Using Excel’s solver function to identify and manipulate variable changes
Contact Professional Development

David Mulvihill
Vice President, Professional Development
Phone: 202-624-7122
E-mail: dmulvihill@uli.org

Questions or Special Needs
Contact ULI customer service at 800-321-5011 or 410-626-7505 or via email at customerservice@uli.org