Basic Pro Forma Modeling Using Excel

« Back to Events
Start:
October 17, 2013 @ 8:00 am
End:
October 18, 2013 @ 5:00 pm
Category:
Venue:
Hotel Contessa
Address:
306 West Market Street, San Antonio, TX 78205 United States
+ Google Map
Phone:
210-229-9222
Organizer:
David Mulvihill, Vice President, Professional Development
Phone:
202-624-7122
Email:

Other

Display group registration button?
No
Display individual registration button?
Yes
Non-netforum Registration URL
https://my.uli.org/events/details/e8d66645-85e9-46e0-8da3-2b0ab2e48772
Display registration button above event description?
Yes
Display attendees list link?
No

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.

Note: Participants are required to bring their own laptops with Microsoft Excel to the course.

Principal Instructor

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.

Registration Fee

ULI Member: $650
Nonmember: $865
Govt./nonprofit Members: $595
Govt./nonprofit Nonmembers: $790

Registration fee includes tuition, course materials, continental breakfast, luncheon, and refreshments.

Accommodations

Hotel accommodations are not included in the registration fee. If you would like to make hotel arrangements, please contact the hotel directly. Please note ULI has not arranged room blocks for this program.

Cancellations must be made in writing or by e-mail to ULI’s customer service department and are subject to a $100 administrative fee. Cancellations must be received at least seven days before the start of the program to be eligible for a refund. No refunds will be granted thereafter. You may transfer your registration to another member of your organization with no penalty.

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