ULI Online Learning Services Provided by Peach New Media
Peach New Media
1100 Circle 75 Parkway Suite 900
Atlanta, GA 30339
1 (866) 702 3278
support@peachnewmedia.com
Welcome!   Login

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.
Program Information
Program Date:
April 02, 2014
Pro forma Modeling with Excel: The Investment Pro forma Session 1
Speaker Information
Roger Staiger   [ view bio ]
Pro forma Modeling with Excel: The Investment Pro forma Session 2
Speaker Information
Roger Staiger   [ view bio ]
Pro forma Modeling with Excel: The Investment Pro forma Session 3
Speaker Information
Roger Staiger   [ view bio ]
Pro forma Modeling with Excel: The Investment Pro forma Session 4
Speaker Information
Roger Staiger   [ view bio ]
Individual topic purchase: Selected
Urban Land Institute
Attendance: 8.00
Share This
Preview
Preview Pro forma Modeling with Excel: The Investment Pro forma Session 1Preview Pro forma Modeling with Excel: The Investment Pro forma Session 1
Products
Streaming
Public Member: $350.00
Member: $375.00
Public Nonmember: $465.00
Full Price: $495.00