00 Customer Persona: MetaWell Care Segment A Consumer Growth Brand
01 ACCESS Revenue Calculator eCKM Track — MetaWell Care — 9 months
Enrolled (eCKM) iTotal patients currently enrolled in the eCKM track. Includes initial and follow-on period patients. Growth driven by DTC acquisition (Meta ads).
105
+30 this month
Gross Annual Revenue iGross = enrolled x annual rate. This is the total payment CMS would make if there were no withhold. Actual cash received is 50% monthly + quarterly reconciliation of the withheld 50%.
$36,540
$30/patient/month
SSR iSubstitute Spend Rate. Percentage of enrolled patients who are not receiving substitute services from another provider. Threshold: 90%. Below threshold means too many patients have another provider billing RPM/CCM for the same conditions. Detected via CCW bene match (claims data).
78%
Below 90% threshold
OAR iOutcome Attainment Rate. Percentage of patients meeting ALL required OAP measures for their track/condition. Threshold: 50%. A patient "meets" a measure if they hit either the control target OR the minimum improvement target. Driven by patient engagement — disengaged patients almost never meet measures.
52%
Above 50% threshold
Penalty Exposure iProjected quarterly penalty. Applied penalty = MAX(clinical, SSA) — not additive. Clinical penalty (from OAR) caps at 50% of withhold. SSA penalty (from SSR) caps at 25%. Only the larger of the two applies.
$2,190
~6% of gross revenue
Session Attendance iPercentage of enrolled patients actively attending scheduled dietitian sessions. Drives OAR — patients who don't attend sessions rarely meet outcome measures.
65%
Actively attending monthly
Activation Rate iPercentage of enrolled patients who completed onboarding and attended at least one clinical session. Patients who never activate are almost certain to fail OAP measures.
82%
Completed onboarding
At-Risk Patients iPatients with no clinical session or app activity in 30+ days. These patients are likely to: (1) fail OAP measures, dragging down OAR, and (2) seek care elsewhere, potentially triggering substitute services (SSR impact).
23
No session in 30+ days
Avg Sessions / Mo iAverage number of dietitian sessions attended per patient per month. Higher session frequency correlates with better OAP measure outcomes. Target of 2.0 based on clinical protocol.
1.4
Target: 2.0
Net Growth iMonthly net enrollment growth rate (3-month trailing average). Includes new enrollments minus churn. Positive = growing panel. Negative = losing patients faster than acquiring.
+15%
Monthly (3-mo trailing)
Monthly Revenue — eCKM Track Monthly cash (50%) + quarterly withhold reconciliation
Actual: ~15%/mo
+15%
Monthly net growth rate (includes churn)
Actual: 78%
78%
Threshold: 90% — below triggers penalty
Actual: 52%
52%
Threshold: 50% — below triggers penalty
Monthly cash (50%) Projected monthly cash Quarterly withhold returned Penalty deducted 3-mo trailing avg Projected trend
Export Export to Google Sheets

Generates a Google Sheet with your full data and calculations:
Data tabs — patient records, CCW match results, CMS rates
Calculator tabs — formulas driving this chart, quarterly reconciliation
Scenarios tab — editable workspace for custom what-if modeling

All formulas are transparent and editable. Snapshot at export time — export again for fresh data.
Monthly Cash Flow Detail
Month Enrolled New Gross Payment Withhold (50%) Net Cash SSR OAR Status
Jul 202633$90$45$45Ramp
Aug 202674$210$105$105Ramp
Sep 2026103$300$150$15082%Ramp
Q1 Reconciliation$300 pool+$300Full return
Oct 20262212$660$330$33080%48%SSR watch
Nov 20263715$1,110$555$55579%50%SSR watch
Dec 20265720$1,710$855$85578%51%SSR below
Q2 Reconciliation$1,740 pool+$1,305SSA penalty: $435
Jan 20277215$2,160$1,080$1,08078%52%SSR below
Feb 20278715$2,610$1,305$1,30577%52%SSR below
Mar 202710518$3,150$1,575$1,57578%52%SSR below
Q3 Reconciliation$3,960 pool+$2,970SSA penalty: $990
02 Algorithms & Calculations The math behind the calculator
03 Data Model Three domains — customer, CCW, derived
04 Data & Workflow How data flows into the calculator