Advanced Pro Forma Modeling Using Excel

« Back to Events
Event:
Advanced Pro Forma Modeling Using Excel
Start:
November 10, 2014 8:00 am
End:
November 11, 2014 5:00 pm
Category:
Organizer:
David Mulvihill, Vice President, Professional Development
Phone:
202-624-7122
dmulvihill@uli.org
Updated:
August 20, 2014
Venue:
Executive Conference Center
Phone:
415-442-6770
Address:
55 4th Street, San Francisco, CA, 94103, United States

This popular ULI workshop is designed for real estate finance 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 multiple real estate investment scenarios quickly and effectively.

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.

Advanced Pro forma Modeling Agenda 2014

Principal Instructor

Roger Staiger
Managing Director
Stage Capital LLC


Roger Staiger is managing director for Stage Capital LLC, an international real estate advisory firm providing expertise to clients in areas of global portfolio management and asset repositioning. Staiger, through Stage Capital, has successfully repositioned over $500 million in distressed and inefficient real estate projects globally.

During his 20-year career, Staiger has worked in a number of industries at senior levels. He was managing director for Constellation Energy’s retail commodity division, CFO for Caruso Homes, and a portfolio manager for a large commingled pension fund in New York.

Staiger holds multiple degrees, including a BS in electrical engineering, an MBA in investments, an MA in international transactions, and an MS in finance. Currently, he holds faculty positions in the real estate departments at Georgetown University and Johns Hopkins University.

Staiger makes numerous capital market and economic presentations to organizations internationally. He also appears regularly on television and is often quoted in national periodicals and local newspapers.

Registration Fee

ULI Member: $695
Nonmember: $925
Govt./nonprofit Members: $595
Govt./nonprofit Nonmembers: $795

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

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.

Accommodations

Hotel accommodations are not included in the registration fee. If you would like to make hotel arrangements, please contact the appropriate hotel. There is not a hotel block for this program. You are advised to make your reservations as early as possible. Please note the Executive Conference Center is located within the Marriott Marquis Hotel building.

San Francisco Marriott Marquis Hotel
55 Fourth Street
San Francisco, CA 94103
888-575-8934
(Reference: American Management Association Business Rate)

Hotels near the Executive Conference Center

Parc 55 Wyndham San Francisco – Union Square Hotel
55 Cyril Magnin Street
San Francisco, CA 94102
800-697-3103
(Reference: American Management Association Preferred Rate)

The Westin San Francisco Market Street
50 Third Street
San Francisco, CA 94103
415-974-6400

Sir Francis Drake Hotel
450 Powell Street
San Francisco, CA 94102
800-227-5480 (Reference: American Management Association Rate)

Handlery Union Square Hotel
351 Geary Street
San Francisco, CA 94102
415-781-7800 (Reference: Corporate Travel Connection Program Rate)

The Stanford Court
05 California Street
San Francisco, CA 94108
415-989-3500
(Reference: American Management Association Rate)

+ Google Calendar

Program Highlights

  • Excel functions review
  • Pro Forma components – Deal Structure
  • Modeling fixed and variable mortgage loans
  • The construction and financing of a single-family housing subdivision
  • Multifamily Pro Forma construction
  • Risk quantification in the model
  • Using a partnership to raise an investment fund to finance multiple transactions
  • Visualization of quantitative data
  • Modeling investment waterfall distributions
  • Asset and portfolio analysis