Appearance
📊 Long-Term Cost Projections: Overture Option C
This document models the realistic cost over time for Bob and Anita at Cedar Crest (Option C) over a 10-year horizon. It includes inflation adjustments and evaluates the financial impact of potential healthcare/care tier upgrades.
Use the interactive calculator below to adjust the entry fee, inflation rate, and progressive care options to see their long-term cost impact.
⚙️ Modeling Controls
⚠️ Progressive Care Tiers
Tier 1: Light Care (Knees/Meds)
Tier 2: Advanced Care (Memory)
📈 Dynamic 10-Year Projections Dashboard
Scenario A: Base Case
3-Year Outlay:$108,334
5-Year Outlay:$187,777
10-Year Net Sunk Cost:$445,740
Scenario B: Care Progression
3-Year Outlay:$123,909
5-Year Outlay:$236,396
10-Year Net Sunk Cost:$771,130
⚠️ 10-Year Cash Impact: Scenario B costs an additional $325,390 in operating expenses over 10 years compared to the base case.
Detailed Comparison Table (Scenario B: Care Case)
| Year | Monthly Base | Add. Care | Out-of-Pocket | Annual Cost | Cumulative Cash | Sunk Cost |
|---|---|---|---|---|---|---|
| Year 1 | $2,595 | $0 | $300 | $34,740 | $34,740 | $65,340 |
| Year 2 | $2,699 | $0 | $309 | $36,094 | $70,834 | $101,434 |
| Year 3 | $2,807 | +$1,298 | $318 | $53,075 | $123,909 | $154,509 |
| Year 4 | $2,919 | +$1,350 | $328 | $55,160 | $179,069 | $209,669 |
| Year 5 | $3,036 | +$1,404 | $338 | $57,327 | $236,396 | $266,996 |
| Year 6 | $3,157 | +$4,258 | $348 | $93,159 | $329,556 | $360,156 |
| Year 7 | $3,283 | +$4,429 | $358 | $96,844 | $426,400 | $457,000 |
| Year 8 | $3,415 | +$4,606 | $369 | $100,675 | $527,074 | $557,674 |
| Year 9 | $3,551 | +$4,790 | $380 | $104,658 | $631,732 | $662,332 |
| Year 10 | $3,693 | +$4,982 | $391 | $108,798 | $740,530 | $771,130 |
💡 Key Financial Planning Takeaways
- Capital Preservation: Because Option C is 85% refundable, $173,400 remains protected capital that will eventually return to their estate or trust. Only $30,600 of the entry fee is lost.
- The Impact of Care Tiers: Notice the sharp increase in Scenario B when advanced care kicks in. If Dad needs specialized memory care or if advanced support tiers are required, monthly operating costs will more than double.
- SSM MyChart / Care Advocacy: Keeping Christian and Amy active via MyChart will allow you to track medical appointments and coordinate care directly, potentially delaying the need for expensive community-provided care by arranging private-duty home care or family support checks.
📋 Provisions for Evaluating Cedar Crest Progressive Care Costs
Since you do not have concrete care pricing figures from Cedar Crest yet, use these guidelines to gather, organize, and evaluate care cost options when they become available:
1. Questions to Ask the Admissions Director (Walkthrough: June 9 @ 10:00 AM)
- Care Level Definitions: What specific tasks or assistance triggers each care level/tier (e.g., Tier 1, Tier 2)?
- Assessment Method: How is the care level determined? Is it a point system based on activities of daily living (ADLs)? How often is it re-evaluated, and can the family appeal an assessment?
- In-Place Care vs. Relocation: Can progressive care (assisted living support) be delivered directly to their Overture apartment (Option C), or must they relocate to a designated assisted living or memory care wing when care needs increase?
- Refundable Deposit Rules: If they have to transition to a higher care wing, does the $204,000 Overture entry fee (and its 85% refundability) transfer to the new room, or is it refunded/re-negotiated under a new contract?
- Third-Party Care Policy: Are they allowed to hire external private-duty caregivers (like Home Instead or visiting nurses) to provide support in their independent apartment? Is there a fee or registration requirement for this?
2. How to Feed New Numbers into the Projections
Once you receive the official fee schedules:
- Use the Progressive Care Sliders & Inputs in the interactive modeling panel above to update the Tier 1 and Tier 2 monthly costs.
- Observe the updated 10-Year Cumulative Cash Outlays and 10-Year Cash Impact to evaluate the feasibility of their long-term budget.