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.
Technical support for all pro forma models must be purchased separately. Technical support is billed at $375 per hour. Click here to purchase technical support.
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|