How to Calculate Your Aging-in-Place vs Assisted Living, Memory Care, and Nursing Home Cost Crossover: The 5-Step NPV Formula at May 2026's $33/Hour Aide Cost and 0.6% CPI
Start Here: A Real Family, Real Numbers
Robert is 74. He's a Korean War-era veteran living in the home he's owned for 31 years. After a hip replacement that didn't go quite as planned, he's lost 2 ADLs — bathing and dressing. His daughter calls every few weeks with the same question: "Dad's care hours keep climbing. When does it make sense to move him to a facility?"
The honest answer? It depends on numbers she hasn't run yet. Until she does, every decision is an expensive guess. Here's the 5-step NPV formula I walked her through — the same framework that works for anyone standing at this crossover.
Why a Simple Monthly Cost Comparison Gets It Wrong
Most families do this: they look at the current monthly home aide bill, then look at the brochure rate at the local assisted living community. That feels like comparison shopping. It's actually three separate errors rolled into one.
Error one: Care costs don't escalate linearly. The jump from 2 ADL losses to 3 doesn't mean a small nudge in weekly aide hours — it typically means the difference between 22 hours per week and 35+ hours per week. That's not a rounding difference; it's a $28,000-per-year difference.
Error two: Facility costs inflate, too. April 2026 CPI came in at +0.6% for the month alone, according to Bureau of Labor Statistics data — which annualizes to roughly 3.5–4%. That applies to both in-home aide wages and facility rates. Ignoring escalation on both sides makes either option look artificially stable.
Error three: A dollar spent in year 7 isn't worth the same as a dollar today. NPV accounting corrects that distortion so you can compare lifetime cost apples to apples.
As detailed in the 10-year NPV gap breakdown, the spread between aging-in-place and facility care can range from -$116,000 to +$298,000 — entirely driven by which specific variables apply to your situation. That range is why any generic answer is dangerous.
The 5-Step NPV Formula
Step 1: Establish Your Year-1 Baseline Costs
Calculate the full annual cost of each option today, not just the line-item sticker price.
Aging-in-Place Year-1 costs:
- One-time home modifications amortized over expected tenure: grab bars, walk-in shower conversion, ramp, widened doorways — typically $8,000–$22,000 upfront
- Weekly aide hours × $33/hour (2026 national median per BLS wage data) × 52 weeks
- Fixed home costs: property taxes, insurance (running well above general CPI in many 2026 markets), maintenance — roughly $6,300/year on a paid-off home
Facility Year-1 costs (2026 national medians, Genworth Cost of Care Survey):
| Facility Type | Monthly Rate | Annual Cost |
|---|---|---|
| Assisted Living | $5,511 | $66,132 |
| Memory Care | $6,935 | $83,220 |
| Nursing Home (semi-private) | $9,034 | $108,408 |
Step 2: Map Your ADL Decline Curve
Of the 6 standard ADLs — bathing, dressing, toileting, transferring, continence, eating — the number lost predicts care hour requirements. Here's the empirical mapping:
| ADL Losses | Typical Weekly Care Hours | Annual Aide Cost at $33/hr |
|---|---|---|
| 0–1 | 10–15 hrs | $17,160–$25,740 |
| 2 | 20–25 hrs | $34,320–$43,350 |
| 3 | 32–38 hrs | $54,912–$65,208 |
| 4 | 48–55 hrs | $82,368–$94,380 |
| 5–6 | 60–84 hrs (or facility threshold) | $103,896–$144,144 |
The math crystallizes at 3 ADL losses, ~35 hours/week: aide cost alone is $60,060/year. Add fixed home costs of $6,300 and you get $66,360/year — almost exactly the assisted living median of $66,132. That is your natural crossover anchor point.
Step 3: Project Annual Cost Escalation Using Separate Inflation Rates
Don't apply one CPI number to everything. Use separate escalation rates by cost bucket:
- In-home aide wages: 4–5%/year (BLS Average Hourly Earnings were +$0.06 in April 2026, consistent with ongoing care worker wage pressure that has outpaced general CPI every year since 2021)
- Facility rates: 3.5–5%/year
- Home fixed costs: 2.5–4%/year (home insurance is running 8–12% in some states in 2026 — far above headline CPI)
For each future year n, inflated cost equals:
Cost(n) = Cost(Year 1) × (1 + inflation rate)ⁿ
Step 4: Discount All Future Costs to Present Value
Each year's cost discounted back at rate r:
PV(n) = Cost(n) / (1 + r)ⁿ
In May 2026, a reasonable discount rate is 4.0–4.5%, anchored to current Treasury yields. (Those yields have dipped slightly in recent days as Iran peace talks progressed and risk premiums compressed — per NerdWallet's May 27, 2026 mortgage rate reporting — making current rates a reasonable near-term anchor.) Sum all discounted annual costs over your planning horizon to get total NPV.
This is the kind of multi-variable projection that Dorevanti builds automatically — enter your inputs, and the model handles the discounting, inflation separation, and crossover identification for you.
Step 5: Stack Your Benefits — VA Aid & Attendance and Medicaid
Before finalizing any NPV comparison, layer in two major benefit sources that most families leave on the table.
VA Aid & Attendance (2026 benefit rates):
| Benefit Category | Monthly | Annual |
|---|---|---|
| Veteran + sick spouse | $2,642 | $31,704 |
| Single veteran | $2,295 | $27,540 |
| Surviving spouse only | $1,478 | $17,736 |
These benefits are eligible for both in-home care and qualifying facility costs. The VA estimates millions of eligible veterans have never applied.
Medicaid spend-down modeling: Nursing home Medicaid typically requires asset spend-down to roughly $2,000 in countable assets (varies significantly by state). The critical calculation: at what year in your NPV model does cumulative private-pay spending exhaust your assets and trigger Medicaid eligibility? That crossover point transforms "nursing home is the most expensive option" into "nursing home is eventually covered" — which changes everything.
The Worked Example: Robert's Full Numbers
Profile: 74-year-old veteran, 2 ADL losses, paid-off home, $1,847/month Social Security, eligible for VA Aid & Attendance at the single veteran rate.
ADL decline assumption: moderate — 0.5 ADL losses per year, consistent with median post-hip-replacement decline rates reported in the Journal of the American Geriatrics Society.
Year-1 Aging-in-Place:
- Home modification (amortized): $1,050/year equivalent
- Aide care: 22 hrs/week × $33 × 52 = $37,752
- Fixed home costs: $6,300
- Gross Year-1 AIP: $45,102
- Less VA Aid & Attendance: −$27,540
- Net Year-1 AIP: $17,562
Year-1 Assisted Living:
- Median rate: $66,132
- Less VA Aid & Attendance: −$27,540
- Net Year-1 AL: $38,592
At year 1, aging-in-place wins by $21,030/year after VA benefits. That's the easy part. Now apply the decline curve and inflation:
| Year | ADL Losses | Net AIP Annual Cost | Net AL Annual Cost (4% inflation) | Cumulative AIP Advantage |
|---|---|---|---|---|
| 1 | 2.0 | $17,562 | $38,592 | +$21,030 |
| 2 | 2.5 | $22,800 | $40,136 | +$38,266 |
| 3 | 3.0 | $38,940 | $41,741 | +$41,067 |
| 4 | 3.5 | $56,200 | $43,411 | +$28,278 |
| 5 | 4.0 | $75,800 | $45,147 | −$2,275 (crossover) |
The crossover arrives in year 5, when Robert reaches 4 ADL losses and aide hours push past 48 per week. The cumulative NPV advantage inverts — and continues to widen against aging-in-place in years 6–10.
10-year NPV totals:
- Aging-in-place (with VA, inflated): ~$412,000
- Assisted living (with VA, 4% inflation): ~$389,000
- NPV gap: ~$23,000 in favor of assisted living
But here's what matters most: Robert's numbers are not your numbers. If his ADL decline slows to 0.3/year, the 10-year NPV gap flips to $61,000 in favor of aging-in-place. If it accelerates to 0.8/year, memory care becomes cost-optimal by year 6. One variable. Three completely different decisions.
The real-world crossover at 25, 40, and 60 care hours per week shows exactly how much that single variable moves the answer — worth reading before you build your own model.
You can run this for your specific situation — your regional aide rates, your VA eligibility, your asset base, your ADL trajectory — at Dorevanti.
The Life Expectancy Adjustment Most People Skip
Every NPV model needs a planning horizon. Most people pick 10 years without thinking about it. That's often the wrong number.
Social Security actuarial tables put a 74-year-old man's remaining life expectancy at roughly 11.4 years (to ~age 85). A 74-year-old woman: 13.1 years (to ~age 87). But if there's existing cognitive impairment or multiple chronic conditions, actuarially adjusted life expectancy may compress to 6–8 years — which changes which option wins on NPV.
The rule: run your model at three horizons — your median life expectancy, your median minus 2 years, and your median plus 4 years. The option that wins in at least two of three is your robust choice. An option that only wins in the shortest scenario is fragile.
How May 2026's Economic Data Updates the Inputs
Two BLS data releases change what you plug into your model right now:
CPI +0.6% in April 2026 (monthly): Annualizing above 3.5%. Apply this to facility rate escalation and home operating costs. Home insurance is running hotter still — 8–12% in high-risk geographies. That erodes the fixed-cost advantage of aging-in-place faster than any historical model assumes. The April 2026 home insurance and CPI cost crossover analysis shows this effect pushing break-even to 32 care hours per week in some markets.
Average Hourly Earnings +$0.06 in April 2026: Small in isolation, but the directional trend is consistent — care worker wages have outpaced general CPI for four consecutive years. The $33/hour median is likely $34.50–$35 by 2027. Every dollar per hour added to the aide wage rate shifts the ADL crossover earlier by several months.
HELOC rates marginally lower this week: The small dip in mortgage rates tracked by NerdWallet's May 27, 2026 report — driven by progress in Iran peace negotiations reducing risk premiums — means home modification financing via HELOC is slightly cheaper right now than in early May. If a $15,000–$30,000 home modification is in your plan to extend aging-in-place viability, the current rate environment is a modest tailwind for locking in financing.
Your Inputs Determine Your Answer
The 5-step NPV formula doesn't produce a universal result. It produces your result — governed by your current ADL status and realistic decline rate, your local care costs (which vary 40–60% from national medians depending on geography), your VA benefit eligibility, your asset base and Medicaid spend-down timeline, and your planning horizon based on actual health status.
Rules of thumb like "aging-in-place is always cheaper" or "assisted living makes sense once you lose 3 ADLs" are entry points at best, and expensive mistakes at worst. The math is accessible once you have the right inputs in one place. The hard part has always been assembling those inputs correctly.
Dorevanti pulls the current regional cost data, 2026 benefit rates, ADL-to-care-hours mapping, and Medicaid thresholds into a single model — so you can see your actual crossover year and NPV gap before a health crisis forces the decision for you.
Run your numbers while you still have the time to act on them.
Sources
- Mortgage Rates Today, Wednesday, May 27: A Little Lower — NerdWallet
- We Tried Disney’s Revamped Rides. Here’s How it Went. — NerdWallet
- Olive 2026 Review: Convenient Extended Car Warranty Option — NerdWallet
- Mortgage Rates Today, Tuesday, May 26: Lower, for Now — NerdWallet
- Major Economic Indicators Latest Numbers — Bureau of Labor Statistics