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|