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.
Program Information
Program Date:
March 28, 2013
Hotel Pro Forma Development for the Beginner Session 1
The class will begin with a blank spreadsheet. Students will assign cell colors and design borders to separate areas, and create sections for the inputs for the basic hotel model. The amortization page will be provided and reviewed as part of this session.

Session Highlights
  • Understanding the basic hotel model to be developed
  • Understanding of the basic difference between a hotel model and other asset classes, e.g. multifamily and office
  • Understanding of the pro forma overview (structural overview) with the development piece
  • Understanding for developing input and amortization page
  • Major sections for inputs --sources/uses, revenue per available room (RevPAR), expenses, financing structure, operating/finance concerns
Speaker Information
Roger Staiger   [ view bio ]
Hotel Pro Forma Development for the Beginner Session 2

Starting with the completed structure from the first session, participants will develop the Construction Draw Page and Development Budget. Participants will understand the general structure of a development budget and how to spread/allocate costs.

Session Highlights

  • Structuring development budget
    • Components of development and methodology of how to model development timing, i.e. draw page
  • Basic functions, “sum”, “subtotal”, “product”, and the use of arrays
  • Cost allocation and distribution by percentage
    • Ability to identify critical path items which impact budget and schedule
Speaker Information
Roger Staiger   [ view bio ]
Hotel Pro Forma Development for the Beginner Session 3
In this session participants will develop the pro forma income page for the hotel project down to net income.  Participants will understand how to link assumptions and escalate costs over time, and understand basic functions and functionality, such as linking, adding/subtracting, and the subtotal function.

Session Highlights
  • Linking cells directly and through naming convention
  • Structuring cash flow for a project, e.g. revenue, expense
    • Understanding how cash flows enter and exit hotel model, i.e. inflow/outflow understanding
  • Determining cash flow before debt service
  • Determining cash position at points in time throughout the project
    • Development, lease-up and operations
Speaker Information
Roger Staiger   [ view bio ]
Hotel Pro Forma Development for the Beginner Session 4
In the final session participants will create a cash flow page for the entire project, i.e. development through sale.  Pulling it all together, participants will be valuing the cash flows for investment decisions. Linking the pro forma page to the bottom of the input/summary page and valuing cash flows, students will understanding basic valuation of a hotel and how investment decisions are made.

Session Highlights
  • Valuation (Debt Service Coverage Ratio; Cash-on-Cash; Debt Yield)
  • Cash Uses (Draw down and recovery)
  • Net Present Value (NPV function)
  • Internal Rate of Return (IRR function)
    • Levered and Unlevered
  • Modified Internal Rate of Return (MIRR function)
  • Advanced Valuation functions (XIRR, XNPV)
  • Bifurcation of cash flows (Operations versus Reversion)
  • How to present the data to a lender and/or equity partner
  • Analyze hotel economics and how RevPar is key component
Speaker Information
Roger Staiger   [ view bio ]
Individual topic purchase: Selected
Share This
Public Member: $350.00
Member: $375.00
Public Nonmember: $465.00
Full Price: $495.00