How to Calculate Your Aging-in-Place vs Facility Care Cost Crossover in July 2026: 6.98% HELOC Rates, $0.13 Wage Growth, and the 5-Year NPV Math
The Scenario That Forces the Math
Linda is 78. She's had two ADL (activities of daily living) losses so far — bathing and mobility — and needs 25 hours a week of paid in-home help. Her daughter is trying to decide between financing $18,500 in home modifications (curbless shower, stairlift, ramp, widened doorways) to keep Linda in her house of 40 years, or moving her into assisted living at the 2026 national median of $5,350/month.
This isn't a hypothetical for most families — it's a spreadsheet problem with a real answer, and the answer depends entirely on inputs that change month to month: mortgage and HELOC rates, care-worker wage inflation, CPI, and how fast Linda's specific ADL decline curve is moving. Here's what those inputs looked like as of this week, and what they do to the 5-year net present value comparison.
The 5 Inputs Your NPV Formula Needs This Month
Every aging-in-place vs. facility care crossover calculation needs the same five moving parts, and all five shifted in the last few weeks:
- Financing rate for home modifications. Mortgage rates ticked slightly lower on Monday, July 6, 2026, after a softer-than-expected June jobs report. A HELOC used to fund a $18,500 modification budget currently prices around 6.98% — down modestly from the 7.1% range seen earlier this summer.
- Care-worker wage growth. The Bureau of Labor Statistics reported average hourly earnings up $0.13 in June 2026, with unemployment holding at 4.2% and payrolls adding only 57,000 jobs — a labor market too tight to expect home health aide wages to cool off. Aide wages tend to run hotter than the broad average because direct-care labor is chronically short-staffed; a $34.75/hour blended national rate growing near 6.2% annually is a reasonable planning assumption right now.
- General cost inflation. May 2026 CPI came in at +0.5% month-over-month, which annualizes to roughly 6.17% — the rate you should apply to facility base rates, property taxes, insurance, and home maintenance.
- Discount rate. Use your financing cost (the HELOC rate) as the discount rate if you're borrowing to fund either path; it's the true opportunity cost of the capital involved.
- ADL decline slope. This is the variable unique to your situation, and it's the one no calculator can guess for you.
This is the kind of analysis Dorevanti runs for you — so you don't have to build the spreadsheet yourself.
The 5-Year Cost Table (July 2026 Numbers)
Using Linda's actual ADL trajectory — care hours escalating from 25/week to 44/week over five years as she loses two more ADLs (transferring around year 2, toileting around year 4) — here's what the four paths cost in net present value, discounted at 6.98%:
| Path | Year 1 (nominal) | Year 5 (nominal) | 5-Year Cumulative NPV |
|---|---|---|---|
| Aging in place | $54,375 | $112,799 | $341,538 |
| Assisted living | $64,200 | $81,665 | $299,677 |
| Memory care (if cognitive decline occurs) | $82,800 | $105,246 | $385,219 |
| Nursing home (semi-private) | $117,600 | $149,439 | $545,410 |
Aging in place includes the $18,500 upfront modification cost plus escalating in-home care hours and home-carrying costs (taxes, insurance, maintenance) rising at CPI. Facility figures include a $4,000 one-time community/move-in fee and escalate at CPI only, with no additional care-level upcharges modeled — which matters, because upcharges are real and usually missing from glossy brochure pricing.
Where the Crossover Actually Happens
Here's the finding that surprises most families: in Linda's specific scenario, assisted living is cheaper than aging in place in every single year, not just eventually. The gap starts at $5,318 in year 1 and widens to nearly $42,000 by year 5. That's the opposite of the "aging in place is always cheaper up front" assumption most people start with.
Why? Two things are doing the damage: the $18,500 modification cost hits immediately, and her care hours are escalating fast — 25 to 44 hours a week in five years — while facility pricing (in this model) only grows with CPI. When hourly wages are compounding at 6.2% on top of a rising hour count, in-home costs escalate on two axes simultaneously. Facility pricing escalates on one.
This mirrors what we found in the 10-year NPV gap comparison across aging in place, assisted living, memory care, and nursing home: the ADL decline rate is the single variable that decides which side of the ledger you land on. Slow decline (say, care hours growing to only 30/week over five years instead of 44) can flip this same scenario back in aging-in-place's favor, because the fixed modification cost gets amortized over a much gentler care-hour curve. If you want to see how sensitive your own numbers are to hour growth, the home health aide wage crossover analysis walks through the wage side of that sensitivity in detail.
You can model this for your specific situation at Dorevanti — plug in your own ADL trajectory instead of Linda's and watch where your crossover point actually falls.
Financing the Gap: HELOC vs. 0% APR Card
If aging in place is the right call for your ADL curve, the $18,500 modification budget still needs to be financed, and July 2026 gives you two real options:
- HELOC at ~6.98%. Best for modification budgets you can't pay off quickly, since the rate is fixed for the draw period and there's no cliff.
- 0% intro APR credit card. According to NerdWallet's real-application approval data, 0% APR card approvals cluster heavily among applicants with credit scores of 720 and above — below that threshold, approval odds drop off fast. If the family member managing finances has strong credit, a 15-month 0% APR window can cover the full $18,500 interest-free, provided it's paid off before the promotional period ends. Miss that window and the rate typically reverts to 24.99%+, which erases the advantage instantly.
For most families, the HELOC is the safer default; the 0% card only makes sense if you're confident the balance clears within the promo term.
Medicaid Spend-Down and VA Aid & Attendance Stacking
If Linda's care needs escalate toward the nursing home column, Medicaid spend-down modeling becomes unavoidable. Medicaid's five-year look-back period and asset limits (roughly $2,000 for an individual, with a community spouse resource allowance in the $154,000 range depending on state) mean asset restructuring has to start years before the money actually runs out — not after.
This is where the choice between a CPA, an enrolled agent, and DIY software (the exact decision tree NerdWallet lays out for small-business tax services) applies almost directly to elder-law tax planning. Qualified Income Trusts, gifting strategies, and asset re-titling all have tax consequences that a generalist DIY tool won't catch. Budgeting $3,000–$6,000 for a combined elder-law attorney and tax professional is common — and it's frequently the difference between qualifying for Medicaid on schedule versus facing a penalty period that can run tens of thousands of dollars deep.
VA Aid & Attendance benefits stack on top of whichever path you choose if Linda's spouse (or Linda herself) is a wartime veteran — the 2026 max benefit runs close to $2,795/month for a married veteran, which can offset either in-home care hours or a portion of assisted living/memory care fees. For the full formula on how CPI, Social Security timing, and this benefit combine, see the Social Security and CPI-adjusted NPV formula for nursing home comparisons.
Life Expectancy Changes Everything
A 5-year NPV window is a starting point, not the full picture. SSA actuarial tables put a 78-year-old woman's average remaining life expectancy at roughly 11 more years. Run the same model out to year 11 instead of year 5, and the picture shifts again: in-home care hours can't realistically escalate past 24/7 coverage (168 hours/week), which creates a hard ceiling — but facilities keep compounding at CPI indefinitely with no ceiling of their own. Depending on how close Linda's hour count gets to that ceiling by year 8 or 9, the long-run math can flip back toward facility care even in scenarios where aging in place looked competitive at year 5.
This is exactly why the 12-year facility care cost gap analysis found the gap narrowing to just $25,000 over a longer horizon under current HELOC and CPI conditions — short and long time horizons can point in genuinely different directions for the same person.
Run Your Own Numbers
Linda's numbers aren't your numbers. Your ADL decline rate, your local wage rates, your home equity, your veteran status, your family's credit profile — every one of those inputs moves the crossover point, sometimes by years, sometimes by tens of thousands of dollars. The math doesn't care which answer feels more comfortable; it just needs your actual variables.
That's what Dorevanti is built for — plug in your specific ADL trajectory, financing rate, and life expectancy adjustment, and get an individualized NPV projection instead of a national median that may not apply to your situation at all.
Sources
- A Guide to Small-Business Tax Services — NerdWallet
- Delta Amex Cards Offer Valuable Travel Benefits This Summer — NerdWallet
- What Credit Score Do You Need for a 0% APR Credit Card? (Based on Real Applications) — NerdWallet
- Mortgage Rates Today, Monday, July 6: Slightly Lower — NerdWallet
- Major Economic Indicators Latest Numbers — Bureau of Labor Statistics