Predictive insights for strategic plan optimization and ROI maximization
Click on any cluster below to see detailed calculations and ROI projections for quality improvement investments.
Select a cluster above to see detailed calculations and ROI analysis
Select a plan to see all calculations step-by-step with actual values.
Low-cost, high-quality plans with exceptional ROI potential
High-cost plans with poor quality metrics requiring intervention
Plans with highest margin percentage - protect and expand these
Plans with strongest YoY enrollment growth - momentum plays
Plans below 85% MLR threshold - must issue rebates to members
Plans that increased stars YoY - quality momentum indicators
| Plan ID | Region | Stars | Star ฮ | Bid | MLR | Margin % | Growth | Efficiency | Classification |
|---|
This analysis employs a risk-adjusted value framework to evaluate Medicare Advantage plans beyond simple cost comparisons. By incorporating enrollee health risk, quality metrics, and rebate structures, we identify plans that deliver superior value to CMS and beneficiaries while predicting future ROI potential.
We generated 30 synthetic Medicare Advantage plans modeled after real CMS plan characteristics:
MLR = (Medical Claims + Quality Improvement Costs) / Premium Revenue ร 100
Federal Requirement: Medicare Advantage plans must maintain an MLR of at least 85%. This ensures that 85 cents of every premium dollar goes to actual medical care and quality improvement, not administrative overhead.
CVS Impact: Plans below 85% MLR must issue rebates to members, reducing profitability. Plans consistently below this threshold face CMS sanctions. This is a critical compliance and profitability metric.
Gross Margin = Premium Revenue - Medical Claims - Admin Costs - Quality Improvement
Margin % = (Gross Margin / Premium Revenue) ร 100
CVS Impact: Bottom-line profitability metric. Healthy MA plans target 3-8% margins. Negative margins indicate plans losing money and requiring urgent intervention. This drives portfolio decisions on plan continuation vs termination.
Growth % = ((Current Enrollees - Prior Year Enrollees) / Prior Year Enrollees) ร 100
CVS Impact: Growth indicates market competitiveness and member satisfaction. Growing plans justify increased investment. Declining enrollment signals quality issues, pricing problems, or competitive threats requiring strategic intervention. Scale drives profitability in MA.
Star Trend = Current Year Stars - Prior Year Stars
CVS Impact: Quality trajectory matters as much as current rating. Improving plans show operational excellence and may soon cross bonus payment thresholds (4+ stars). Declining plans risk losing members and rebates. Identifies where quality investments are working vs failing.
Market Share % = (Plan Enrollees / Total Regional MA Enrollees) ร 100
CVS Impact: Competitive positioning metric. High market share plans have pricing power and scale advantages. Low share plans may be non-competitive or operate in fragmented markets. Guides expansion and exit strategies.
Rebate = Bid ร (Star Rating / 5) ร 0.3
Rebates incentivize quality by returning a portion of the bid to beneficiaries or CMS. Higher-rated plans receive proportionally larger rebates, with the maximum rebate being 30% of the bid amount for 5-star plans.
Risk-Adjusted Cost = Actual Claims ร Enrollee Risk Score
Adjusts historical claims data by the health risk profile of the plan's enrollees. A plan with a 1.5 risk score serves a population 50% sicker than average, requiring more resources. This normalization enables fair comparisons across plans serving different populations.
Efficiency = Risk-Adjusted Cost / Star Rating
This is the core value metric. Lower efficiency scores indicate better valueโthe plan delivers higher quality care at lower cost per star. For example, an efficiency of $2,000/star is superior to $3,000/star, as you're getting more quality per dollar spent.
Criteria:
Business Impact: These plans represent exceptional value for CMS. They deliver high-quality care at below-average costs. CMS should incentivize enrollment growth in these plans through marketing support, expanded service areas, or additional quality bonuses. Expected ROI: 15-25% cost savings vs. average plans while maintaining superior outcomes.
Criteria:
Business Impact: These plans drain resources while delivering poor outcomes. CMS should implement corrective actions: quality improvement mandates, financial audits, enrollment freezes, or contract termination if performance doesn't improve. Potential savings: 20-30% by reallocating beneficiaries to higher-value alternatives.
Plans that don't meet either extreme. They provide average value and may benefit from targeted quality improvement initiatives to move into the "Hidden Gem" category.
The analysis includes a predictive component that simulates the financial impact of quality improvements:
ROI Calculation: Each half-star increase generates:
Strategic Insight: Plans currently rated 3.5-4.0 stars represent the best improvement opportunities. They're close to crossing quality thresholds that trigger substantial bonus payments. Small investments in these plans yield disproportionate returns.
The primary visualization plots Risk-Adjusted Cost (Y-axis) against Star Rating (X-axis):
1. Protect & Expand High-Value Plans ("Hidden Gems")
Action: Allocate 60% of marketing budget to Hidden Gem plans - they combine high quality (4+ stars)
with superior efficiency. These plans have room to grow margins while maintaining competitive pricing.
Expected ROI: 15-25% enrollment growth in these plans translates to $100M-$300M additional annual
profit at current margins, with minimal risk of quality degradation.
2. Fix or Exit Unprofitable Plans
Action: Plans with negative margins AND declining enrollment need immediate intervention.
Implement 90-day turnaround plans focusing on: network renegotiation, utilization management, administrative
cost reduction. If margins don't improve to breakeven within 6 months, exit the market.
Expected Impact: Eliminating 5 unprofitable plans saves $50M-$150M annually in losses.
Reallocating those resources to profitable plans compounds returns.
3. Targeted Quality Investment for Star Rating Threshold Plans
Action: Focus quality improvement resources on plans rated 3.5 stars that could reach 4.0,
and 4.0 star plans that could reach 4.5. Crossing these thresholds unlocks significant bonus payments from CMS
and improved member retention.
Expected ROI: $5M investment in clinical programs (care management, HEDIS gap closure, pharmacy
adherence) yields $15M-$25M in bonus payments (3-5x return). Target 3-5 plans per year for intensive intervention.
4. MLR Compliance & Risk Management
Action: Plans below 85% MLR face mandatory member rebates. For borderline plans (82-84% MLR),
strategically increase quality improvement spending to reach compliance while avoiding rebates. For consistently
low-MLR plans (<80%), investigate pricing opportunitiesโyou may be underpricing relative to actual costs.
Expected Impact: Avoiding rebates on a 50,000 member plan saves $5M-$10M annually. Proper
pricing optimization could add 2-3% margin without losing competitiveness.
5. Competitive Bidding Strategy Using Efficiency Benchmarks
Action: Use market efficiency data to inform annual bids. If regional competitors average
$2,400/star efficiency and CVS is at $2,800, you're 17% overpriced and will lose enrollment. Either reduce
bid or improve quality to justify pricing. Conversely, if you're at $2,200 efficiency, you have room to increase
bids and capture margin without losing competitiveness.
Expected Impact: Optimized bidding across 30-50 plans could improve margins by 1-2 percentage
points ($200M-$500M annually) while maintaining or growing market share.
6. Growth Plan Doubling Down
Action: Plans showing 10%+ enrollment growth deserve accelerated investment. These plans have
product-market fit and competitive advantages. Expand service areas, add benefit enhancements, increase broker
commissions, and launch aggressive member acquisition campaigns.
Expected ROI: Scale drives profitability in MA. Doubling enrollment in a high-growth,
high-margin plan from 20,000 to 40,000 members could add $15M-$30M annual profit with minimal incremental overhead.
7. Portfolio Rebalancing & M&A Target Identification
Action: This framework identifies acquisition targets. Smaller MA providers with "Hidden Gem"
plans are undervalued assets. Their high-quality, high-efficiency plans could be scaled under CVS's infrastructure,
improving margins and market position. Conversely, CVS should consider divesting "Overpriced" plans to competitors
who may value them differently.
Strategic Value: Acquiring 3-5 Hidden Gem plans through M&A accelerates profitable growth faster
than organic development, while shedding underperformers improves overall portfolio ROI and focus.
8. Defensive Monitoring: Identify Early Warning Signs
Action: Establish quarterly reviews tracking: star rating trends (declining = quality issues),
enrollment growth (declining = competitive weakness), MLR trends (rising = cost management problems), and
margin compression (losing efficiency). Early detection enables proactive intervention before plans become unfixable.
Risk Mitigation: Preventing a 1-star decline on a 100,000 member plan saves $30M-$50M in lost
bonus payments and member churn costs. Early intervention is 10x more cost-effective than remediation.
CVS Health operates one of the largest Medicare Advantage portfolios in the United States through Aetna. With billions in annual MA revenue and millions of enrollees, even small efficiency improvements compound into massive financial impact.
Identifying high-margin plans for expansion and low-margin plans for intervention directly impacts bottom-line earnings. A 1% margin improvement across CVS's MA book could add $200M-$400M in annual profit.
Understanding where CVS plans rank vs. UnitedHealth, Humana, and regional competitors informs pricing strategy, market entry/exit decisions, and competitive response planning.
Data-driven decisions on which plans to grow, maintain, fix, or exit. Prevents emotional attachment to underperforming assets and ensures capital allocation to highest-ROI opportunities.
Early detection of MLR compliance issues, quality degradation, and enrollment declines prevents regulatory sanctions, member rebates, and reputational damage. Prevention is 10x cheaper than remediation.
Identifying plans near star rating thresholds maximizes capture of CMS quality bonus payments. Moving 5 plans from 3.5 to 4.0 stars could unlock $50M-$100M in annual bonuses.
Plans with strong growth momentum deserve accelerated investment. Doubling down on winners creates compounding returns through scale economies and network effects.
This analysis demonstrates core actuarial competencies that CVS Health values:
This framework doesn't just analyze plansโit drives profitability, manages risk, and guides strategic decisions worth hundreds of millions of dollars annually. It's the kind of analytical rigor that differentiates industry leaders from followers in the highly competitive Medicare Advantage market.
This Medicare Advantage plan analysis framework transforms raw enrollment, claims, and quality data into strategic intelligence that drives profitability and competitive advantage for CVS Health. By combining risk adjustment, financial metrics, quality measurement, and predictive analytics, this tool enables data-driven portfolio management decisions that optimize returns across CVS's multi-billion dollar MA business.
The methodology is scalable to hundreds of plans, incorporates regulatory requirements (MLR compliance, star ratings), and provides transparent, auditable results that support executive decision-making. Most importantly, it demonstrates the actuarial thinking that turns complex healthcare data into bottom-line business valueโidentifying opportunities worth hundreds of millions in profit improvement while managing risk and ensuring regulatory compliance.