Aging Valuator
Value an A/R book by payer and age
Collectible amount and present value for Medicare, Medicaid, commercial and self-pay balances, with editable collection curves, saved scenarios and a sensitivity table.
A/R by payer and age
Example figures (illustrative, USD thousands). Replace them with your own. Inputs are saved in this browser only.
Collection-rate curves and payer lag
Sensitivity
Scenarios
| Name | Present value | vs current | Actions |
|---|
How the estimate is built
- Each balance is multiplied by its expected collection rate for that payer and age bucket.
- Collections are timed using a base days-to-cash per bucket (20, 45, 70, 100 and 150 days), plus the payer lag and any extra days you add.
- Each amount is discounted at your annual rate: amount ÷ (1 + rate)days/365.
- The sum across payers and buckets is the present value. The sensitivity table repeats the calculation across discount rates and collection curves.
Defaults are sample assumptions, not benchmarks. Calibrate them to your own history before relying on any result.
