May 5-13, 2014 1:30 to 3:30 p.m. ET
Building on the first pro-forma modeling course, this four-part online program will help further build the participants’ financial modeling and Excel skills. Students will learn more advanced Excel functions for valuation, amortization, rent roll, construction and permanent financing, construction draws, and cash flows.
In each session, students will receive concise direction in spreadsheet construction. At the end of the last session, students will have a complete pro-forma model that can be scaled further to include waterfalls, stochastic processes, portfolio analysis, and visual displays of results.
Each session of the workshop is designed to build on the previous one. Participants are expected to use learned skills to build individual sections and maintain the pace of the workshop. However, as in the first course, the completed stages will be distributed at the end of each session.
Can’t make a session live? No problem. Registrants will have access to the archive recording of each session for 60 days!
Students Will Learn
- Advanced 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 using an S-curve;
- How to quantify project cash flows; and
- Additional components to a development pro forma:
◾Scenario analysis to quantify risk.
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.
Govt./nonprofit member: $350
Govt./nonprofit nonmember: $465