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.
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|