How to Calculate Your Aging-in-Place vs Assisted Living Cost Crossover: The Step-by-Step NPV Formula With Real 2026 Numbers
How to Calculate Your Aging-in-Place vs Assisted Living Cost Crossover: The Step-by-Step NPV Formula With Real 2026 Numbers
Most people pick between aging in place and a care facility by gut feeling — by what feels right, what the family can agree on, or what a social worker mentions offhandedly. The problem is that gut feelings don't compound. Costs do.
Here's what's actually happening in 2026: the Bureau of Labor Statistics just recorded a +0.9% CPI increase in March 2026 alone — that's a single month. Annualized, that's roughly 10.8%. Add in what economists are calling "warflation" — Iran-war-driven spikes in gas, diesel, food, and supply-chain costs documented by NerdWallet — and the care cost inflation assumptions baked into most calculators are dangerously stale.
If you're trying to figure out whether keeping Mom at home or moving her to assisted living makes financial sense, you need an actual formula. Not a rule of thumb. Here's the one I use.
The 5-Step NPV Framework
Net Present Value (NPV) lets you compare options that have different costs at different points in time, all in today's dollars. For aging-in-place vs. facility care, it's the only honest way to run the numbers — because costs don't stay static and neither does the level of care needed.
The core formula for each option:
NPV = sum over each year t of: Annual Cost(t) divided by (1 + r) to the power of t
Where r = your discount rate (typically 4–5%, reflecting current opportunity cost of capital) and Annual Cost(t) = projected care + housing costs in year t, adjusted for both general inflation AND care needs escalation.
Let's walk through each step with real numbers.
Step 1: Establish Your Baseline Costs Right Now
Before projecting anything, you need accurate Year 1 inputs. Here's where 2026 actually lands:
| Care Setting | Monthly Cost | Annual Cost |
|---|---|---|
| Home health aide (25 hrs/wk, $33/hr) | $3,575 | $42,900 |
| Home health aide (40 hrs/wk, $33/hr) | $5,720 | $68,640 |
| Home health aide (60 hrs/wk, $33/hr) | $8,580 | $102,960 |
| Assisted living (national median) | $6,200 | $74,400 |
| Memory care (national median) | $7,800 | $93,600 |
| Nursing home, semi-private (national median) | $8,929 | $107,148 |
For aging in place, you add household carrying costs — utilities, property taxes, food, maintenance — which typically run $18,000–$26,000/year depending on region, plus a one-time home modification cost of $20,000–$55,000 (ramp installations, grab bars, bathroom conversions, stair lifts). Amortize modifications over the expected stay duration.
For facility care, the sticker price is largely all-in, but watch for add-ons: medication management, incontinence supplies, extra transportation, and level-of-care fees that trigger automatically when ADLs decline.
As noted in our earlier deep-dive, the crossover at 25, 40, and 60 care hours per week moves dramatically — 25 hours/week tilts strongly toward aging in place, while 60 hours/week makes almost any facility look cheap by comparison.
Step 2: Map the ADL Decline Curve
This is the variable most calculators ignore entirely. Activities of Daily Living (ADLs) — bathing, dressing, toileting, transferring, continence, feeding — don't decline at a constant rate. They decline in steps, and each step escalates care hours sharply.
A reasonable planning benchmark based on clinical literature:
| ADL Losses | Typical Care Hours Needed | Care Intensity Stage |
|---|---|---|
| 1–2 ADLs | 15–25 hours/week | Light |
| 3 ADLs | 30–45 hours/week | Moderate |
| 4–5 ADLs | 50–70+ hours/week | Heavy |
| 6 ADLs (full dependency) | 24/7 → facility threshold | Memory care / SNF |
For planning purposes, model one additional ADL loss roughly every 2–3 years for a typical 78–82-year-old — faster if there's a dementia diagnosis or recent hospitalization. This means your Year 5 and Year 8 cost projections look nothing like Year 1. If you don't model the escalation, you're comparing today's cost of aging in place against a facility's full future cost — and that math is rigged.
Step 3: Apply Warflation-Adjusted Care Cost Inflation
Here's where 2026 breaks from historical models. The traditional assumption has been 3–4% annual inflation on care costs. That was defensible through 2023. It isn't now.
The BLS reported CPI up 0.9% in a single month (March 2026), driven in part by energy and supply-chain disruptions. NerdWallet's warflation analysis ties this to Iran-related fuel price spikes rippling into food, diesel (which affects aide commutes and medical supply deliveries), and broader goods pricing.
For home health aides specifically: agencies pass through fuel and labor cost increases rapidly. The $33/hour median for 2026 may already be $34.50–$35 by Q4 in high-cost metros.
For your NPV model, use these inflation rate scenarios:
| Scenario | Care Cost Inflation | General Household Inflation |
|---|---|---|
| Conservative | 4.5%/year | 3.0%/year |
| Base Case (2026 context) | 6.0%/year | 4.5%/year |
| Warflation Stress Test | 8.0%/year | 6.0%/year |
Run all three. The difference between 4.5% and 8.0% compounded over 8 years is not marginal — it's the difference between aging in place "barely winning" and being $180,000 underwater on the NPV comparison.
This is exactly the kind of multi-scenario sensitivity analysis that Dorevanti runs automatically — so you're not manually building five versions of the same spreadsheet.
Step 4: Run the NPV — A Worked Example
Meet Margaret: 79 years old, suburban homeowner, 2 ADL losses (bathing and dressing), no VA benefits, $380,000 in home equity, expects to need care for 10 years. Discount rate: 4.5%.
Aging in Place — Year-by-Year Cost Projection (Base Case, 6% inflation):
| Year | ADL Losses | Hrs/Wk | Aide Cost | Household | Mods (amort.) | Total |
|---|---|---|---|---|---|---|
| 1 | 2 | 28 | $48,048 | $22,000 | $3,500 | $73,548 |
| 3 | 3 | 40 | $60,652 | $24,742 | $3,500 | $88,894 |
| 5 | 4 | 55 | $91,080 | $27,826 | $3,500 | $122,406 |
| 8 | 5–6 | 70+ | $136,000+ | $31,300 | — | $167,300+ |
Assisted Living — Year-by-Year (Base Case, 6% inflation):
| Year | Base Rate | Level-of-Care Add-on | Total |
|---|---|---|---|
| 1 | $74,400 | $0 | $74,400 |
| 3 | $83,622 | $4,800 | $88,422 |
| 5 | $94,012 | $9,600 | $103,612 |
| 8 | $111,816 | $14,400 → memory care | $149,000+ |
10-Year NPV at 4.5% discount rate:
- Aging in place: approximately $697,000
- Assisted living (transitioning to memory care at Year 7): approximately $648,000
The crossover happens around Year 3–4 in this scenario. Assisted living wins on NPV by roughly $49,000 over a 10-year horizon — but your numbers will differ significantly based on your specific ADL trajectory, local aide wages, facility rates, and whether VA benefits or Medicaid apply.
For a deeper look at exactly when the 3-ADL-loss threshold triggers the crossover, see our analysis at Aging in Place vs Assisted Living: The Year-4 Cost Crossover When ADL Losses Hit 3.
Step 5: Stack Your Modifiers
The base NPV calculation above is just the skeleton. Three modifiers can swing the outcome by $100,000 or more:
VA Aid & Attendance: If your loved one served in the military, VA Aid & Attendance can pay up to $2,727/month (2026 rates) for a surviving spouse, or $3,261/month for a veteran with a dependent. Stacked into the aging-in-place NPV, that's $32,724–$39,132/year in tax-free benefit that offsets aide costs directly. This alone can shift the 10-year NPV by $180,000+ in favor of aging in place.
Medicaid Spend-Down: In most states, Medicaid covers nursing home care once assets are spent down to $2,000–$3,000. The critical calculation is the spend-down trajectory: at Margaret's $380,000 home equity plus $120,000 in savings, she has approximately $498,000 in countable assets. At $107,148/year nursing home costs (before Medicaid kicks in), she'd spend down in roughly 4.6 years. The NPV of Medicaid eligibility — and how to reach it without violating 5-year lookback rules — is a major variable many families miss entirely. Our breakdown of Medicaid spend-down modeling and the nursing home crossover at different ADL levels walks through this in detail.
Life Expectancy Adjustment: A 10-year planning horizon isn't right for everyone. A 79-year-old woman in average health has a life expectancy of approximately 10.2 additional years per Social Security actuarial tables — but with 2 ADL losses already, that adjusts downward. A 7-year horizon changes the NPV comparison materially, as the compounded cost escalation in Years 8–10 never fully hits. Always run 5-year, 7-year, and 10-year scenarios.
Dorevanti lets you input actual VA benefit amounts, your state's Medicaid rules, and a personalized life expectancy adjustment so the model reflects your situation — not a national average.
The Variables That Will Change Your Answer
If you take one thing from this: the formula is the same for everyone, but the inputs are not. Here's what moves the needle most:
- Local aide wages — $33/hour is the national median. In San Francisco it's $42+. In rural Alabama it's $22. That's a $52,000/year swing at 60 hrs/week.
- Facility quality tier — median ALF rates range from $4,200/month (rural Midwest) to $9,800/month (coastal metros)
- ADL decline velocity — dementia diagnoses accelerate this dramatically
- Care hours per week today — as we've shown, the break-even at 38 care hours per week has already shifted under warflation pressure
- Mortgage rates — with rates edging lower per NerdWallet's April 10 report, the opportunity cost of home equity has shifted. Refinancing or a reverse mortgage to fund aging-in-place costs may now pencil out differently than it did 18 months ago.
Run It for Your Situation
The math in this post is real, but it's built on a composite scenario. Margaret's numbers are not your numbers. Your parent's ADL trajectory, your state's Medicaid rules, your local aide market, your VA benefit eligibility — these are what determine whether aging in place saves $49,000 or costs $210,000 more over a decade.
The formula exists. The data exists. The question is whether you apply it to your specific situation before the decision gets made by default — which is always the most expensive way to make it.
Run the numbers for your situation at Dorevanti — NPV comparison, ADL escalation curves, Medicaid spend-down modeling, and VA benefit stacking, built for your inputs, not a national average.
Sources
- Graduate School Loans: Limits Impacting Future Borrowers — NerdWallet
- Major Economic Indicators Latest Numbers — Bureau of Labor Statistics
- ‘Warflation’ Will Hit More Than Just Gas Prices — NerdWallet
- Mortgage Rates Today, Friday, April 10: A Modest Drop — NerdWallet
- PNC Bank’s New Loyalty Program Offers Credit Card Rewards Boost — NerdWallet