Free Excel templates

A free physician compensation calculator in Excel: compare a guarantee with a wRVU rate over three ramps, with the tail and the break-evens

Guarantees, sign-on bonus, rates per wRVU, quality incentive, tail coverage and three ramps of wRVUs in; pay year by year, three-year totals, the employer's cost of the guarantee, percentiles and the break-evens out: one sheet of inputs, live formulas and five checks.

In the worked case a two-year guarantee leads a higher wRVU rate by $57,275 over three years at the base ramp, the rate pays $16,125 more in year 3, and it catches up 3.6 years later.

Get the template

One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other 212 free models.

Physician_Compensation_Calculator.xlsx (13 KB)

You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.

The book behind this model

This model goes with The Physician Compensation Handbook, which explains the method behind it, chapter by chapter.

Get the PDF edition → See the book

Want every model at once?

The Financial Model Library: all 213 models from this site in one download, organised by theme, plus two modelling books in DRM-free PDF (Financial Modeling from First Principles and Real Estate Financial Modeling).

Get the Library, $79 →

This free file stays free. Secure checkout by Stripe.

Not on Amazon: 24 paperbacks by Julian R. Sterling on insurance and retirement, printed on demand and shipped worldwide. Browse the bookshop →

What is in the file

3 sheets. Inputs can be changed; everything else is a formula, and the last sheet checks the figures against the book.

Inputs
Offer 1: guarantee for two years, sign-on bonus, rate per wRVU and quality incentive from year 3; offer 2: one-year guarantee, rate per wRVU and tail coverage; three ramps of wRVUs; benefits rate, collections per wRVU and a reference table to replace with your survey.
Offers
For each ramp: pay of each offer by year, the employer's cost and collections, pay per wRVU and percentiles, the guarantee's cost, three-year totals, the lead with and without the tail; the break-evens and the catch-up years.
Checks
Five tests on amounts, shares, wRVUs, rates and the reference table, and an All checks cell.

What the worked case returns

MeasureValue
Offer 1 (guarantee): three years of pay, base ramp$877,675
Offer 2 (wRVU rate): three years of pay, base ramp$820,400
Offer 1 ahead by, base ramp$57,275
Offer 1 ahead by, slow ramp$103,825
Offer 1 ahead by, fast ramp$16,925
Offer 2 pays more in year 3, base ramp$16,125
Guarantee above the year-3 formula, base ramp (employer's cost)$125,175
wRVUs at which the year-3 formula pays the guarantee4,853
Years after year 3 for offer 2 to catch up, base ramp3.6
Same, counting the tail5.1

Every figure is a teaching assumption of the book's fictional case, and its percentile table is fictional, not survey data. Whether pay is fair market value and whether a clause will hold are questions for counsel. Not legal, tax or valuation advice.

How to use it on your own case

  1. Type each offer: guarantee, sign-on bonus, rate per wRVU and any quality incentive.
  2. Enter three paces at which your practice could fill, in wRVUs for each of three years.
  3. Add the tail coverage you would buy on leaving a claims-made policy.
  4. Read pay by year and over three years, the catch-up years and the checks.

Questions people ask about it

Which pays more, a guarantee or a higher wRVU rate?

Over the first years the guarantee usually does; the rate catches up if you stay. The calculator gives the years it takes on your own figures.

What wRVUs should I enter?

Three ramps: a slow, a base and a fast pace of your practice filling. Ask the employer what established physicians in the department produce.

Does the calculator include benefits?

No. Value them for both offers or for neither; the book explains why an advantage given to one offer only distorts the result.

Is this template really free?

Yes. You enter an email address, the download opens at once, and you can leave the reader list in one click.

Go further

The free workbooks of The Physician Compensation Handbook go further: the full companion set, blank models and the worked cases of the book.

See the book and its free files →

Other free templates

This template goes with The Physician Compensation Handbook. See the book.