CAS Therapy has the following year to date numbers for (7 months or July)

Payer 1 That pays $100 per visit pays 10% of their accounts in 1-30 days, 20% in 31-90 days, 40% 91-180, 20% 181-360 & the

Remainder +360 days

Payer 2 That pays $85 per visit pays 25% of their accounts in 1-30 days, 40% in 31-90 days, 15% 91-180, 15% 181-360 & the remainder +360 days

Payer 3 That pays $75 per visit pays 35% of their accounts in 1-30 days, 35% in 31-90 days, 20% 91-180, 5% 181-360 & the remainder +360 days

Create aging schedule that compares the 3 payers

What are your thoughts? How does this aging affect your budgets?