This surgical hospital pro forma Excel (.xlsx) model is intended for use with de novo surgical hospital development projects and renovation projects. It can be adapted for acquisitions with minor modifications.
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.
You must be proficient in Excel to use this model. HTA does NOT provide technical support for Excel, but subscribers can access 17 video tutorials for the surgical hospital pro forma at the bottom of this page when logged in.[expand title=”List of 17 Video Tutorials (CLICK HERE TO EXPAND)“]
- Capital plan overview
- Capital plan: facility
- Capital plan: equipment
- Capital plan: IT
- Capital plan: soft costs
- Volume & Medicare reimbursement
- Commercial reimbursement
- Self pay rates for cosmetic surgery
- Operating room utilization
- Material costs
- Facility expense
- Staff plan & expense
- Professional services expense
- Minor equipment expense
- Equipment maintenance expense
- Capital expenditures
- Sources of funds
HCTadvisor licenses access to the model and video tutorials for 12-month subscription periods.
Speed Demo: 4 Minute Video
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|