Exhibit F - Dental Claims Incurred and Claims Paid.xlsx

This is an exhibit document detailing dental claims data for a Colorado dental benefits program, tracking claims incurred and paid through a single Master Account ID (00000007649) across two plan types: Basic and Basic Plus. The document provides a comprehensive monthly breakdown of claims activity from May 2025 through June 2026, recording both the month claims were incurred and the month they were paid, with corresponding payment amounts for each transaction.

The Basic plan generated total paid claims of $7,768,453.16 during the reporting period, while the Basic Plus plan produced total paid claims of $21,035,815.22, reflecting significantly higher utilization and costs under the enhanced coverage option. The data demonstrates typical claims payment patterns with claims frequently paid one to two months after incurrence, indicating standard administrative processing timelines. Notable trends include larger claim payments in the immediate months of incurrence (same or next month paid), with older claims from earlier periods showing smaller residual payments when processed in later months, suggesting a mature claims run-out pattern. The combined total paid claims across both plan types amount to $28,804,268.38, representing the financial scope of dental benefits delivery during this twelve-month period.