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. 

Pro Forma Modeling a Single-Family-Home Community Session 1

The program will begin by reviewing the structure for a residential builder, including lot take-down (the program assumes use of finished lots), schedule, and valuation. Data sheets will be provided for use in later stages of development for this program to ease data entry and better facilitate model building.

Session Highlights:

• Overview of the residential builder pro forma
• Review of consistent naming conventions
• Completed house-cost summary sheet (one page)
• Understanding of what and how the model will be scaled and built upon over the next three sessions

Speaker Information

Roger Staiger   [ view bio ]

Pro Forma Modeling a Single-Family-Home Community Session 2

The second session will focus on development of the schedule for lot take-downs and house starts and completions. The percentage draw for bank lending and for completion will be modeled in a schedule sheet.

Session Highlights:

• Understanding of the schedule characteristics for a residential builder with lot take-down and purchase
• Understanding that home construction can be summarized as to percentage of draws and completions
• Understanding that the schedule is a principal determinant of value in a residential project
• A developed ability to draw multiple elevations and house types in the residential builder pro forma model

Speaker Information

Roger Staiger   [ view bio ]

Pro Forma Modeling a Single-Family-Home Community Session 3

This session will focus on developing the economic pages for the pro forma model. The revenue/expense page summary will be constructed. In addition, the income statement and cash flow (in/out) pages will be developed from which valuations will be completed. The data pages provided earlier will be incorporated into the model at this point. These pages include hard-cost house pricing, recordation table, a sales and marketing budget, and a production overhead budget.

Session Highlights:

• Understanding of the basic components of revenue and expense cash flows for a residential builder
• Understanding of the structure and incorporation of data pages and how these are incorporated into a residential pro forma model 
• Understanding and completion of the mechanics of the total model, which includes the rollover structure for debt, i.e., a revolving facility
• Clear demonstration of how to scale the existing model to a 500-plus-unit planned unit development (PUD)

Speaker Information

Roger Staiger   [ view bio ]

Pro Forma Modeling a Single-Family-Home Community Session 4

The final session will focus on the complete cash flow for the project from "cradle to grave." A final valuation summary will be completed, demonstrating sensitivities to lot take-down velocity. The model will be reviewed in total, with each segment addressed to demonstrate how capital is used.

Further, demonstration of how to scale this model to a 500-plus-unit PUD will be provided. Additional items of expansion and complexity (e.g.. waterfalls) will be discussed as well.

Session Highlights:

• A completed scalable and modular residential builder pro forma model that includes a lot take-down schedule, house-cost summary, and revolving credit facility
• Understanding of the complete pro forma structure for a residential builder
• Understanding of how to analyze and add scalability to an existing model
• Understanding of how to scale the existing model further to include investment waterfall distributions, stochastic processes, portfolio analysis, and visual displays of results (this will be discussed but models will not be provided)

Speaker Information

Roger Staiger   [ view bio ]

Individual topic purchase: Selected