(Sold Out) Pro Forma Modeling with Excel: Parts I, II, and III

Back to Events
Start:
December 3, 2018 @ 8:30 am
End:
December 4, 2018 @ 5:00 pm
Category:

Other

Display registration button?
No
Non-netforum Registration URL
http://netforum.uli.org/eweb/DynamicPage.aspx?webcode=EventInfo&Reg_evt_key=11a6b05d-e7be-4376-ac72-cbbec797c218
Display registration button above event description?
No
Display registration button below event description?
No
Display attendees list link?
No

Don’t miss this opportunity to attend one of ULI’s most popular programs. This 2-day program in Washington, DC will cover all the content from ULI’s popular online program in an in-person format.

Beginning from a blank spreadsheet, students will receive step-by-step instruction to guide students through the construction and manipulation of a basic multifamily investment pro forma. Building on this introductory model, students will learn more advanced Excel functions for valuation, amortization, rent roll, construction and permanent financing, construction draws, and cash flows.

Finally, the course will introduce student to the theory and practical construction of investment waterfalls for existing and new Microsoft Excel spreadsheet models. The waterfall is the method of distributing profits among partners within a transaction. In more complex transactions, profits are not distributed pari passu. (Pari passu is the proportional distribution of profits according to the percentage of capital invested for example, with an investor who provides 80 percent of the capital receiving 80 percent of the profit.)  Students will gain a theoretical understanding of what a waterfall is, as well as be exposed to the Microsoft Excel functions required to construct a waterfall. Students will then construct a waterfall from a blank spreadsheet that can be incorporated into all existing spreadsheet models.

Students are expected to bring a laptop computer loaded with Microsoft Excel to the program

Instructor

Roger Staiger
Owner
P(Gain), LLC
Washington, DC

Roger Staiger is owner of P(Gain), LLC, www.pgainllc.com, an international real estate investment and advisory firm with offices in Washington DC, Puerto Rico and Nevis. P(Gain), LLC develops, owns and manages investments in the DC metropolitan area and the Caribbean. Funded by the company, the P(Gain) Foundation provides University scholarships and grants for Nevisian graduating seniors. In addition, through the Roger P. Staiger Faculty Development Fund, Staiger personally provides grants for academic research studies. P(Gain), LLC, on a limited basis, will provide expertise to clients in areas of global portfolio management, real estate financial modelling and asset repositioning.

During his 20-year career, Mr. Staiger has worked in a number of industries at senior levels. He was Managing Director for a Fortune 500 Energy Company’s commodity division, CFO for America’s Best Mid-Sized Builder 2006, and a Senior Portfolio Manager for a large commingled pension fund in New York.

Staiger has earned multiple degrees including BS Electrical Engineering (Bucknell University), MBA Investments (George Washington University), MA International Transactions (George Mason University) and a MS Finance (George Washington University). Currently, Mr. Staiger holds or has held faculty positions in the real estate departments at Georgetown (Professor of Year, 2011), Johns Hopkins University (Senior Lecturer), and University of West Indies in Barbados. Staiger also holds a faculty position in the MS Finance programme at George Washington University.

Staiger provides numerous capital market and economic presentations to organizations internationally. He also appears regularly on television and is often quoted in national periodicals. Staiger is recognized globally as an expert in Financial Modelling having authored the leading text on the subject, Foundations of Real Estate Financial Modelling, Second edition, Routledge, 2018.

Meeting Location

ULI Global Headquarters
2001 L Street
Suite 200
Washington, DC 20036

Nearby Accommodations

Hyatt Place Washington DC
2121 M Street, NW
Washington, DC 20037
(202) 838 2222
(.4 miles)

Hilton Garden Inn
2201 M Street, NW
Washington, DC 20037
(202) 974-6010
(.4 miles)

Registration

ULI Member: $695
Nonmember: $925
Govt./nonprofit Members: $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.

  • Identifying the relevant project data required to begin crafting a pro forma
  • Basic components of an investment pro forma:
  • How to construct an amortization table to accommodate different loan types:
  • How to properly format a pro forma for an investment template
  • Excel skills required to build a development pro forma for a multifamily project of any size;
  • Graphically demonstrate the construction draw;
  • Develop the methodology for drawing construction dollars
  • How to quantify project cash flows
  • Rent roll, Construction financing, Construction draw, Permanent financing
  • Scenario analysis to quantify risk
  • Basic types of equity partnership distributions
  • The key inputs to the waterfall distribution from a joint venture agreement.
  • How to model variable-return distributions to the project sponsor and equity investor
  • Advanced valuation formulas in Excel
  • How to “bolt on” the waterfall to all existing pro forma models