Portfolio Inputs
Enter portfolio scale manually or import a facility list.
Use the Excel template to populate portfolio scale, payor assumptions, labor, back-office structure, and Future Care fees in one upload.
Facility CSV columns supported: Facility, Type, Beds. ALF bed counts are ignored.
Enter a portfolio name, SNF facility count, and licensed bed count. The model recalculates instantly.
Annual SNF Revenue Base
$0
—
Gross Operational / Cash Uplift
$0
Collections + risk / turnover savings
Total Future Care Fees
$0
Always calculated from the Future Care rate card
Net Annual Portfolio Benefit
$0
—
Value Bridge
Annual impact from current state to the Future Care operating model.
Payor Revenue & Collections
Payor-specific revenue and collection improvement.
| Payor | Mix | Rate / Bed / Day | Annual Revenue | Current Collect. | Future Care Collect. | Incremental |
|---|
Editable Assumptions
Future Care operating assumptions are preloaded. Adjust inputs for the client or sensitivity case.
Payor Mix, Rates & Collection Performance
| Payor | Mix % | Revenue / Bed / Day | Current Collection % | Future Care Collection % |
|---|---|---|---|---|
| Private Pay | ||||
| Medicare | ||||
| Medicaid + MLTSS | ||||
| HMO | ||||
| Care Cost (% of Medicaid + MLTSS revenue) | Derived |
Current Back Office Model
The Future Care cost is always calculated from the Future Care rate card and portfolio scale. The current back-office selection only changes the current-state cost and labor savings used in the comparison.
Facility Labor & Retention Under Future Care
| Role / Cost | Annual Cost / SNF | % Retained Under Future Care | Annual Cost Avoided / SNF |
|---|---|---|---|
| Admissions Coordinator | — | ||
| Medicaid Coordinator | — | ||
| Business Office Manager | — | ||
| Collection Support | — | ||
| AP Labor | — | ||
| Payroll Labor | — | ||
| Accounting Labor | — | ||
| Total Effective Internal Labor Savings | — |
Default staffing logic: Admissions Coordinator is retained at 100%; Business Office Manager is retained at 50%. In third-party mode, Collection Support, AP, Payroll, and Accounting labor savings are excluded to prevent double counting. Medicaid Coordinator savings remains included because the modeled incumbent back office does not include Pending.
Risk / Turnover & Future Care Fee Schedule
| Future Care Service | Rate | Basis | Annual Portfolio Fee |
|---|---|---|---|
| SNF RCM | Per SNF licensed bed / month | — | |
| Pending | Per SNF licensed bed / month | — | |
| AP | Per SNF / month | — | |
| Payroll | Per SNF / month | — | |
| Financial Services | Per SNF / month | — | |
| ALF RCM | Per ALF / month | — | |
| Total Future Care Fees | — |
Calculation Method
Transparent formulas used in the model.
Payor revenue
Licensed SNF Beds × Revenue Days/Month × 12 × Payor Mix × Payor Rate/Bed/Day.
Licensed SNF Beds × Revenue Days/Month × 12 × Payor Mix × Payor Rate/Bed/Day.
Incremental collections
Payor Revenue × (Future Care Collection Rate − Current Collection Rate). Care Cost is calculated separately as a percentage of Medicaid + MLTSS revenue.
Payor Revenue × (Future Care Collection Rate − Current Collection Rate). Care Cost is calculated separately as a percentage of Medicaid + MLTSS revenue.
Labor savings
Annual Cost/SNF × (1 − % Retained Under Future Care) × SNF Facility Count. Third-party mode excludes internal back-office roles to prevent double counting.
Annual Cost/SNF × (1 − % Retained Under Future Care) × SNF Facility Count. Third-party mode excludes internal back-office roles to prevent double counting.
Current third-party back-office cost
When Third-Party / Outsourced is selected, the incumbent cost is calculated from the user-entered SNF RCM, AP, Payroll, Financial Services, and ALF RCM rates. Pending is excluded.
When Third-Party / Outsourced is selected, the incumbent cost is calculated from the user-entered SNF RCM, AP, Payroll, Financial Services, and ALF RCM rates. Pending is excluded.
Future Care cost
Future Care RCM + Pending + AP + Payroll + Financial Services + ALF RCM fees are always calculated from the Future Care rate card and portfolio scale, regardless of the current back-office model.
Future Care RCM + Pending + AP + Payroll + Financial Services + ALF RCM fees are always calculated from the Future Care rate card and portfolio scale, regardless of the current back-office model.
Net annual portfolio benefit
Incremental Collections + Risk/Turnover Savings + Effective Internal Labor Savings + Current Back Office Fees Replaced − All Future Care Fees.
Incremental Collections + Risk/Turnover Savings + Effective Internal Labor Savings + Current Back Office Fees Replaced − All Future Care Fees.
Ready to share with the client?
Generate a branded Future Care Excel workbook with an executive summary, assumptions, fee detail, payor economics, and imported facility list when available.