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
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.
ULI Global Headquarters
2001 L Street
Washington, DC 20036
Hyatt Place Washington DC
2121 M Street, NW
Washington, DC 20037
(202) 838 2222
Hilton Garden Inn
2201 M Street, NW
Washington, DC 20037
ULI Member: $695
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.