# CMS Actuarial Value (AV) Calculator 2027 Site-served catalog guide. Service API contracts remain at catalog.formualizer.com. - [Workbook page](https://formualizer.com/catalog/cms-av-calculator) - [Subject guide (text)](https://formualizer.com/catalog/subjects/healthcare/llms.txt) - [Subject guide (JSON)](https://formualizer.com/catalog/subjects/healthcare/llms.json) - [Publisher page](https://www.cms.gov/cciio/resources/regulations-and-guidance) - [Ports (text)](https://formualizer.com/catalog/agents/cms-av-calculator/2027/ports/llms.txt) - [Ports (JSON)](https://formualizer.com/catalog/agents/cms-av-calculator/2027/ports/llms.json) - [OpenAPI](https://catalog.formualizer.com/v1/models/cms-av-calculator/2027/openapi.json) - [TypeScript types](https://catalog.formualizer.com/v1/models/cms-av-calculator/2027/types.d.ts) - [SheetPort manifest](https://catalog.formualizer.com/v1/models/cms-av-calculator/2027/fio.yaml) - [Evaluate endpoint (POST)](https://catalog.formualizer.com/v1/models/cms-av-calculator/2027/evaluate) - [MCP endpoint (POST)](https://catalog.formualizer.com/v1/mcp) ```json { "schemaVersion": 1, "kind": "workbook", "key": "cms-av-calculator/2027", "title": "CMS Actuarial Value (AV) Calculator 2027", "summary": "Estimates the share of essential health benefit costs paid by a health plan using the CMS 2027 continuance distributions. Experimental integrated medical/drug plan port with metal-tier and CSR scenario workflows.", "edition": "2027", "html": "https://formualizer.com/catalog/cms-av-calculator", "parent": { "text": "https://formualizer.com/catalog/subjects/healthcare/llms.txt", "json": "https://formualizer.com/catalog/subjects/healthcare/llms.json" }, "publisher": "Centers for Medicare & Medicaid Services (CMS / CCIIO)", "publisherPageUrl": "https://www.cms.gov/cciio/resources/regulations-and-guidance", "verificationLevel": "scenario-engine-regression", "verificationExplanation": "Scenarios match the engine’s own earlier results, not an independent check.", "rightsExplanation": "The bundle classifies this government source as public domain.", "limitations": [ "The 2027 continuance tables equally blend 2021–2023 EDGE claims projected to 2027, with 6.7% medical and 10.7% drug trends for 2026–2027 and a simple-average annualization method.", "The 2027 VBA MOOP input guard rises from $9,200 to $2,000,000; this removes the regulatory-limit check and does not mean a $2,000,000 MOOP complies with ACA limits.", "Native Excel/VBA scenario parity remains unchecked.", "Separate deductible/MOOP, tiered networks, per-diem and optional benefit-limit branches are mapped but rejected.", "Requested B4:B7 outputs are adapter aliases; original CMS outputs are B48:B50.", "JavaScript port of the publisher's VBA macros; the publisher's VBA macro does not run. Independent Excel/VBA scenario parity remains unchecked." ], "releaseBlockers": [ "Complete separate-deductible/MOOP, tiered-network and optional-benefit VBA branches.", "Complete service cost-sharing override precedence and compare against native Excel/VBA oracle." ], "releaseStatus": "candidate-blocked", "licenseClass": "public-domain-gov", "disclaimer": "Catalog calculations, not certification.", "removal": "Entries are removed on the publisher’s request.", "flows": [ { "id": "quick_metal_check", "title": "Quick metal check", "description": "Evaluate an integrated plan. Copay flags retain source checked defaults unless explicitly overridden (see presets).", "inputPorts": [ "desired_metal_tier", "deductible", "moop", "coinsurance", "hsa_contribution", "pcp_copay", "specialist_copay", "er_copay", "inpatient_copay", "generic_rx_copay", "preferred_brand_rx_copay" ], "outputPorts": [ "av_percent", "metal_tier", "status_notes" ] }, { "id": "full_plan_design", "title": "Full plan design", "description": "Full mapped input contract including service flags and reserved separate-Rx/tiered/limit ports. This edition rejects unported branches instead of ignoring inputs.", "inputPorts": [ "desired_metal_tier", "deductible", "coinsurance", "moop", "hsa_contribution", "medical_deductible", "medical_coinsurance", "medical_moop", "combined_moop_separate_deductibles", "separate_rx_deductible", "rx_coinsurance", "rx_moop", "tier2_deductible", "tier2_coinsurance", "tier2_moop", "medical_tier2_deductible", "medical_tier2_coinsurance", "medical_tier2_moop", "combined_moop_separate_deductibles_tier2", "rx_tier2_deductible", "rx_tier2_coinsurance", "rx_tier2_moop", "integrated_deductible", "hsa_enabled", "tiered_network", "separate_moop", "inpatient_per_diem", "skilled_nursing_per_diem", "specialty_rx_cap_enabled", "inpatient_day_limit_enabled", "pcp_free_visits_enabled", "pcp_copay_visits_enabled", "specialty_rx_coinsurance_max", "inpatient_copay_day_limit", "pcp_free_visit_limit", "pcp_copay_visit_limit", "tier1_utilization", "tier2_utilization", "csr_target", "er_copay", "er_coinsurance", "er_subject_to_deductible", "er_subject_to_coinsurance", "er_copay_after_deductible", "er_copay_tier2", "er_coinsurance_tier2", "er_subject_to_deductible_tier2", "er_subject_to_coinsurance_tier2", "er_copay_after_deductible_tier2", "inpatient_copay", "inpatient_coinsurance", "inpatient_subject_to_deductible", "inpatient_subject_to_coinsurance", "inpatient_copay_after_deductible", "inpatient_copay_tier2", "inpatient_coinsurance_tier2", "inpatient_subject_to_deductible_tier2", "inpatient_subject_to_coinsurance_tier2", "inpatient_copay_after_deductible_tier2", "pcp_copay", "pcp_coinsurance", "pcp_subject_to_deductible", "pcp_subject_to_coinsurance", "pcp_copay_after_deductible", "pcp_copay_tier2", "pcp_coinsurance_tier2", "pcp_subject_to_deductible_tier2", "pcp_subject_to_coinsurance_tier2", "pcp_copay_after_deductible_tier2", "specialist_copay", "specialist_coinsurance", "specialist_subject_to_deductible", "specialist_subject_to_coinsurance", "specialist_copay_after_deductible", "specialist_copay_tier2", "specialist_coinsurance_tier2", "specialist_subject_to_deductible_tier2", "specialist_subject_to_coinsurance_tier2", "specialist_copay_after_deductible_tier2", "mental_health_copay", "mental_health_coinsurance", "mental_health_subject_to_deductible", "mental_health_subject_to_coinsurance", "mental_health_copay_after_deductible", "mental_health_copay_tier2", "mental_health_coinsurance_tier2", "mental_health_subject_to_deductible_tier2", "mental_health_subject_to_coinsurance_tier2", "mental_health_copay_after_deductible_tier2", "imaging_copay", "imaging_coinsurance", "imaging_subject_to_deductible", "imaging_subject_to_coinsurance", "imaging_copay_after_deductible", "imaging_copay_tier2", "imaging_coinsurance_tier2", "imaging_subject_to_deductible_tier2", "imaging_subject_to_coinsurance_tier2", "imaging_copay_after_deductible_tier2", "speech_therapy_copay", "speech_therapy_coinsurance", "speech_therapy_subject_to_deductible", "speech_therapy_subject_to_coinsurance", "speech_therapy_copay_after_deductible", "speech_therapy_copay_tier2", "speech_therapy_coinsurance_tier2", "speech_therapy_subject_to_deductible_tier2", "speech_therapy_subject_to_coinsurance_tier2", "speech_therapy_copay_after_deductible_tier2", "rehab_copay", "rehab_coinsurance", "rehab_subject_to_deductible", "rehab_subject_to_coinsurance", "rehab_copay_after_deductible", "rehab_copay_tier2", "rehab_coinsurance_tier2", "rehab_subject_to_deductible_tier2", "rehab_subject_to_coinsurance_tier2", "rehab_copay_after_deductible_tier2", "preventive_copay", "preventive_coinsurance", "preventive_subject_to_deductible", "preventive_subject_to_coinsurance", "preventive_copay_tier2", "preventive_coinsurance_tier2", "preventive_subject_to_deductible_tier2", "preventive_subject_to_coinsurance_tier2", "lab_copay", "lab_coinsurance", "lab_subject_to_deductible", "lab_subject_to_coinsurance", "lab_copay_after_deductible", "lab_copay_tier2", "lab_coinsurance_tier2", "lab_subject_to_deductible_tier2", "lab_subject_to_coinsurance_tier2", "lab_copay_after_deductible_tier2", "xray_copay", "xray_coinsurance", "xray_subject_to_deductible", "xray_subject_to_coinsurance", "xray_copay_after_deductible", "xray_copay_tier2", "xray_coinsurance_tier2", "xray_subject_to_deductible_tier2", "xray_subject_to_coinsurance_tier2", "xray_copay_after_deductible_tier2", "skilled_nursing_copay", "skilled_nursing_coinsurance", "skilled_nursing_subject_to_deductible", "skilled_nursing_subject_to_coinsurance", "skilled_nursing_copay_after_deductible", "skilled_nursing_copay_tier2", "skilled_nursing_coinsurance_tier2", "skilled_nursing_subject_to_deductible_tier2", "skilled_nursing_subject_to_coinsurance_tier2", "skilled_nursing_copay_after_deductible_tier2", "outpatient_facility_copay", "outpatient_facility_coinsurance", "outpatient_facility_subject_to_deductible", "outpatient_facility_subject_to_coinsurance", "outpatient_facility_copay_after_deductible", "outpatient_facility_copay_tier2", "outpatient_facility_coinsurance_tier2", "outpatient_facility_subject_to_deductible_tier2", "outpatient_facility_subject_to_coinsurance_tier2", "outpatient_facility_copay_after_deductible_tier2", "outpatient_professional_copay", "outpatient_professional_coinsurance", "outpatient_professional_subject_to_deductible", "outpatient_professional_subject_to_coinsurance", "outpatient_professional_copay_after_deductible", "outpatient_professional_copay_tier2", "outpatient_professional_coinsurance_tier2", "outpatient_professional_subject_to_deductible_tier2", "outpatient_professional_subject_to_coinsurance_tier2", "outpatient_professional_copay_after_deductible_tier2", "generic_rx_copay", "generic_rx_coinsurance", "generic_rx_subject_to_deductible", "generic_rx_subject_to_coinsurance", "generic_rx_copay_after_deductible", "generic_rx_copay_tier2", "generic_rx_coinsurance_tier2", "generic_rx_subject_to_deductible_tier2", "generic_rx_subject_to_coinsurance_tier2", "generic_rx_copay_after_deductible_tier2", "preferred_brand_rx_copay", "preferred_brand_rx_coinsurance", "preferred_brand_rx_subject_to_deductible", "preferred_brand_rx_subject_to_coinsurance", "preferred_brand_rx_copay_after_deductible", "preferred_brand_rx_copay_tier2", "preferred_brand_rx_coinsurance_tier2", "preferred_brand_rx_subject_to_deductible_tier2", "preferred_brand_rx_subject_to_coinsurance_tier2", "preferred_brand_rx_copay_after_deductible_tier2", "nonpreferred_brand_rx_copay", "nonpreferred_brand_rx_coinsurance", "nonpreferred_brand_rx_subject_to_deductible", "nonpreferred_brand_rx_subject_to_coinsurance", "nonpreferred_brand_rx_copay_after_deductible", "nonpreferred_brand_rx_copay_tier2", "nonpreferred_brand_rx_coinsurance_tier2", "nonpreferred_brand_rx_subject_to_deductible_tier2", "nonpreferred_brand_rx_subject_to_coinsurance_tier2", "nonpreferred_brand_rx_copay_after_deductible_tier2", "specialty_rx_copay", "specialty_rx_coinsurance", "specialty_rx_subject_to_deductible", "specialty_rx_subject_to_coinsurance", "specialty_rx_copay_after_deductible", "specialty_rx_copay_tier2", "specialty_rx_coinsurance_tier2", "specialty_rx_subject_to_deductible_tier2", "specialty_rx_subject_to_coinsurance_tier2", "specialty_rx_copay_after_deductible_tier2" ], "outputPorts": [ "av_percent", "metal_tier", "status_notes", "effective_coin_num", "adj_deductible", "adj_moop" ] }, { "id": "csr_variant_matrix", "title": "Silver CSR variant matrix", "description": "One call evaluates four independently reset scenario presets. Each variant overrides its benefit parameters and uses Silver/Gold/Platinum continuance distributions for 73/87/94. These are sample plan designs, not automatic CSR benefit derivation.", "inputPorts": [ "desired_metal_tier", "deductible", "moop", "coinsurance", "hsa_contribution", "pcp_copay", "specialist_copay", "er_copay", "inpatient_copay", "generic_rx_copay", "preferred_brand_rx_copay" ], "outputPorts": [ "av_percent", "metal_tier", "status_notes", "effective_coin_num", "adj_deductible", "adj_moop" ] } ], "example": { "id": "bronze", "flow": "full_plan_design", "inputs": { "desired_metal_tier": 4, "deductible": 7500, "coinsurance": 0.6, "moop": 11000, "hsa_contribution": 0, "pcp_copay": 0, "specialist_copay": 0, "generic_rx_copay": 0 }, "expectedOutputs": { "av_percent": 60.49, "metal_tier": "Bronze", "status_notes": "Calculation Successful. Experimental integrated-plan JS port; Excel/VBA oracle parity unverified.", "effective_coin_num": 3376.73619580898, "adj_deductible": 8915.199892687177, "adj_moop": 11000 }, "inputsJson": "{\"desired_metal_tier\":4,\"deductible\":7500,\"coinsurance\":0.6,\"moop\":11000,\"hsa_contribution\":0,\"pcp_copay\":0,\"specialist_copay\":0,\"generic_rx_copay\":0}", "expectedOutputsJson": "{\"av_percent\":60.49,\"metal_tier\":\"Bronze\",\"status_notes\":\"Calculation Successful. Experimental integrated-plan JS port; Excel/VBA oracle parity unverified.\",\"effective_coin_num\":3376.73619580898,\"adj_deductible\":8915.199892687177,\"adj_moop\":11000}" }, "ports": { "text": "https://formualizer.com/catalog/agents/cms-av-calculator/2027/ports/llms.txt", "json": "https://formualizer.com/catalog/agents/cms-av-calculator/2027/ports/llms.json" }, "service": { "openapi": "https://catalog.formualizer.com/v1/models/cms-av-calculator/2027/openapi.json", "types": "https://catalog.formualizer.com/v1/models/cms-av-calculator/2027/types.d.ts", "fio": "https://catalog.formualizer.com/v1/models/cms-av-calculator/2027/fio.yaml", "evaluate": "https://catalog.formualizer.com/v1/models/cms-av-calculator/2027/evaluate", "mcp": "https://catalog.formualizer.com/v1/mcp" } } ```