Associate Break Even Analysis Worksheet

$49.00

Excel Worksheet for determining the gross revenue required by an associate to produce a desired associate compensation, cover practice costs and provide a margin ROI for the employer dentist.

Description

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

Related Products