Analysis: Cedar Valley Health System
Mar 2026 · 1 month included
Comparing May 2026 vs Apr 2026
Net Estimated Revenue
$4.28M
Gross Charges
$45.05M
Billable Rate
92.7%
Paid Rate (Billable)
9.5%
Billable Charges → Net Estimated Revenue
$4.28M estimated on $41.76M billable charges · 10.2% estimated yield
Monthly Revenue Estimation
Engine-estimated revenue vs prior-year baseline
Revenue by EM Level
CPT 99281–99285Visit volume & charges by acuity level — drives revenue model
Revenue by Facility
Stacked by LocationNet estimated revenue split by Facility × Location
Revenue by Entity Type
May 2026 vs Apr 2026Net estimated revenue grouped by derived Entity Type
Revenue by Billable Status
May 2026 vs Apr 2026Derived "Billable Status" column · current vs prior period
Revenue Mix by Fin Class
Net revenue grouped by derived NewFinClass
Strategic Commentary
Projected net revenue of $4.28M exceeds the prior-month baseline by 12.4%, driven by a favorable shift in EM Level mix (99284/99285 share up 4.1pp) at Pflugerville and a 31% reduction in Fin Class mapping errors. Denial risk remains elevated at 8.2%—above the 7.5% target—concentrated in Visit Status inconsistencies (142 events) and unmapped Fin Class rows (98 events). Recommend tightening front-desk Visit Status capture for BCBS and Medicare LocFin segments, which together account for 68% of denial exposure. Clean claim rate of 89.0% is now in the upper quartile vs. peer Altus facilities.
Audit Trail
Excel file imported
Today · 09:12 AM · RCM_dump_May2026.xlsx · 14,802 rows · 49 columns
Schema validated
Today · 09:13 AM · All 49 required columns present
Derived 6 formula columns
Today · 09:13 AM · Billable Status, NewFinClass, LocFinEM, LocFin, New Paid, Paid/Unpaid
S3S engine cleaned 13,991 rows
Today · 09:14 AM · 94.5% auto-resolution