Medical loss ratio rebate from the shortfall against the standard

Signature

R = max(0, (P - T) * (MLR_req - MLR))

Function

Administrative cost ratio function for payers and health systems

Computational function

• Computational function: insurer annual figures to medical loss ratio rebate

  Takes the items an insurer reports for a year, earned premium, taxes and licensing and regulatory fees, incurred claims and quality improvement expenditure, together with the market standard, and returns the rebate in the order the regulation sets. It computes the medical loss ratio with HE-FM-ACR-002, rounds it to three decimal places as 45 CFR 158.221(c) requires, and only then applies the rebate formula HE-FM-ACR-004. The inputs therefore differ from those of the rebate formula, which takes the rounded ratio as given, and the rounding step changes the result.

  Inputs and outputs: P: Earned premium for the year; required, above T. Unit: currency, for example millions of dollars.; T: Federal and state taxes and licensing and regulatory fees; required, zero or above. Unit: currency.; C: Incurred claims for clinical services; required, zero or above. Unit: currency.; Q: Expenditure on activities that improve health care quality; required, zero or above. Unit: currency.; MLR_req: Standard for the market, 0.85 for large group or 0.80 for small group and individual unless a state sets a higher one; required. Unit: proportion.; MLR: Medical loss ratio rounded to three decimal places, returned. Unit: proportion.; R: Rebate owed for the year, returned. Unit: currency.

  Assumption: One year of fully credible experience, with no risk adjustment, risk corridor, reinsurance or fraud recovery adjustment. The reported ratio aggregates three years of data under 45 CFR 158.220 and adds a credibility adjustment where one is due, which this function leaves out.

  Worked example (Illustrative insurer under the large group standard): The article's insurer has a ratio of 392 over 480, about 0.81667, rounded to 0.817, and owes a rebate of $15.84 million. P = 500; T = 20; C = 382; Q = 10; MLR_req = 0.85; MLR = 0.817; R = 15.84

  Worked example (After the cut in claims control): Claims of $394 million give a rounded ratio of 0.842 and a rebate of $3.84 million. P = 500; T = 20; C = 394; Q = 10; MLR_req = 0.85; MLR = 0.842; R = 3.84

  Worked example (Individual market standard met): Under the 80% standard the same insurer owes nothing, a limiting case that checks the floor at zero. P = 500; T = 20; C = 382; Q = 10; MLR_req = 0.80; MLR = 0.817; R = 0

  Excel: =LET(m,ROUND((Claims+QualityImp)/(Premium-Taxes),3),MAX(0,(Premium-Taxes)*(Standard-m))) With the reported items in named cells Premium, Taxes, Claims and QualityImp and the market standard in Standard, the formula returns the rebate in Excel 2021 or Microsoft 365. Inside LET, m is the rounded ratio, which can also be shown in its own cell with the ROUND part alone.

  R: mlr_rebate <- function(premium, taxes, claims, qi, standard) { m <- round((claims + qi) / (premium-taxes), 3); c(mlr = m, rebate = max(0, (premium-taxes) * (standard-m))) } Returns the rounded ratio and the rebate for one issuer; pmax in place of max vectorises it across issuers.

  Python: def mlr_rebate(premium, taxes, claims, qi, standard): m = round((claims + qi) / (premium-taxes), 3); return m, max(0, (premium-taxes) * (standard-m)) Returns the rounded ratio and the rebate and needs no imports.

  Test (Rebate brings the issuer up to the standard): If the rounded ratio meets the standard the rebate is zero; otherwise the rounded ratio plus the rebate as a share of premium after taxes and fees equals the standard. Expected result: TRUE. Excel check: =IF(ReportedMLR>=Standard,Rebate=0,ABS(ReportedMLR+Rebate/(Premium-Taxes)-Standard)<1E-9)

  Test (Rounded ratio within half a unit of the third decimal): The rounded ratio differs from the unrounded ratio by no more than 0.0005. Expected result: TRUE. Excel check: =ABS(ReportedMLR-(Claims+QualityImp)/(Premium-Taxes))<=0.0005

  Common error (Using the unrounded ratio in the rebate): The unrounded ratio for the article's insurer, about 0.81667, gives a rebate of $16.00 million under the large group standard, against $15.84 million from the rounded 0.817 that the regulation uses.

  Source: Code of Federal Regulations. Title 45, section 158.221, paragraph (c), which requires the ratio to be rounded to three decimal places, and section 158.240, paragraph (c)(1), which multiplies premium after taxes and fees by the difference between the required ratio and the issuer's ratio as calculated under section 158.221. Current text checked 1 October 2026.

  MLR = round((C + Q) / (P - T), 3); R = max(0, (P - T) * (MLR_req - MLR))

Try this function

Implementations

• Excel

  Medical loss ratio rebate in one cell

  Excel returns the rebate from named cells holding earned premium, taxes and fees, the market standard and the issuer's rounded ratio.

  =MAX(0,(Premium-Taxes)*(Standard-ReportedMLR))

Assumptions

• Rounded medical loss ratio entering the rebate

  MLR enters already rounded to three decimal places, because 45 CFR 158.240 takes the ratio as calculated under 158.221. Using the unrounded ratio changes the rebate.

• Simplified rebate base without risk programme adjustments

  P minus T stands for premium after taxes and fees. The regulation also accounts for risk adjustment, risk corridors and reinsurance and uses three years of data, which the article's example ignores.

Worked examples

• Rebate for the illustrative insurer under the large group standard

  Against the 85% standard the article's insurer falls short by 0.033, so the rebate on $480 million of adjusted premium is $15.84 million.

  P = 500; T = 20; MLR_req = 0.85; MLR = 0.817; R = 15.84

• Rebate after the illustrative cut in claims control

  After the cut in claims control the ratio is 0.842 and the rebate falls to $3.84 million. The margin after rebate rises from $12.16 million to $17.16 million, although covering the same members costs $7 million more.

  P = 500; T = 20; MLR_req = 0.85; MLR = 0.842; R = 3.84

• No rebate for the illustrative insurer under the individual market standard

  In the individual market the standard is 80%, and a ratio of 0.817 meets it, so the rebate is zero.

  P = 500; T = 20; MLR_req = 0.80; MLR = 0.817; R = 0

Common errors

• Computing the medical loss ratio rebate on gross premium

  Multiplying the shortfall by earned premium before taxes and fees overstates the rebate: 500 times 0.033 gives $16.50 million rather than $15.84 million for the article's insurer.

• Leaving out the floor at zero in the rebate

  Without the max, an issuer above the standard shows a negative rebate. Under the 80% individual market standard the article's insurer would show a negative rebate of $8.16 million, which a spreadsheet total would then net off against rebates owed elsewhere.

Sources

• Federal medical loss ratio rebate calculation

  Code of Federal Regulations. Title 45, section 158.240: rebating premium if the applicable medical loss ratio standard is not met. Paragraph (c)(1) sets the rebate as premium revenue after federal and state taxes and licensing and regulatory fees, multiplied by the difference between the required ratio and the issuer's ratio as calculated under section 158.221. Current text checked 1 October 2026.

  View source →

• Federal medical loss ratio standards by market

  Code of Federal Regulations. Title 45, section 158.210: minimum medical loss ratio, with rebates owed below 85 percent in the large group market and below 80 percent in the small group and individual markets, subject to a higher state standard under section 158.211. Current text checked 1 October 2026.

  View source →

Canonical Identity