How to Calculate Your Aging-in-Place vs Facility Care Cost Crossover at 7% Mortgage Rates: The 5-Step NPV Formula and a $9,144 Gap (September 2026)
The Number That Should Make You Pause: $9,144
Run the aging-in-place vs. facility care numbers for an 8-year horizon with today's data — mortgage rates over 7% as of Monday, September 14, 2026, per NerdWallet's daily rate tracker, 0.4% monthly CPI growth from the Bureau of Labor Statistics' August 2026 release, and wage growth that's crawled to just $0.10 an hour — and you can land a net present value gap between the two paths of roughly $9,144 over eight years. On a decision that involves hundreds of thousands of dollars, that's a coin flip.
That's the point of this post. It's not to tell you aging in place wins or facility care wins. It's to show you the actual formula — the five inputs that move the number — so you can plug in your own numbers and see which side of the coin your specific situation lands on. Because a gap that small means the "right answer" isn't universal. It's yours to calculate.
Step 1: Set Your Time Horizon With a Life Expectancy Adjustment
Every cost comparison starts with a wrong assumption: that you're comparing costs "forever." You're not. You're comparing costs over a specific number of years, and that number should come from an honest life expectancy estimate — not a round number like "10 years" because it's easy to type into a spreadsheet.
This is where NerdWallet's piece on the "Die with Zero" philosophy is actually more relevant to care planning than it looks at first glance. The core argument isn't about spending recklessly — it's about matching your spending curve to your actual remaining years instead of hoarding against a horizon that doesn't reflect your health, family history, or current functional status. Applied to care cost modeling, that means: don't run your NPV comparison over a generic 15- or 20-year window if your health profile, family history, and current ADL status point to something shorter. An over-long horizon systematically favors facility care (whose costs plateau once you're in) over aging in place (whose costs escalate with need). An artificially short horizon does the opposite.
For our worked example below, we'll use 8 years — a mid-range estimate for a 78-year-old with two current ADL losses. Your number needs to come from your own actuarial inputs, which is exactly the kind of individualized adjustment Dorevanti builds into its projections instead of defaulting to a flat national average.
Step 2: Model the ADL Decline Curve, Not a Static Care Level
The single biggest error in DIY cost comparisons is pricing one care level and holding it flat for the entire horizon. Real care needs escalate. Someone at 2 ADL losses today (help with bathing and mobility, say) is very plausibly at 4–5 ADL losses in 5–7 years, and the jump from "25 hours a week of home health aide" to "60 hours a week" roughly triples your in-home cost — a curve that's mapped in more detail in Aging in Place vs Assisted Living vs Memory Care vs Nursing Home: The NPV Gap Ranges From -$116,000 to +$298,000 Over 10 Years.
For this example, we'll step the care level up every two years:
- Years 1–2: 25 hours/week (2 ADL losses)
- Years 3–4: 35 hours/week (3 ADL losses)
- Years 5–6: 45 hours/week (4 ADL losses)
- Years 7–8: 60 hours/week (5 ADL losses, near-total care)
On the facility side, that same decline means a transition from assisted living (years 1–4) to nursing-home-level care (years 5–8), since most assisted living communities can't handle ADL 4–5 without a memory care or skilled nursing transfer.
Step 3: Price Aging in Place With This Week's Actual Financing and Wage Data
This is where September 2026's market conditions matter, and they matter in a way that's easy to miss if you're using a generic calculator.
Home modification financing. NerdWallet's Friday and Monday rate trackers both show mortgage rates sitting just below and then above 7%, with markets pricing in a Fed rate hike this week — pushing HELOC pricing up alongside it. If you're financing a $48,000 accessibility retrofit (walk-in shower, stair lift, widened doorways, ramp) through a HELOC rather than paying cash, you're now borrowing that money at over 7%, not the 5–6% HELOC pricing that was available even a year ago. That's roughly $3,400 a year in interest cost on the modification alone if you carry it as a balance — a real cost that a flat "$48,000 upfront" line item hides. This is a live variable, and it's exactly why How to Calculate Your Aging-in-Place vs Assisted Living Cost Crossover: HELOC Volatility, $2,250 Insurance Gap, and Your ADL Decline Rate treats HELOC rates as a first-class input rather than a footnote.
Aide wage escalation. The BLS's August 2026 release shows average hourly earnings up just $0.10 and unemployment holding at 4.1% — a labor market that's cooling, not tightening. Translated into home health aide wages, that's roughly 3.3% annual growth, slower than the 5%+ escalation many calculators assume by default. That single assumption change can swing your in-home NPV by tens of thousands of dollars over an 8-year horizon.
Running the numbers with a $34/hour starting aide wage, 3.3% annual wage growth, and $9,000/year in home carrying costs (property tax, insurance, maintenance) escalating at CPI's current 4.8% annualized pace:
| Year | Aide Hours/Week | Care Cost | Home Costs | Total |
|---|---|---|---|---|
| 1 | 25 | $44,200 | $9,000 | $53,200 |
| 3 | 35 | $66,020 | $9,885 | $75,905 |
| 5 | 45 | $90,589 | $10,857 | $101,446 |
| 8 | 60 | $133,162 | $12,496 | $145,658 |
Add the $48,000 modification cost up front, and the gross 8-year NPV (discounted at 5%) for aging in place comes to roughly $635,348.
Step 4: Price the Facility Path With the Same Escalation Logic
Using $5,500/month for assisted living (years 1–4) transitioning to $10,500/month for nursing-home-level care (years 5–8), escalated at the same 4.8% CPI-linked rate, and discounted at 5%:
| Year | Setting | Annual Cost |
|---|---|---|
| 1 | Assisted Living | $66,000 |
| 4 | Assisted Living | $75,980 |
| 5 | Nursing Home | $126,000 |
| 8 | Nursing Home | $145,029 |
Gross 8-year NPV for the facility path: roughly $644,492.
This is the kind of side-by-side breakdown Dorevanti runs for you automatically — so you don't have to build eight years of escalating spreadsheet rows by hand.
Step 5: Stack VA Aid & Attendance and Discount to a Final Number
If you or your spouse is a wartime-era veteran, VA Aid & Attendance can offset either path — roughly $33,540/year for a veteran with a spouse at current rates. That benefit applies whether you're paying an aide at home or a facility, so it discounts both sides similarly rather than tilting the comparison. Discounted over 8 years at 5%, that benefit is worth about $216,745 in NPV terms to whichever path you choose.
Applying it to both sides:
| Gross NPV | VA A&A (NPV) | Net NPV | |
|---|---|---|---|
| Aging in Place | $635,348 | -$216,745 | $418,603 |
| Facility Care | $644,492 | -$216,745 | $427,747 |
Gap: $9,144 in favor of aging in place — over an 8-year horizon, with this specific set of inputs.
Why That Number Will Move for You
Change any one input and the gap flips. Push wage growth from 3.3% to 5% (a plausible scenario if the labor market tightens again) and aging in place pulls further ahead. Extend the horizon to 12 years using a more conservative life expectancy assumption and facility care's flat post-Medicaid-spend-down cost ceiling starts to look better, since nursing home care is covered by Medicaid in every state once assets are spent down, while in-home aide hours generally aren't covered at the same level outside of narrower HCBS waiver programs. That spend-down timeline — and whether it happens in year 4 or year 9 of your horizon — is one of the single biggest levers in this whole calculation, and it's highly personal to your asset base, not something a generic calculator should guess for you.
This is also where the "Die with Zero" framing from Step 1 comes back in: if your realistic life expectancy is 6 years rather than 12, the calculation you should be running is fundamentally different from your neighbor's, even if your care needs look identical today. The same is true if you're weighing a Social Security claiming decision alongside this — see How Social Security Claiming Age (62 vs 70) Shifts Your Care Cost Break-Even by $147,000 Over 15 Years for how that interacts with the same NPV math.
The Takeaway
A $9,144 gap on a $600,000+ decision isn't a verdict — it's a sign that the honest answer is "it depends on your inputs," and that generic advice ("age in place as long as possible" or "move before a crisis forces it") is exactly the wrong instinct here. Your ADL decline speed, your local aide wages, your HELOC rate, your VA eligibility, and your realistic life expectancy are the five levers, and small, honest changes to any one of them can swing six figures over a decade.
You can run this exact five-step formula with your own numbers — your home's modification cost, your region's aide wages, your actual ADL trajectory, your VA and Medicaid eligibility, and a life expectancy estimate that reflects your real health picture — at Dorevanti, rather than reverse-engineering a spreadsheet from a blog post's example numbers.
Sources
- Mortgage Rates Today, Monday, September 14: Over 7% — NerdWallet
- Should You Really Try to ‘Die with Zero’? — NerdWallet
- Major Economic Indicators Latest Numbers — Bureau of Labor Statistics
- 7 Reasons NerdWallet Calls Chase Sapphire a “Must-Have for Travelers” — NerdWallet
- Mortgage Rates Today, Friday, September 11: Just Below 7% — NerdWallet