Skip to content
Research
KnowledgeVisuals
Pricing↗Open the workspace↗Get a free API key↗
.orgResearchResearch — current site.netWorkspace↗Workspace — opens riskmodels.net.appAPI↗API — opens riskmodels.app
Next filing · Form N-PORT · Q3 2026 · 8 days
Next filing · Form N-PORT · Q3 2026 · 8 daysAPI Update · Point-in-Time (PIT) historical commit tracking — securities and funds unifiedAPI Update · ERM3 L3 variance partition — institutional transparency releaseFactor Research · L-Star adaptive hedge depth — out-of-sample validation across ten allocator universesPart 1 · One Position, Four BetsPart 2 · Risk Structure in 13F FilingsNext filing · Form N-PORT · Q3 2026 · 8 daysAPI Update · Point-in-Time (PIT) historical commit tracking — securities and funds unifiedAPI Update · ERM3 L3 variance partition — institutional transparency releaseFactor Research · L-Star adaptive hedge depth — out-of-sample validation across ten allocator universesPart 1 · One Position, Four BetsPart 2 · Risk Structure in 13F Filings
Ledger
← Research
PublishedWorked example · ERM3 data 2026-11-13

Paying down a mortgage with employer stock

What a portfolio risk model adds to a homeowner's paydown decision

Conrad Gann · Blue Water Macro · Worked example · November 2026


Summary. A homeowner four years from retirement holds a $300,000 taxable brokerage account. A third of it is their employer's stock, and they ask whether to sell some of it to pay down a 6.25% fixed-rate mortgage. The loan arithmetic is computed with RefiGeek. Each paydown of $25,000, $50,000 or $100,000 shortens the loan by 3 years 10 months, 6 years 11 months or 11 years 9 months and saves $98,157, $172,419 or $277,114 of interest. Over four years it comes out ahead of holding the same money in Treasury bills by $2,562, $5,124 or $10,249 before tax. The investment side is measured with ERM3. Counting the two index funds in the account, the employer stock is 38.3% of the account. ERM3 attributes 47.6% of the stock's daily variance to the company itself, as of 2026-11-13. Selling NVIDIA to fund the paydown reduces its weight in the remaining account from 38.3% to 32.7%, 26.0%, or 7.5%, respectively. The loan figures establish what the paydown changes in the mortgage. The concentration figures establish what the sale changes in the household's risk. Taxes, cash reserves and the household's other accounts determine the decision and are outside both sets of figures.

The household is hypothetical. The securities, their fund holdings and every risk figure are ERM3 data as of the dates given.


1. The question

The homeowner's question combines two decisions. The first concerns the mortgage: whether reducing a 6.25% loan improves the household's position before retirement. The second concerns the investments: how much exposure to a single company the household keeps under each choice. A mortgage calculator answers the first. A brokerage statement shows the dollar value of the employer stock, and it omits the same company held inside the account's funds.

2. The household

ItemValue
Loan30-year fixed at 6.25%, balance $420,000, 330 payments of $2,668 remaining
AccountTaxable brokerage, $300,000
HoldingsNVIDIA (employer) $100,000; Vanguard Total Stock Market (VTI) $120,000; Invesco QQQ $80,000
HorizonRetirement in about four years

3. The mortgage arithmetic

Each paydown is computed from the loan's own terms. In the first case the scheduled payment stays the same and the loan ends earlier. In the second the servicer re-amortises the lower balance over the remaining term (a recast), so the payment falls and the end date stays. The horizon comparison holds the payments equal in both paths, saves any freed payment at the alternative rate, and compares the result with keeping the lump sum in 3-month Treasury bills at 4.16% (FRED DTB3, 2026-11-16). All figures are pre-tax.

PaydownPayment unchanged: paid off soonerInterest savedRecast: payment falls byFour years, paydown less T-bills
$25,0003y 10m$98,157$159/month+$2,562
$50,0006y 11m$172,419$318/month+$5,124
$100,00011y 9m$277,114$635/month+$10,249

