Pro forma Modeling
Collapse Excel Tips and Shortcuts for Real Estate Professionals
Do you know how to use Excel to build quick models but would like to learn how to reuse what you build? The biggest challenge for intermediate Excel users is to learn how to build models that are not only powerful and customized for a particular project, but also contain reusable components. This information-packed webinar will present tips, shortcuts, and strategies so that you can reuse what you build in multiple models and save substantial time.

Attendee Takeaways:
  • Learn how to structure your financial models to maximize efficiency
  • Learn how to build a library of reusable tools
  • Learn how to best plan your “attack” when designing a financial model
Formats Available: Streaming
Original Program Date: October 18, 2016
On-Demand Release Date: Available Now
MORE INFOMORE INFO Excel Tips and Shortcuts for Real Estate Professionals
Collapse Pro forma Modeling with Excel Part II: Construction Draws and Rent Roll (October and November 2018 On Demand)


Formats Available: Streaming
Original Program Date: October 23, 2018
On-Demand Release Date: Available Now

Approved Credit:
  • ULI: 8.00 hours Attendance

  • MORE INFOMORE INFO Pro forma Modeling with Excel Part II: Construction Draws and Rent Roll (October and November 2018 On Demand)
    Collapse Pro Forma Modeling with Excel: Investment Waterfall Distributions (November 2018 On Demand)
    Formats Available: Streaming
    Original Program Date: November 14, 2018
    On-Demand Release Date: Available Now

    Approved Credit:
  • ULI: 4.00 hours Attendance

  • MORE INFOMORE INFO Pro Forma Modeling with Excel: Investment Waterfall Distributions (November 2018 On Demand)
    Collapse Pro forma Modeling with Excel: The Investment Pro forma (September 2018 On Demand)
    Formats Available: Streaming
    Original Program Date: September 19, 2018
    On-Demand Release Date: Available Now

    Approved Credit:
  • ULI: 8.00 hours Attendance

  • MORE INFOMORE INFO Pro forma Modeling with Excel: The Investment Pro forma (September 2018 On Demand)
    Collapse Hotel Pro Forma Development for the Beginner
    Held over four sessions, this new online workshop will guide students step-by-step through the construction of a development pro forma for a mid-size hotel property. Beginning with a blank spreadsheet, the program will take students through the entire project from development through sale. Students will be instructed in the basic differences between a hotel pro forma model and other asset classes such as office or multifamily and the corresponding inputs and structure. At the end of the last session, participants will have completed their own hotel pro forma that will actively link to a cash flow page, allowing students to understand the basic valuation of a hotel and how investment decisions are made. 

    Each session of the workshop is designed to build on the previous one with each participant having a completed pro forma model at the conclusion. Participants will use learned skills to independently build individual sections and maintain the pace of the workshop. However, to avoid the possibility of anyone falling behind, the completed stages will be distributed the evening of each completed workshop. At the conclusion of the workshop, the instructor’s copy will be distributed, which will provide, at a minimum, a working hotel pro forma model for each participant.
    Formats Available: Streaming
    Original Program Date: March 28, 2013
    On-Demand Release Date: Available Now
    MORE INFOMORE INFO Hotel Pro Forma Development for the Beginner
    Collapse Pro Forma Modeling a Single-Family-Home Community
    Held over four sessions, this new online live program will focus on developing a single-family residential builder pro forma. The program will model and value a 50-lot single-family-home community. The model will assume the developer/builder is working with finished lots. Unlike a typical commercial model, this model does not include construction of an amortization table; instead, a residential builder uses a rolling facility. This construct will be explained in detail in session three of the course. 

    Each session of the workshop will build on the previous one, with each participant having a completed pro forma model at the conclusion. 

    Formats Available: Streaming
    Original Program Date: July 16, 2013
    On-Demand Release Date: Available Now
    MORE INFOMORE INFO Pro Forma Modeling a Single-Family-Home Community