Surgical Hospital Pro Forma Model v1.9.1


This surgical hospital pro forma Excel (.xlsx) model is intended for use with de novo surgical hospital development projects and renovation projects.

The model is pre-populated with example inputs. Users must update the input fields with all of their own specific value inputs for case volumes, reimbursement, material costs, staff FTEs, staff salaries, and facility expenses.

HTA does not provide technical support.  You must be proficient in Excel to use this model.


This surgical hospital pro forma model includes the schedules below.

Capital Plan Physician Data Input Volume, Revenue, Material Projections
O.R. Utilization Analysis Projected Expenses Staff Plan
Income Statement Cash Flow Statement Balance Sheet
Capital Expenditures Working Capital Equipment & Building Loans