The loan's rate is above the Treasury-bill rate, so the paydown comes out ahead of cash at every amount. Equities are the relevant comparison for money that would otherwise stay in the account. That comparison requires an expected return, which this example does not supply. At an expected return equal to the loan rate, the two paths are equal by construction; the RefiGeek test suite checks this property.

4. The concentration measurement

Look-through. VTI holds 6.50% NVIDIA (holdings as of 2026-07-31) and QQQ holds 8.93% (holdings as of 2026-05-12). The account's NVIDIA exposure is $100,000 directly, $7,804 through VTI and $7,143 through QQQ, a total of $114,947 or 38.3% of the account.

Risk sources. ERM3 (version 3.0, universe SPY_uni_mc_3000, data as of 2026-11-13) explains NVIDIA's daily variance as follows:

LayerShare of variance
Market (SPY)41.6%
Technology sector (XLK)11.1%
Semiconductors (SMH), beyond the sector−0.4%
Specific to NVIDIA47.6%

A diversified fund holds the company-specific component only in proportion to the company's weight in the fund. The share of the account in NVIDIA therefore measures how much of that component the household carries.

Exposure after each paydown, funded by selling NVIDIA shares:

PaydownNVIDIA exposureAccountShare
None$114,947$300,00038.3%
$25,000$89,947$275,00032.7%
$50,000$64,947$250,00026.0%
$100,000$14,947$200,0007.5%

5. Interpretation

The two measurements answer different parts of the question. The mortgage table gives the guaranteed effect of each paydown at the loan's rate. The concentration table gives the change in company-specific exposure that comes from the sale. A household could reduce the concentration without paying down the loan, by selling the stock and holding a diversified fund, so the two effects can be priced separately. This example measures each effect. Choosing between them is outside its scope.

6. Remaining uncertainty

  • The tax basis of the NVIDIA shares is unknown. The capital-gains cost of each sale can exceed the four-year advantages in §3.
  • Cash reserves, retirement accounts and unvested equity awards are outside the account examined.
  • QQQ's holdings date from 2026-05-12, so its NVIDIA weight may have changed.
  • The variance shares describe daily co-movement over ERM3's estimation window. They are not forecasts of NVIDIA's return.

7. Next test

The same brief, populated from a household's linked accounts with that household's permission, will be reviewed with four fee-only planners. They will be asked which figures they would use with a client, which facts they would request first, and what fixed fee the engagement would support.


Calculations and model outputs only, not investment advice. Blue Water Macro Corp. is not a registered investment adviser.

Share
X LinkedIn
Cite this· 2026

BibTeX for reference managers. Markdown for notes, blogs, or internal memos.

Data as of 2026-11-13. All figures derived from the RiskModels cascade via the API.

Subscribe to the Quarterly Attribution Review.

Research notes on risk decomposition, fund attribution, 13F filings, and benchmark structure — a few times a quarter.

By registering, you agree to receive technical factor research and API deployment logs. RM-Registry-2026. Privacy Policy.

RiskModels ecosystem

Research here. Reproduce through the API. Operate in the web app.

RiskModels.org stays the credibility layer: methodology, proof, and exhibits. Product links are kept contextual so the research remains the primary object.

Research

RiskModels.org

Methodology, article series, and public exhibits for institutional review.

Read the research

API

riskmodels.app

REST API, SDKs, CLI, and MCP-ready endpoints for reproducible decomposition calls.

Open API docs

Workspace

riskmodels.net

Web application surface for portfolio workflows, dashboards, and authenticated product use.

Open web app
Technical one-pagerDownload PDF

RiskModels.org

A research surface for hierarchical orthogonal decomposition, variance attribution, and allocator-grade risk measurement. Operational APIs and developer workflows live at riskmodels.app.

Sign inHomePrimerWorkspaceResearchVideosDemosKnowledgeConceptsReviewsLedgerEventsReferencesAboutSubscribeMethodology noteOne-pagerAPI docsWeb appContactPrivacyStatusRSS
RiskModelsResearch/Workspace/API