Payer Contract Rate Analysis Calculator

Why is my average percent of Medicare wrong?

Because averaging percentages treats a code you bill three times a year the same as one you bill eight thousand times, and the small ones are usually the extreme ones.

Percent of Medicare is the industry's common unit of comparison: divide your contracted allowed amount by the Medicare allowed amount for your locality. Do it per code and you get a column of percentages. Average that column and you get a number that describes your fee schedule rather than your practice.

The calculator's defaults show the damage. The simple average across six codes is 138.68% of Medicare. The volume-weighted figure — total contracted revenue divided by total Medicare-equivalent revenue — is 109.36%. That's a 29.32 percentage point gap.

The culprit is venipuncture. CPT 36415 pays $8.50 against a $3.10 Medicare rate, which is 274% of Medicare and looks spectacular in the column. It also represents 0.93% of your Medicare-equivalent revenue, because the Medicare rate behind it is three dollars.

The industry guidance is explicit about the consequence: if this were a real negotiation, you should be negotiating up from the weighted figure, not the simple average. Walk in claiming 138% when your paid claims say 109% and the payer — who has the same data — knows immediately that you haven't done the analysis.

Normalise across your fee schedule by the revenue each code produces. That's the only number worth arguing from.

What does a "12% rate increase" from a payer actually produce?

Almost never 12%. The calculator's defaults show a payer offering rate increases that average 12.49% across six codes and produce 2.97% of additional revenue.

Look at where the increases sit. Venipuncture goes up 29.41%, the ECG 25.00%, the joint injection 15.49% — and the two office visit codes that generate 84% of the contract's revenue go up 1.52% and 1.42%.

The arithmetic is unforgiving. Applied literally, a 12.49% increase on $2,040,920 of current revenue would be worth $2,295,894. The actual proposal produces $2,101,540. That's $194,354 of revenue that will not arrive.

The fix is the one every contracting guide recommends: multiply the rate change for each code by the number of times you billed it in the past twelve months, and sum. That's your real revenue impact, not the headline percentage.

None of this requires assuming bad faith. Payers build offers from their own cost models, and concentrating increases in low-utilisation codes is cheap for them and looks generous on paper. But it means the letter and the bank deposit are different documents, and only one of them matters.

Run the volume weighting before you respond, and quote the revenue number back.

Why doesn't the percent of Medicare in my contract match reality?

Because the figure on page one usually applies to a listed schedule of codes, not to the mix you actually bill.

This is a documented pattern. One practice manager believed her group was at 120% of Medicare with its largest commercial payer — the contract said so. Running actual paid claims against current Medicare rates code by code, the real number was 103%. Nothing had been breached; the 120% applied to a listed schedule of 40 codes.

The calculator's defaults reproduce it: a contract stating 120%, paid claims producing 109.36% — a 10.64 point gap.

Three mechanisms cause it, and all three are ordinary rather than sinister. The listed schedule covers a subset of codes and everything else falls to a default. Medicare rates move annually while your contracted dollar amounts don't, so a percentage agreed three years ago has drifted. And the "lesser of billed charges or contracted rate" clause quietly caps any code where your charge master hasn't kept pace.

That last one is worth checking directly. If your fee schedule lists a charge below the contracted allowed amount for any code, you're being paid your charge, not the contract rate, and no one will tell you.

Always rely on your billing system and your own data to determine your revenues. The contract describes an intention; the remittance describes what happened.

How do I know if a payer is worth keeping at all?

Compare their volume-weighted rate against your break-even percent of Medicare — the point below which their patients cost you more than they pay.

The calculator derives it from your operating cost allocated to that payer's volume, divided by the Medicare-equivalent revenue that volume represents. At the defaults that's 109.05% of Medicare.

The current contract sits at 109.36%. You are 0.31 points above water — effectively working for free on this payer. The proposed rates lift you to 112.61%, which is a real improvement and still thin.

Then look underneath the average. At the proposed rates, two of six codes remain below break-even, and one of them is 99213 — the highest-volume code in the contract at 8,400 claims a year. You'd be gaining margin overall while losing money on your single most common service.

That's the analysis worth taking into the room. Not "we'd like a raise," but "your proposed rate on 99213 is below our cost to deliver it, here is the cost per unit, and here is what your competitor pays." A cost-per-RVU or cost-per-encounter figure turns a request into an argument.

The wider benchmark matters too. Commercial reimbursement for professional services nationally averages around 148% of Medicare, though that varies enormously by specialty and geography — use a specialty-adjusted figure rather than the headline. At a 125% benchmark, the defaults show a $231,209 gap between the offer and market.

What data do I need, and what does this not cover?

Four columns for your top codes: annual volume, the Medicare allowed amount for your locality, your current contracted allowed amount, and the proposed rate. Volume comes from your billing system, Medicare rates from the physician fee schedule lookup for your geographic locality, and contracted rates from your remittances rather than the contract document.

Start with the codes that generate the most revenue rather than trying to cover everything. Revenue loss concentrates in specific codes, and a two-point increase on a code you bill 6,000 times funds a hire while a twenty-point increase on one you bill forty times funds lunch.

Three things this doesn't model.

• Everything in the contract that isn't a rate. Timely filing windows, appeal rights, carve-outs, modifier policies, prior authorisation burden and the administrative cost of working a claim. A high-volume payer with acceptable rates and difficult claims processes can cost more than the fee schedule suggests.
• Payer mix and network effects. Dropping a payer doesn't just remove their revenue; it may remove patients who would otherwise fill capacity, and network adequacy rules cut the other way if you cover an underserved geography.
• Transparency in Coverage data. Machine-readable files now contain competitors' negotiated rates, but the files routinely exceed 100 GB and only about 18% of medical groups use them in negotiations. If you can get parsed comparisons, they change the conversation entirely. This calculator gives you your own position; it can't tell you your neighbour's.

Run the four columns for your top codes and you have your own position in the room, backed by your paid claims rather than the payer's letter.