Pro Forma Modeling with Excel

Back to Events
Start:
September 16 @ 8:30 am
End:
September 17 @ 5:00 pm
Category:
Venue:
Walter E. Washington Convention Center
Address:
801 Mt Vernon Pl NW
Washington, DC, DC 20001 United States
Organizer:
David Mulvihill, Vice President, Professional Development
Email:

Other

Display registration button?
Yes
Non-netforum Registration URL
http://netforum.uli.org/eweb/DynamicPage.aspx?webcode=EventInfo&Reg_evt_key=985b26c3-9ed2-496e-8ca0-b6fb18a373eb
Display registration button above event description?
Yes
Display registration button below event description?
Yes
Display attendees list link?
No

Join ULI for this special Monday-Tuesday Pre-Fall Meeting Workshop.

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.

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.

Accommodations

Accommodations are not included in the registration fee. Information regarding available nearby accommodations will be provided upon registration to the workshop.

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