Signature
MLR = (C + Q) / (P - T)
| Inputs | Definition | Unit |
|---|---|---|
C | Incurred claims for clinical services provided to members, excluding amounts paid to third party vendors for administration such as claims processing and utilisation management | currency, for example millions of dollars |
Q | Expenditure on activities that improve health care quality, as defined in 45 CFR 158.150 | currency |
P | Earned premium, all monies paid by policyholders or subscribers as a condition of receiving coverage | currency |
T | Federal and state taxes and licensing and regulatory fees, deducted from earned premium | currency |
MLR | Medical loss ratio of the issuer for the reporting year, reported rounded to three decimal places | proportion, usually reported as a percentage |
|---|
Function
Administrative cost ratio function for payers and health systems
Maps the administrative cost of a payer or financing system over a period, and a measure of the money it handles over the same period, to the share of that money used for administration rather than claims or care. The general form allows any denominator. The applied formulas fix it as premium revenue, total payer spending or current health expenditure, and set the ratio beside the United States medical loss ratio, its complement and the rebate that follows from it. Notation follows the Administrative Cost Ratio article.
Try this function
Implementations
Excel
Medical loss ratio rounded to three decimals in one cell
Excel returns the ratio rounded as the regulation requires, from named cells Claims, QualityImp, Premium and Taxes (taxes and licensing and regulatory fees).
=ROUND((Claims+QualityImp)/(Premium-Taxes),3)
Assumptions
Single year without credibility or risk programme adjustments
The formula is applied to one year of data with fully credible experience, and risk adjustment, risk corridors, reinsurance and the fraud recovery adjustment are ignored. The reported ratio aggregates three years of data under 45 CFR 158.220 and adds a credibility adjustment where one is due, so a full calculation can differ.
Medical loss ratio rounded to three decimal places
The regulation rounds the ratio to three decimal places, and the rounded value is the one compared with the standard and used in the rebate.
Worked examples
Medical loss ratio of the illustrative insurer
Claims of $382 million and quality improvement of $10 million over adjusted premium of $480 million give a ratio of about 0.817 (81.7%). The insurer meets the 80% individual market standard, so no rebate is due.
C = 382; Q = 10; P = 500; T = 20; MLR = 0.817
Medical loss ratio after the illustrative cut in claims control
After the cut in utilisation review and fraud prevention, claims rise to $394 million and the ratio rises to about 0.842 (84.2%), an apparent improvement although the cost of covering the same members has risen.
C = 394; Q = 10; P = 500; T = 20; MLR = 0.842
Common errors
Dividing by gross premium in the medical loss ratio
Leaving taxes and fees in the denominator gives 392 divided by 500, about 0.784, for the article's insurer. The ratio then falls below the 80% individual market standard and a rebate appears due when none is.
Counting utilisation review or fraud prevention as quality improvement
Activities designed mainly to contain costs, all retrospective and concurrent utilisation review, fraud prevention, provider network contracting and marketing are non-claims costs under 45 CFR 158.150 and 158.160. Moving them into Q raises the ratio and can hide a shortfall. Prospective drug utilisation review aimed at adverse drug interactions is the exception and does count as quality improvement.
Sources
Federal medical loss ratio numerator, denominator and rounding rule
Code of Federal Regulations. Title 45, section 158.221: formula for calculating an issuer's medical loss ratio. Paragraph (b) sets the numerator as incurred claims plus expenditure on activities that improve health care quality; paragraph (c) sets the denominator as premium revenue excluding federal and state taxes and licensing and regulatory fees, after risk adjustment, risk corridors and reinsurance, and requires rounding to three decimal places. Current text checked 1 October 2026.
Federal rules excluding cost containment from quality improvement
Code of Federal Regulations. Title 45, section 158.150: activities that improve health care quality. Paragraph (c) excludes activities designed primarily to control or contain costs, all retrospective and concurrent utilisation review, fraud prevention, provider contracting and marketing; paragraph (b) includes prospective prescription drug utilisation review aimed at adverse drug interactions. Current text checked 1 October 2026.
Canonical Identity
Stable URI · Machine-readable · Resolvable · CC BY 4.0