How to Calculate Your Aging-in-Place vs Assisted Living Cost Crossover in July 2026: The 5-Input NPV Formula With 0.5% CPI, 7.1% HELOC Rates, and VA Aid & Attendance Stacking
The question nobody can answer with a rule of thumb
"Should Mom age in place or move to assisted living?" gets asked in every family Facebook group, every Sunday phone call, every hospital discharge meeting. And it almost always gets answered with a feeling — "she wants to stay in her house" or "we're worried about her being alone" — instead of a number.
Here's the thing: the math actually exists. It's not simple, but it's calculable, and as of July 2026 we have fresh inputs to run it with. The Bureau of Labor Statistics just reported May 2026 CPI at +0.5% month-over-month (that annualizes to roughly 6.2% if it held steady) and average hourly earnings up $0.12, which matters directly for home health aide wages. Meanwhile, NerdWallet's July 1 mortgage rate update shows rates "a little higher" — HELOC pricing is sitting around 7.1% for a lot of borrowers, which is the financing cost if you're funding home modifications out of home equity.
Those aren't abstract econ headlines. They're literally two of the five inputs that determine which side of the aging-in-place-vs-assisted-living math wins for your specific family. Let's build the formula.
The 5-input NPV formula
To compare aging in place against assisted living honestly, you need to net present value (NPV) both paths over the same time horizon, using the same discount rate, so you're comparing apples to apples across years of unequal cash flows.
Input 1 — Home modification cost (Year 0 outlay). Grab bars, a stairlift, a walk-in tub, widened doorways, ramp — a realistic mid-range package runs $18,500.
Input 2 — Discount rate (cost of capital). If you're financing modifications through a HELOC, July 2026's ~7.1% rate is your real discount rate — it's what your money actually costs you.
Input 3 — Care cost escalation rate. In-home aide wages track average hourly earnings growth. At $0.12/hour growth on a roughly $33/hour 2026 aide wage, that's about a 0.36% monthly increase — annualized, call it 4.5%/year.
Input 4 — Facility cost escalation rate. Assisted living pricing tends to move with broader CPI, not just wage data, since it bundles food, utilities, insurance, and staffing. At May 2026's 0.5% monthly CPI held annualized, that's about 6.2%/year.
Input 5 — VA Aid & Attendance benefit (if applicable). For a single veteran meeting the aid & attendance criteria, the 2026 monthly benefit runs approximately $2,358/month ($28,296/year), and it can be stacked against either aging-in-place care costs or facility costs — this is the input people forget to model, and it's often the deciding variable.
This is the exact formula Dorevanti runs automatically, pulling live rate and wage data instead of making you track down BLS releases yourself.
Worked example: 25 care hours/week, single veteran, 5-year horizon
Let's say Dad needs about 25 hours/week of care support — two ADLs affected (bathing and mobility), still cognitively sharp, wants to stay in his house of 40 years if the math supports it.
Aging in place
- Year 0: $18,500 home modification
- Year 1 in-home care: 25 hrs/week × $33/hr × 52 weeks = $42,900, escalating 4.5%/year
| Year | Care cost | Discounted @ 7.1% |
|---|---|---|
| 0 | $18,500 (mod) | $18,500 |
| 1 | $42,900 | $40,056 |
| 2 | $44,831 | $39,078 |
| 3 | $46,848 | $38,120 |
| 4 | $48,956 | $37,199 |
| 5 | $51,159 | $36,309 |
Aging-in-place NPV, 5 years: $209,262
Assisted living, without VA benefit
Median assisted living runs about $5,900/month ($70,800/year) in most mid-cost metros, escalating 6.2%/year, plus a one-time $4,000 community fee.
| Year | AL cost | Discounted @ 7.1% |
|---|---|---|
| 0 | $4,000 (fee) | $4,000 |
| 1 | $70,800 | $66,106 |
| 2 | $75,168 | $65,536 |
| 3 | $79,806 | $64,935 |
| 4 | $84,731 | $64,391 |
| 5 | $89,960 | $63,847 |
Assisted living NPV, 5 years, no VA benefit: $328,815
At this point, aging in place wins by nearly $120,000. That's the number most people stop at — and it's incomplete.
Assisted living, WITH VA Aid & Attendance stacked
Now subtract the $28,296/year VA benefit (also escalating with CPI, since COLA adjustments track it) from the facility cost before discounting:
| Year | Net AL cost after VA | Discounted @ 7.1% |
|---|---|---|
| 0 | $4,000 | $4,000 |
| 1 | $42,504 | $39,687 |
| 2 | $45,126 | $39,342 |
| 3 | $47,906 | $38,980 |
| 4 | $50,856 | $38,644 |
| 5 | $53,985 | $38,308 |
Assisted living NPV, 5 years, WITH VA benefit: $198,961
The crossover flip
| Scenario | 5-Year NPV |
|---|---|
| Aging in place | $209,262 |
| Assisted living, no VA benefit | $328,815 |
| Assisted living, with VA A&A stacked | $198,961 |
Without the VA benefit, aging in place beats assisted living by about $119,500. With it stacked in, assisted living beats aging in place by about $10,300. That's a $130,000 swing on a single input — whether or not the family knew to apply for and stack a benefit that exists for exactly this purpose.
This is the mechanism behind the 8-variable checklist approach: no single number tells you the answer. It's the interaction between your care hours, your financing rate, and your benefit eligibility that does.
Sensitivity check: what if care hours climb to 35?
ADL decline doesn't happen linearly — it accelerates. If Dad's care hours rise to 35/week by year 3 (a common escalation curve as a second ADL becomes impaired), aging-in-place Year 3–5 costs jump roughly 40%, pushing the 5-year NPV to around $245,000 — well above even the no-VA assisted living number. This is why the care needs escalation curve matters as much as the starting hours: your crossover point isn't fixed, it moves as ADL loss compounds. You can model this for your specific situation — including your own projected ADL trajectory — at Dorevanti.
The pieces people forget to model
Medicaid spend-down timing. If facility care becomes unavoidable and private funds run out, the asset spend-down clock starts the moment you apply — assets above your state's limit (often around $2,000 for an individual, with home equity exemptions up to roughly $730,000 in many states for 2026) get counted. Modeling when you'd hit that threshold changes which path preserves more legacy assets. This deserves its own full spreadsheet — see the NPV formula walkthrough for the mechanics.
Uncovered medical costs. Dental work, non-covered procedures, and urgent healthcare gaps don't pause for your 5-year model. NerdWallet's breakdown of CareCredit-eligible expenses is a useful reminder that vet, dental, and cosmetic-adjacent procedures often aren't covered by Medicare or standard insurance — and these show up disproportionately in aging populations. Budget a contingency line, not a hope.
Vehicle costs if aging in place. If the plan is staying home, someone still needs transportation for appointments and errands — either Dad's own aging vehicle (where an extended warranty for older vehicles might cap repair risk) or a paid driver service layered onto the in-home care hours already budgeted above.
Actually knowing your monthly number. Before running any 5-year NPV, you need an accurate baseline of current spending. NerdWallet's 50/30/20 budget story is a good gut-check: most families underestimate their own monthly baseline by 15–20% before they sit down and actually track it. That gap compounds across a 5-year projection just like everything else here.
Your numbers will differ
This example used 25 care hours/week, a single veteran with A&A eligibility, a $18,500 modification budget, and July 2026's specific rate environment. Change any one variable — 35 hours instead of 25, no VA eligibility, a $9,000 modification instead of $18,500, a 3-year horizon instead of 5 — and the crossover point moves, sometimes dramatically, as shown above.
That's the whole point of running this as a formula instead of a feeling. The 6-gate decision framework and the 7-question framework both exist because the "right" answer genuinely depends on inputs unique to your family — not a national average.
If you want your own version of the table above, built with your actual home modification quote, your family member's actual ADL count, current mortgage/HELOC rates, and VA eligibility status, you can run it at Dorevanti — it pulls live rate and wage data so you're not stuck guessing which July 2026 numbers still apply by the time you're done reading.
Sources
- Major Economic Indicators Latest Numbers — Bureau of Labor Statistics
- Mortgage Rates Today, Wednesday, July 1: A Little Higher — NerdWallet
- My Credit Card Bills Were Spiraling Every Month — Until I Tried This — NerdWallet
- Premier Auto Protect 2026 Review: Lowest-Cost Extended Car Warranty for Older Vehicles — NerdWallet
- When Insurance Doesn’t Cover It: 3 Big Healthcare Expenses CareCredit Can Help With — NerdWallet