Sensitivity Data Spreadsheet to Determine Optimal Pay Rates/ Benchmarks for Productivity for Staff Therapists
One of the most common questions I get from therapists hiring other therapists, especially the first hire is how to determine how much they can actually afford to pay the therapist, what is the minimum level of productivity needed to break even, and then of course to hopefully be profitable.
A sensitivity data spreadsheet is a great tool to help therapists make informed decisions about this. Generally, a Sensitivity analysis in Excel lets you vary the assumptions in a model and look at the output under a range of different outcomes. For private practices, we know there are many variables that need to be examined in order to see the minimum benchmark of productive sessions needed for a employed therapist to be profitable for a practice owner.
This spread sheet gives you the ability to input and change several variables – # of productive sessions, # of days worked, average bill rate per session, average pay rate per session, average cost of different benefits and taxes so that you can make an informed decision about what you can afford to offer therapists to get beyond a break-even point.
All of the data in the yellow cells can be altered. Sample numbers are intentionally left in. Best advice is to download the spreadsheet to keep this as an original and then make a copy where you can input your data.
Terms and Conditions
By purchasing this form, we are granting you the non-exclusive use of this material. You may not re-sell or otherwise transfer the material to another therapist outside of your own practice. By virtue of submitting payment for the course, you hereby are agreeing to the following:
- Digital Product Usage -After purchasing the form, you will be given immediate access to it and will have lifetime access to use it for your own personal use and business use.2. Refund Policy- Due to the nature of the form being immediately accessible upon purchasing, no refunds of any fees or other amounts paid by you in connection with the course will be allowed under any circumstances.3. Warranties and Liability -Every effort is made to ensure that the form is accurate and fit for the use by purchasers However, we take no responsibility whatsoever for the suitability of the form and provide no warranties as to the function or use of the form, whether express, implied or statutory, including without limitation any warranties of merchantability or fitness for particular purpose. You agree to indemnify the creator against all liabilities, claims, demands, expenses, actions, costs, damages, or loss arising out of any breach of these terms and conditions. The creator shall not be liable to you or any third party for consequential, indirect, special or exemplary damages including but not limited to damages for loss of profits, business or anticipated benefits whether arising under tort, contract, negligence or otherwise whether or not foreseen, reasonably foreseeable or advised of the possibility of such damages. By virtue of submitting payment for the form, the purchaser agrees to abide by the above terms and conditions.