How to Use This Tool
Build a VBC financial model in 6 steps. Step 1: Choose your line of business and contract type. Step 2: Set population characteristics. Step 3: Define cost and utilization inputs. Step 4: Configure intervention assumptions. Step 5: Set risk corridor and financial terms. Step 6: Review your results dashboard. Toggle between Guide and Expert modes for more or less detail. Save models to the cloud, compare scenarios side-by-side, and export term sheets and PDF reports.
Contract Setup
Define the foundational parameters for your value-based arrangement.
The insurance product type. MA, Medicaid, commercial, and ACO each have different cost baselines and regulatory rules. This auto-populates all defaults.
Whether the provider shares only in savings (upside) or also absorbs losses (two-sided). Two-sided unlocks higher sharing rates but creates downside risk.
Members multiplied by months attributed. 10,000 members for 12 months = 120,000 MM. This is the denominator for every PMPM calculation. Under 5,000 lives produces statistically unreliable results.
Regional cost adjustment factor. Northeast and West Coast run 15-18% above national average. This adjusts the baseline so the model reflects local care costs.
Optional. Select a county to auto-populate the MA benchmark PMPM, geographic cost index, and average risk score from CMS county rate data. Overrides the geographic region selector above.
Performance years. Longer contracts (3-5 years) let care management programs mature. Year 1 rarely shows large returns; real value appears in years 2-3.
How members get assigned. Prospective locks the panel up front — you know who you're managing. Retrospective assigns after the fact, more accurate but harder to intervene.
Population Characteristics
Define the risk profile and demographics of your attributed population.
1.00
How sick your population is relative to average (1.0 = average). Higher scores mean higher benchmarks and more room for savings. Undercoded populations get punished.
5.9%
CMS reduces MA risk scores by ~5.9% to account for coding intensity differences between MA and Fee-for-Service. This adjustment is applied before the risk-adjusted benchmark is calculated.
72
Adjustable average age of the attributed population. Affects cost through an age-risk multiplier: younger populations cost less, older populations cost more. Ages below 45 reduce baseline by up to 15%; ages above 75 increase it by up to 20%.
52%
Percentage of attributed population that is female. Affects maternity cost allocation in the model. Higher female percentage in commercial populations increases maternity-related costs.
15%
Members without 12 months of claims history. They lack reliable risk scores, making their benchmark less accurate. High churn (>15%) adds volatility to savings calculations.
Costs & Utilization
Set cost benchmarks and utilization rates for the target population.
Two formats supported:
Format A — Claims Detail:
Format B — Direct PMPM:
Format A — Claims Detail:
claim_type,allowed_amount,member_months
IP,8500000,120000
OP,6200000,120000
Professional,4800000,120000
ER,3100000,120000
Rx,5500000,120000
BH,1200000,120000
Post-Acute,2400000,120000
PMPM is calculated as allowed_amount / member_months.Format B — Direct PMPM:
category,pmpm
IP,350.00
OP,280.00
Professional,210.00
ER,95.00
Rx,180.00
BH,45.00
Post-Acute,55.00
Valid claim types: IP, OP, Professional, ER, Rx, BH, Post-Acute
Drop a CSV file here or click to browse
Supports claims detail or direct PMPM format
Supports claims detail or direct PMPM format
Warnings:
$1,100 PMPM
If you know your actual TCOC, enter it here to override the calculated estimate. This is the most important number in the model — use real data when available.
Typical ranges: MA $900--1,200 · Commercial $400--700 · Medicaid $300--500 · DSNP $1,200--1,800
The pricing framework for unit costs. Most commercial contracts express rates as a percentage of Medicare. This determines the dollar value of every utilization unit.
100%
Hospital reimbursement as % of Medicare rates. Commercial typically pays 180-250%. Higher percentages mean higher benchmarks — more room for savings but payer is already overpaying.
100%
Physician reimbursement as % of Medicare. Commercial typically pays 130-180%. Combined with visit rates, this builds the professional services cost baseline.
65
Inpatient admissions per 1,000 members annually. Usually the largest cost category. Reducing admits by 10% on a large book can generate millions in savings.
National average LOS: 4.5 days
350
Emergency visits per 1,000 annually. High ER rates signal primary care access gaps and represent redirection savings opportunity.
4200
Primary care visits per 1,000. Higher PCP utilization correlates with lower ER and IP use. More PCP visits is usually the goal, not something to reduce.
2800
Specialty visits per 1,000. Referral management and center-of-excellence routing can reduce specialist spend without cutting access.
50%
Portion of pharmacy spend on specialty drugs. Specialty is 2% of scripts but 50%+ of Rx cost. This dramatically affects total cost projections.
7.5%
Annual medical cost increase rate. Trend compounds across multi-year contracts. Higher trend in the benchmark favors providers; lower trend favors payers.
9.0%
Annual pharmacy cost increase. Often exceeds medical trend due to specialty pricing. If pharmacy is carved in, high Rx trend can erase medical savings.
Use uniform trend
▼
7.5%
7.5%
7.5%
7.5%
7.5%
7.5%
Whether pharmacy is included in or excluded from the benchmark. Carving in gives more levers but more exposure. Carving out simplifies the model.
Pharmacy Carved In
20%
Percentage of pharmacy spend offset by manufacturer rebates. Reduces the Rx PMPM component. Defaults vary by LOB: ~20% for commercial, ~15% for MA, 0% for Medicaid FFS. Only active when pharmacy is carved in.
Contract Terms
Define the financial terms of the shared savings/risk arrangement.
Quality Metrics
Define quality performance expectations and bonus structures.
3.5
Your current quality performance before the VBC contract. The gap between baseline and target determines how much improvement is needed to unlock payments.
4.0
The threshold required for full financial settlement. Set realistically — achievable targets that escalate over the contract term.
2.0%
Additional money for exceptional quality, as % of TCOC. Bonus pools cost the payer nothing unless quality improves — easier to negotiate than higher savings shares.
MA only. 5% premium rebate from CMS for 4.0+ Stars plans. If you're driving Stars improvement, get contractual credit for it.
5% rebate at 4.0+ Stars
Results Dashboard
Projected financial outcomes for Year 1 of the value-based arrangement.
Sensitivity Analysis
Savings Waterfall
Cost by Service Category
Shared Savings Distribution
Quality-Adjusted Financials
MLR Impact
Provider P&L View
Probabilistic Sensitivity Analysis Monte Carlo Simulation
Want to discuss this model with an advisor?
We'll review your assumptions and help you negotiate terms.