Advanced Pro Forma Modeling Using Excel

« Back to Events
November 10, 2014 @ 8:00 am
November 11, 2014 @ 5:00 pm
Executive Conference Center
55 4th Street
San Francisco, CA 94103 United States
+ Google Map
David Mulvihill, Vice President, Professional Development


Netforum Event ID. You can find it here:
Display registration button?
Display registration button above event description?
Display registration button below event description?
Display attendees list link?

We are no longer accepting online registrations for this event.

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 San Francisco

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.


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
(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
(Reference: American Management Association Preferred Rate)

The Westin San Francisco Market Street
50 Third Street
San Francisco, CA 94103

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
(Reference: American Management Association Rate)

Program Highlights

  • Excel functions review
  • Pro Forma components – Deal Structure
  • Scaling techniques, e.g. 5-units to “n” units
  • Modeling fixed and variable mortgage loans
  • Amortization structures – Constant; Interest-Only; Custom
  • 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
  • Graphic depicture of quantitative data
  • Modeling investment waterfall distributions
  • Multiple chart types in Excel
  • Portfolio modeling and valuation techniques