October 19, 21, 26, and 28 1:30 to 3:30 p.m. ET
This introductory course is a four-part online workshop that
guides students through the construction and manipulation of a basic
multifamily investment pro forma. The program is geared toward individuals who
have never completed a pro forma from scratch. Starting from a blank
spreadsheet, students will receive step-by-step direction in the creation of
this investment pro forma. At the conclusion of the last session, participants
will have completed their own investment pro forma and will have gained a new
appreciation for how valuation and investment decisions are made. Each session
of the workshop is designed to build on the previous one, and each participant
will have a completed pro-forma model at the conclusion. Participants are
expected to use learned skills to independently build individual sections of
the model. However, the completed stages will be distributed at the end of each
session.
Students Will Learn
- How to identify the relevant project data required to begin crafting a pro forma;
- Basic to intermediate Excel skills needed to model an industry-accepted pro forma;
- Basic components of an investment
pro forma:
- Inputs
- Amortization
- Pro-forma income cash flows
- Valuation - How to construct an amortization table to accommodate three loan types: Constant Payment Mortgage (CPM), interest only (IO), and custom amortization and;
- How to property format a Pro Forma for an Investment Template.
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. |