Ambulatory Surgery Center Pro Forma Model v2.0.1

Share:

This ASC pro forma Excel (.xlsx) model is intended for use with de novo ASC development projects and ASC 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 ASC pro forma at the bottom of this page when logged in.

List of 17 Video Tutorials (CLICK HERE TO EXPAND)
  1. Capital plan overview
  2. Capital plan: facility
  3. Capital plan: equipment
  4. Capital plan: IT
  5. Capital plan: soft costs
  6. Volume & Medicare reimbursement
  7. Commercial reimbursement
  8. Self pay rates for cosmetic surgery
  9. Operating room utilization
  10. Material costs
  11. Facility expense
  12. Staff plan & expense
  13. Professional services expense
  14. Minor equipment expense
  15. Equipment maintenance expense
  16. Capital expenditures
  17. Sources of funds

Speed Demo: 4 Minute Video

Model Contents

This ambulatory surgery center 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

17 ASC Video Tutorials – Subscribers Log-In to View

This content is restricted to subscribers.