Associate Break Even Analysis Worksheet
Unique worksheet designed to calculate the gross revenue required by an associate to produce the compensation desired for the associate. Appropriate for associate compensation using a percentage, not applicable for per diem or salary compensation.
Allows for entry of variables including the associate’s percentage of collections, desired associate base income, the practice collection rate, associate’s annual fixed & variable costs and more. Based on the variable data entered, the worksheet will calculate the gross revenue required from the associate. By changing various assumptions, “What If?” scenarios can be entered to determine the desired outcome.
Variable Data Used for Break Even Analysis Worksheet
|Associate % of Collections||Associate Desired Base Income|
|Practice Collection Rate||Annual Fixed Costs (Associate)|
|Annual Variable Lab Costs (Associate)||Annual Variable Other Costs (Associate)|
Worksheet requires Microsoft Excel version 2007 or higher.