This physician practice pro forma Excel (.xlsx) model is intended for use with start-up physician practices. Modifications may be necessary to use it for mergers and acquisitions.
The model is pre-populated with example inputs. Users must update the input fields with all of their own specific value inputs for wRVU production, collections, salaries, support staff, office rent, and other facility expenses.
HTA does not provide technical support. You must be proficient in Excel to use this model, but subscribers can access 11 video tutorials for the physician practice pro forma at the bottom of this page when logged in.List of 11 Video Tutorials (CLICK HERE TO EXPAND)
- Capital plan overview
- Capital plan: facility
- Capital plan: equipment, furniture & IT
- Capital plan: soft costs
- Volume & Medicare reimbursement
- Commercial reimbursement
- Self pay rates
- Facility expense
- Staff plan & expense
- Capital expenditures
- Sources of funds
HCTadvisor licenses access to the model and video tutorials for 12-month subscription periods.
This physician practice center pro forma model includes the schedules below.
|Capital Plan||Physician Data Input||Volume, Revenue, Material Projections|
|Income Statement||Projected Expenses||Staff Plan|
|Capital Expenditures||Cash Flow Statement||Equipment Loans|
|Balance Sheet||Working Capital||Building Loans|