The Atlas — Nations Lending
Resource Dashboard
v1.3 Confidential
★ What's New v1.3: New VA Residual Income calculator (Beta) — 2026 federal, state and FICA withholding by borrower, optional local / county tax, the regional residual floor, and the 120% test when DTI is over 41%, with a printable record. Every calculator now also has its own Clear fields button, the Escrow Aggregate worksheet can be printed, and the USDA handbooks are under Third Party Resources.
📅 Rescission & Funding CalendarClick a close date — see rescission days, earliest funding, and the last day to close a primary refi and still fund this month.
Reg Z business days: Saturdays count; Sundays and the 11 federal holidays don't. Rescission runs 3 business days from the latest of consummation and delivery of the material disclosures and two copies of the right-to-rescind notice; earliest disbursement is the 4th business day. TX 50(a)(6) has its own longer timelines. A planning aid — verify against your compliance desk; not legal advice.
My Calculators
Document Hub
Calculator Hub
Select Calculator //
QM & High Cost Points and Fees Calculator • 12 CFR 1026.32 & 1026.43(e)(3)
Loan Details & Rates
Loan amounts
Note Amount − Reg Z Total Loan Amount − Current Discount Points $
—
Rates
Fees in P&F (12 CFR 1026.32(b)(1))
—
Discount Points
—
—
Bona Fide Tests
Rate reduction & actual basis
—
Test A — rate reduction support
—
Test B — APOR tier
—
Test C — starting adjusted rate
—
—
—
—
QM & High Cost Caps
2026 — tier by note amount, cap applied to Reg Z
—
—
—
—
—
Result
—
—
⚠ Mavent must be run to verify state rules pass
Maximum discount chargeable — no concession
Max (%)
—
Max ($)
—
Most you can charge as the loan sits today, before any pricing concession.
VA Seasoning Calculator • IRRRL / Cash-Out Refinance
VA Rule: The new loan cannot close earlier than the later of:
• 210 days from the first payment due date to the note date, and
• the date the 6th monthly payment has been made.
Earliest Allowed Closing
Enter the first payment due date to calculate.
FHA Seasoning Calculator • Streamline / Rate & Term & Cash-Out Refinance
FHA Streamline Seasoning: On the date of FHA case number assignment, all of the following must be met:
• at least 6 payments made on the existing FHA loan,
• at least 6 full months since the first payment due date, and
• at least 210 days from the original closing / disbursement date.

Note: the “210 days from first payment due date to the new first payment due date” test is a Ginnie Mae (GNMA) pooling requirement, not the FHA seasoning rule.
Earliest Allowed Closing
Enter the first payment due date to calculate.
FHA Streamline — Max Mortgage Amount Calculator • Internal Use Only
FHA Max Mortgage Limit
1A
Outstanding Principal Balance
+ Interest Due on Existing Mortgage
+
+ MIP Due on Existing Mortgage
+
= Total (1A)
=
$0.00
1B
Original Principal Balance of Existing Mortgage
Lesser of 1A or 1B
$0.00
2- UFMIP Refund
-
3= Max Mortgage Amount
=
$0.00
4+ New UFMIP (MIP Factor: 1.75%)
+
$0.00
5= Maximum Total Loan Amount
=
$0.00
Amortization Schedule Comparison • Current vs New Program
Current Program
Loan Amount ($)
Interest Rate (%)
Term (months)
Extra Payment / Month ($)
Monthly Payment$0.00
New Program
Loan Amount ($)
Interest Rate (%)
Term (months)
Extra Payment / Month ($)
Monthly Payment$0.00
Interest Savings
$0
Total over loan life
Time Savings
0 mo
Payoff sooner
Payment Difference
$0
Monthly
Amortization Schedule
View:
UFMIP Refund Estimator • FHA-to-FHA Refinance • 2026 Chart
Loan Inputs
Includes the financed UFMIP. The calculator backs out the base loan amount.
Whole months elapsed from the original FHA closing date.
UFMIP Factor1.75%
How it works: Base loan = Total ÷ 1.0175. UFMIP paid = Base × 1.75%. Refund = UFMIP × the chart % for the months elapsed (80% at month 1, dropping 2% per month to 10% at month 36; none after 36).
Derived Values
Base Loan Amount$0.00
Financed UFMIP Amount$0.00
Refund Percentage—
Estimated UFMIP Refund
$0.00
Applied as credit toward new UFMIP
VA Mortgage Calculation Worksheet BETA
Transaction //
Loan Amount Tier //
Step One — always required
Lesser of purchase price or appraised value
Step Two — always required
Basic Entitlement — printed on Certificate of Eligibility
× 4
 
$0.00
Maximum base loan amount VA will guarantee (before funding fee)
Step Three — only if Step One exceeds the max from Step Two
$0.00
"Amount" from Step One
× 0.25
25%
$0.00
Required guaranty
$0.00
− "Basic Entitlement" / Available Entitlement from Step Two
$0.00
Required down payment
When a down payment is required or requested, proceed to Step Four.
Step Four — when a down payment is made
$0.00
Lesser of purchase price or appraised value
− Down payment (must be ≥ required down payment)
$0.00
Base loan amount before addition of financed funding fee
Summary
Step One amount$0.00
Max VA will guarantee$0.00
Down payment required?No
Required down payment$0.00
Base Loan Amount
$0.00
Before financed funding fee
Note: This worksheet calculates the maximum base loan amount excluding the financed funding fee. Steps One and Two are always required; Steps Three and Four apply only when a down payment is required or requested.
Gross-Up Income Calculator • Non-Taxable Income
Inputs
From Tax Returns — determine non-taxed %
Current Income
How it works: The tax returns establish what % of the income is non-taxable. That same % of the award-letter amount is the non-taxed slice, which is grossed up by the program factor (FHA 15%, Conv 25%, VA 25%). The taxed remainder is added back unchanged.
Calculation Breakdown
Non-Taxable % of Income—
Award — Non-Taxed Slice$0.00
Award — Taxed Slice$0.00
Gross-Up Factor15%
Grossed-Up Non-Taxed Slice$0.00
Total Qualifying Income
$0.00
Taxed slice + grossed-up non-taxed slice
TX Home Equity (50)(a)(6) • 2% Fee Cap Calculation • Texas Admin Code Title 7, Part 8, § 153.5
Step 1 — Maximum Fees
Loan Amount
$0.00
Maximum Fee — 2% of loan amount
Bona Fide Discount Points (% of loan)*
$0.00
Bona Fide Discount ($) — loan × discount %
* See the Bona Fide Point Check guidance: in Encompass go to Forms → ATR/QM Management → Qualification tab → Points and Fees → Discount Points. Use only Test #3 (bona fide discount excludable based on the Starting Adjusted Rate).
Step 2 — Total Fees Calculation
Add the amounts in the Borrower's column (including POC) on the Closing Disclosure:
Section A — Origination Charges
Section B — Services Not Shopped For
Section C — Services Shopped For
Section E — Recording Fees
Section H — Other (required services, e.g. HOA refinance fee)
$0.00
Subtotal
Subtract the following excluded fees:
$0.00
Bona Fide Discount (from Step 1)
Survey Fee
Appraisal — portion paid to appraiser*
Lender Title Premium
Lender Title Endorsement Total
Lender Credits (Section J) — applicable only if no discount points charged, or part of an approved campaign
$0.00
Total Exclusions
* Per the Texas Finance Commission's proposed administrative interpretation (10/20/2017), exclude only the portion of the appraisal fee paid to the appraiser.
Step 3 — Reconcile
Permitted Fee Limit (Step 1)$0.00
Total 2% Fees (Step 2)$0.00
Difference$0.00
Within 2% Cap
$0.00
Room remaining under cap
Note: Per Texas Admin Code § 153.5, includable fees are those necessary to originate, evaluate, maintain, record, insure, or service the loan — excluding pre-paid interest, bona fide discount points, appraisal, survey, and lender's title premium & endorsements.
Gift of Equity Structuring • Solve for Sales Price
Deal Inputs
Seller Mortgage Payoff — what the seller owes today
Seller Cash Goal — cash the seller wants to net
Seller Closing Costs — the seller's own costs (commission, title, transfer tax, etc.)
Buyer Closing Costs — costs & prepaids covered by the gift
Gift Covers — whether the equity gift funds closing costs too, or just the down payment
Home Value — true appraised market value (the ceiling)
Down Payment
Down Payment % — required for the program (of sales price)
Down Payment $ — auto-calculated, but editable
Editing the dollar amount back-solves the implied % and re-derives the sales price. The down payment and closing costs together make up the total gift of equity.
Seller Proceeds Check
$0.00
Required Sales Price
− $0.00
Less: Mortgage Payoff
$0.00
Proceeds After Payoff
− $0.00
Less: Seller's Own Closing Costs
$0.00
Cash to Seller — should match the seller cash goal
$0.00
Available Equity (value − price) — funds the buyer's gift; must cover it
Required Sales Price
$0.00
Structure this purchase at this price
Buyer Financing
Sales Price$0.00
Down Payment$0.00
Closing Costs (gifted)$0.00
Total Gift of Equity$0.00
Base Loan Amount$0.00
LTV (vs lesser of price/value)0.00%
Gift Letter Should State
$0.00
Total gift of equity to document on the signed letter and final CD.
Basic Mortgage Calculator • Solve for Any Field
Enter any three of the four fields, then press Solve on the one you want to calculate. The solved field is highlighted and locked while the other three drive it.
Loan Amount
$
P&I Payment
$
Term (months)
Interest Rate
%
Solved: Interest Rate
From loan amount, payment & term
—
Example: Loan $100,000, P&I $648.60, Term 360 → solves to 6.75%. The payment formula is P&I = L × r(1+r)n ÷ ((1+r)n − 1), where r is the monthly rate and n the number of payments. Rate has no closed-form solution, so it's found by iteration.
EPO Policy Calculator • 180-Day Early Payoff Window
EPO Rule: The current loan cannot be paid in full within 180 days of disbursement. The new loan can close before that, but it cannot fund (which pays off the current loan) until strictly after the 180-day window — i.e. on day 181 or later.
Earliest New Loan Funding
Enter the disbursement date to calculate.
FHA Streamline • Net Tangible Benefit Worksheet
All Streamline refinances must provide the required net tangible benefit — exceptions cannot be granted. Choose the scenario that matches the transaction.
Section One — Mortgage Term Is Not Reduced
Prior Loan
—
New Loan
—
Enter the prior and new loan details to evaluate the net tangible benefit.
RIO (DSCR) Calculator BETA
DSCR = Gross Monthly Income ÷ PITIA. PITIA includes principal, interest, taxes, insurance, and HOA dues (if applicable), and is used for both amortizing and interest-only loans.
100% of Gross Monthly Income ÷ PITIA
Enter the income and PITIA to calculate the DSCR.
Eligibility & Pricing Factors (optional — for reference & qualification check)
Payoff Amount • Daily Interest (Per-Diem) × Days
Loan & Per-Diem
Unpaid Principal Balance (UPB)
Note Interest Rate (%)
$0.00
Daily Interest (Per-Diem)
Number of Days of Interest
$0.00
Interest Due — per-diem × days
Adjustments
Fees & Other Charges (recording, statement, etc.)
Credits / Amounts Held (escrow refund, suspense)
Total Payoff Amount
$0.00
UPB$0.00
Interest Due$0.00
Fees$0.00
Credits$0.00
For estimation only. This is not an official payoff. Always obtain the servicer's official payoff statement before quoting or disbursing.
Payment Shock Threshold • 50% Ceiling Over Existing Payment
Existing Payment
Enter the borrower's current housing payment. Choose the basis you're working from — be sure the payment you later compare against uses the same basis.
Payment Basis
Current Payment ($)
Threshold
Payment Shock Limit
$0.00
Maximum Increase — 50% of current payment
$0.00
Payment Ceiling — current × 1.5
Payment Ceiling (PITIA)
$0.00
A new payment at or below this figure keeps the borrower under a 50% payment shock.
Current$0.00
+ 50%$0.00
Temporary Buydown • Payment Schedule & Subsidy Cost
Loan
Total Loan Amount ($)
Note Rate (%)
Loan Term
Sales Price ($) — optional, for concession %
Buydown
View
Buydown Type
Payments are principal & interest only, amortized over the full term at each year’s rate on the full loan amount. Subsidy cost = the monthly payment difference (rounded to the cent) × months in each buydown year — the amount that must be deposited at closing. Most programs (Fannie Mae, Freddie Mac, FHA) qualify the borrower at the note rate; confirm program and investor eligibility. Buydown funds from the seller or another interested party count toward interested-party contribution limits.
VA Residual Income Worksheet • Chapter 4 Family-Support Test BETA
Borrower: —
1 — Loan & Household
Borrower last name — prints on the record
Family size
Filing status
Property state — sets the region & state tax
Local / county income tax (%) — optional; MD county, OH city, PA EIT, NYC, IN county
Region: —
tier —
Region & loan tier (auto)
Base loan amount ($)
Home square footage
2 — Income & Obligations (monthly)
BorrowerCo-borrower
Taxable gross income
Income typeTaxable income only — S/E doubles SS + Medicare; Ret excludes both (still taxed)
Non-taxable incomeUN-GROSSED / ACTUAL AMOUNT
Obligations
Total liabilitiesnot being paid off
Childcare / child support
Other debts / expenses
Household — shared
Proposed PITIA — P&I, taxes, insurance, HOA / assessments
Non-borrowing spouse debt
Back-end DTI (%) — from AUS / manual; drives the 120% gate
3 — Residual Determination
Table floor (region × family × tier)$0
Back-end DTI0.0%
Required residual to qualify$0
ENTER DATA
$0
Awaiting inputs
Tools
LC Property Tax Due Dates
Select the property state, then search for the county or taxing agency to view its tax due date(s). Use these to set up escrow aggregates.
Escrow Aggregate Setup • Initial Account Worksheet
Enter the estimated close date and each item's due/renewal date. The tool builds the 12-month escrow accrual schedule and flags any item due within 60 days of closing that must be collected in prepaids.
Property Tax — Pulled from LoanCare (locked)
Select a county/agency in the Property Tax Due Dates tool above — its due date(s) will lock in here automatically.
Insurance & Other Due / Renewal Dates
Fee & Date Cheat Sheet
Quick reference for 2026 loan limits, funding fees, mortgage insurance, timing rules, and common closing-cost items. Figures are effective for 2026 (FHA limits by case number, conforming by delivery date). Always confirm county-specific limits and file-specific figures against official sources.
2026 County Loan Limit Lookup — FHA & Conforming
VA Funding Fee (Purchase, Construction & Cash-Out Refi)
Down PaymentFirst UseSubsequent Use
Less than 5%2.15%3.30%
5% – 9.99%1.50%1.50%
10% or more1.25%1.25%
Down-payment tiers apply to purchase & construction loans. Cash-Out Refi uses the same first/subsequent rates (2.15% / 3.30%) but down payment / equity does not reduce it. IRRRL (Streamline): 0.50% flat. Assumption: 0.50%. Exempt: veterans with service-connected disability compensation, certain surviving spouses (DIC), active-duty Purple Heart recipients. Rates locked through 11/14/2031.
FHA Mortgage Insurance (MIP)
Upfront MIP (UFMIP)
All loans1.75% of base loan
Annual MIP — Term > 15 yrsRate
LTV ≤ 90% (≤ $726,200)0.50%
LTV > 90% (≤ $726,200)0.55%
LTV ≤ 90% (> $726,200)0.70%
LTV > 90% (> $726,200)0.75%
Most common: 0.55% (30-yr, 3.5% down). 15-yr terms run lower (0.15%–0.65%). Duration: <10% down = life of loan; ≥10% down = drops after 11 years. UFMIP refund available if refinanced within 3 years (see UFMIP Refund calculator).
Key Timing & Date Rules
RuleRequirement
Right of Rescission (Reg Z)3 business days (refis & HELOCs on primary residence; Sat counts, Sun/holidays don't)
Closing Disclosure (CD)Received 3 business days before consummation
Loan Estimate (LE)Within 3 business days of application
Initial CD after LEMay be sent the following day after the LE
Appraisal — copy delivery (ECOA)Promptly on completion, and ≥ 3 business days before consummation; borrower may waive the timing (waiver itself due ≥ 3 business days before closing)
Intent to ProceedRequired before charging fees (beyond credit report)
Revised LE (changed circumstance)Within 3 business days of learning of the change
Seasoning, EPO, and ATR/QM timing have dedicated calculators in the Calculator Hub. "Business day" definitions differ between the general rule (LE) and the specific rule (rescission/CD) — confirm per Reg Z.
Common Closing-Cost Reference
ItemTypical Basis
Origination charges (Sec. A)Points + lender fees; counts toward QM P&F cap
Prepaid interestPer-diem × days from funding to month-end
Escrow cushionUp to 2 months (per RESPA aggregate)
Owner's titleSeller-paid in many states; varies by locale
Transfer / conveyance taxState/county-specific (e.g. FL doc stamps)
Fee treatment for the QM Points & Fees test and the TX 2% cap is handled in those calculators. See the Seller Concession Limits card for contribution caps. Always confirm current agency guidelines and investor overlays per file.
Seller Concession / Contribution Limits
Loan TypeDown PaymentMax
Conventional (primary / 2nd home)< 10% down3%
Conventional (primary / 2nd home)10% – 25% down6%
Conventional (primary / 2nd home)> 25% down9%
Conventional (investment)Any2%
FHAAny6%
VAAny4%*
USDAAny6%
Conventional (Fannie/Freddie IPC) tiers are by down payment. *VA is nuanced: the seller can pay all allowable closing costs with no cap — the 4% applies only to true concessions (seller-paid funding fee, prepaids/escrows, temporary buydown funds, extra discount points beyond market norms, debt payoff, gifts). The 4% is measured against the VA reasonable value (NOV), not the contract price — if the appraisal is lower, the cap drops. Concessions can't exceed the buyer's actual costs and can't cover the down payment.
Community Property States
StateAbbr.
ArizonaAZ
CaliforniaCA
IdahoID
LouisianaLA
NevadaNV
New MexicoNM
TexasTX
WashingtonWA
WisconsinWI
Why it matters: on government loans (FHA, VA, USDA) in a community property state, the non-borrowing spouse's debts are generally included in the borrower's DTI (credit is pulled for debts, but the NBS credit score isn't used for qualifying). The non-borrowing spouse typically must sign the security instrument (and applicable disclosures) to perfect the lien and waive homestead/marital rights. Conventional (Fannie/Freddie) generally does not require NBS debts in DTI. Rules vary by state and program — confirm the specific signature and DTI requirements per file.
Reference figures compiled for 2026 from FHFA, HUD/FHA, and VA. These are guides, not guarantees — county limits, program guidelines, and regulatory timing can change and vary by scenario. Verify against Encompass, the applicable agency, and current investor overlays before relying on any figure for a specific loan.
Third Party Resources
■ Guideline Research
AI Search
Guideline Guru
AI-powered mortgage guideline search • guidelineguru.ai
■ FHA
Handbook
FHA 4000.1 Handbook
Single Family Housing Policy Handbook — current edition • hud.gov
■ Fannie Mae
Selling Guide
Fannie Mae Selling Guide
Full underwriting & eligibility guidelines • selling-guide.fanniemae.com
Income Tool
Fannie Mae Self-Employment Income Calculator
Income calculator application • singlefamily.fanniemae.com
■ Freddie Mac
Selling Guide
Freddie Mac Selling Guide
Full underwriting & eligibility guidelines • guide.freddiemac.com
Income Tool
Freddie Mac Self-Employment Calculator
Income calculator solution • sf.freddiemac.com
■ VA
Lenders
VA Lenders Page
VA home loan lender resources & guidance • benefits.va.gov
■ USDA
Handbook
USDA Rural Development Handbooks
RD handbooks, incl. HB-1-3555 Single Family Housing Guaranteed Loan Program • rd.usda.gov
These links open external third-party sites in a new tab. Nations Lending is not responsible for content hosted on external sites; always verify against the most current published guidance.
Build Info — The Atlas
Update Reminders
StatusItemWhere in The AtlasSource / triggerSchedule
Reminders and completion status are built into the file so every copy shows the same list. When an item is updated, mark it done in the file and release a new version.
Version History
VersionDate pushedSummary of changes
The newest entry sets the header version badge and the version printed on calculator printouts.
Admin Guide — THE_ATLAS_README.md

The Atlas — Nations Lending Resource Dashboard

Current version: v1.3
File: the_atlas.html (single, self-contained HTML file — no install, no server)
Last updated: 11/11/2026

The Atlas is the Nations Lending resource hub: calculators, compliance timing tools, reference documents, and guideline links in one page.


Contents

  1. Opening the dashboard
  2. Tabs at a glance
  3. Home
  4. Document Hub
  5. Calculator Hub
  6. Tools
  7. Cheat Sheet
  8. Third Party Resources
  9. Printing & version control
  10. Build Info
  11. Saved settings (per browser)
  12. Maintenance notes
  13. Change log

Opening the dashboard

Download the_atlas.html and open it in Chrome or Edge. Everything — including the built-in documents — is embedded in the file, so it works offline. Fonts load from Google Fonts when online; without internet the page falls back to system fonts.


Tabs at a glance

Tab What's there
Home What's New banner, Rescission & Funding / CD calendar, pinned calculators
Document Hub Downloadable matrices, worksheets, and policy docs
Calculator Hub 18 calculators grouped by loan type
Tools Property tax due dates, escrow aggregate setup
Cheat Sheet Loan limits, VA funding fee, FHA MIP, timing rules, seller concessions, community property states
Third Party Resources Guideline Guru, agency handbooks and selling guides

Home

What's New banner

Short announcement strip at the top of Home. Dismissible per visit (the ✕ hides it until the page is reloaded). Edit the text in the #update-banner block when releasing a new version.

Rescission & Funding Calendar

A month calendar with two independent modes:

Pick: Close date — click a closing date to see:

  • the 3 rescission days (labeled on the calendar), and
  • the earliest funding date.

Rescission applies only to primary-residence refinances (rate/term or cash-out). Purchases, second homes, and investment properties show no rescission.

Pick: CD accepted — click the date the borrower received/accepted the Closing Disclosure to see the earliest permissible closing date (3 business days after receipt).

Persistent monthly flags (shown in both modes):

  • Last day to close a primary refi and still fund in the current month.
  • Last day to accept a CD for a primary refi, and for purchase / investment / second home.

Month and year dropdowns plus ‹ › arrows navigate the calendar.

Date rules used

Rule Treatment
Business day (Reg Z specific) Saturdays count; Sundays and the 11 federal holidays do not
Federal holiday observance Saturday holiday → observed Friday; Sunday holiday → observed Monday (incl. Jan 1 on a Saturday → observed Dec 31 of the prior year)
Rescission — 12 CFR 1026.23 3 business days after consummation; earliest disbursement is the 4th business day
Funding days (shop rule) No funding on Saturdays, Sundays, or holidays — rolls forward to the next weekday that isn't a holiday (e.g., a loan closed Tue 9/15 funds Mon 9/21)
CD timing — 12 CFR 1026.19(f) Must be received 3 business days before consummation; based on actual receipt (no mailbox presumption); Sunday receipt is not pushed

The calendar is a planning aid. TX 50(a)(6) has its own longer timelines. Verify against the compliance desk; not legal advice.

My Calculators (pinned)

Shortcut cards for frequently used calculators. Each card has Open and a print icon that prints that calculator directly.

  • Default pins: Payment Shock, FHA Seasoning, Payoff Amount.
  • ✎ Edit pins lets each user choose their own set. Pins are saved in that user's browser (see Saved settings).

Document Hub

Built-in documents (embedded in the file, download on click):

Document Category Notes
Lending Matrix Lending Matrix Matrix_10_1_2026.xlsx — updated 10/1/26
Manufactured Lending Matrix Lending Matrix MANUFACTURED_LENDING_MATRIX_9_15_2026.xlsx — updated 9/15/26
Scheduling State Guide Team Resource Attorney, spousal signature & witness requirements by state
Who Signs What Matrix Team Resource Job aid: co-borrower vs. co-signer vs. guarantor vs. non-borrowing spouse — who is on title, signs the security instrument / note / purchase contract, is on the HOI, and carries credit liability
1084 Worksheet — Fannie Mae Team Resource Self-employment income analysis (Conventional / FNMA)
1084 Worksheet — Freddie Mac & Govt Team Resource Self-employment income analysis V12
Texas Cash-Out Requirements Policy / Compliance TX 50(a)(6) checklist

To add or replace a document for everyone, it is embedded in the HTML file and released as a new version.


Calculator Hub

Pick a calculator from the dropdown. Each one has a Print button, and a Clear fields button in its header that resets only that calculator's inputs to their starting values (mode and program toggles keep their current selection).

Group Calculator
General / Loan Math Basic Mortgage Calculator
Amortization Schedule Comparison
Gift of Equity Structuring
Payment Shock Threshold (50% / 75%)
Temporary Buydown (Compare)
Payoff Amount (Estimate)
FHA FHA Seasoning Calculator
FHA Streamline — Max Mortgage Amount
FHA Streamline — Net Tangible Benefit (NTB)
UFMIP Refund Estimator
VA VA Mortgage Calculation Worksheet (Beta)
VA Seasoning Calculator
VA Residual Income (Beta)
Investment / DSCR RIO (DSCR) Calculator (Beta)
Income Gross-Up Income Calculator
Compliance QM & High Cost — Points & Fees
TX 2% Home Equity Fee Calculator
EPO Policy Calculator

Calculator notes

Each note covers what the calculator answers, the rule it applies as built, and its limits. Reminder points to the Build Info → Update Reminders item that covers it.

General / Loan Math

Basic Mortgage Calculator — enter any three of loan amount, payment, term and rate, and it solves for the fourth (P&I only). Rate is solved iteratively; a payment too low to ever amortize the loan returns no term.

Amortization Schedule Comparison — current loan vs. new loan, each with an optional extra monthly principal payment. Shows the payment difference, interest saved and time saved, with an annual view (cumulative principal and interest by year) or a monthly view (first 60 months). Standard monthly amortization; does not include taxes, insurance or MI.

Gift of Equity Structuring — solves for the sales price in a family/non-arm's-length sale.

  • Sales price = seller payoff + seller's own closing costs + seller's cash goal (rounded up to the whole dollar). The gift is non-cash, so it doesn't reduce the seller's proceeds.
  • Gift of equity = down payment (price × DP %) + buyer closing costs, if the gift covers them (toggle: DP + closing costs, or DP only). Loan = price × (1 − DP %); LTV is on the lesser of price or appraised value.
  • Down payment can be entered as % or $; editing the $ back-solves the %.
  • Flags when available equity (value − price) can't cover the gift, or the price exceeds the appraised value. The gift letter amount is shown.

Payment Shock Threshold (50% / 75%) — maximum allowed increase and payment ceiling at 50% or 75% over the current payment (current × 1.5 or × 1.75). Compare on the same basis (PITIA vs. P&I) on both sides.

  • Reminder: Company policy calculators.

Temporary Buydown (Compare) — loan amount, note rate, term and optional sales price.

  • Single view: 3-2-1, 2-1, 1-1, 1-0 or Custom (reduction for years 1–3); shows each year's rate, full payment, bought-down payment, monthly and annual savings, and total buydown cost.
  • Compare view: any combination side by side — year-by-year rate, payment and savings, months subsidized, total cost. Green marks the largest year-1 savings and the lowest total cost.
  • Payments are P&I over the full term at each year's rate; subsidy = monthly difference (rounded to the cent) × 12 per buydown year. Rates floor at 0%.
  • Cost is shown as a % of loan amount and, with a sales price, % of sales price (for interested-party contribution limits).
  • Most programs (Fannie Mae, Freddie Mac, FHA) qualify at the note rate; confirm program and investor eligibility.
  • Reminder: Seller concession limits.

Payoff Amount (Estimate) — UPB + (per diem × days) + fees − credits. Per diem = UPB × note rate ÷ 360. The 360 basis is intentional: it runs slightly higher than a 365-day basis (about $1/day per $250K), which is the safe direction for an estimate. The servicer's payoff statement governs.

FHA

FHA Seasoning Calculator — three modes:

  • Streamline: earliest closing/case number is the day after the later of (a) 6 full months after the first payment due date and (b) 210 days after the original closing/disbursement date. All prongs are measured to case number assignment. Shows the 6 payments that must be made in the month due.
  • Rate & Term / Cash-Out: earliest closing is the later of (a) the day after the 6th payment due date and (b) the closing date that produces a new first payment due date at least 210 days after the original first payment due date (closing in month M → first payment the 1st of M+2). Earliest case number = day after the 6th payment.
  • Cash-Out also flags the 12-month ownership/occupancy requirement before case number assignment (inherited-property exception).
  • Reminder: FHA Streamline & seasoning rules.

FHA Streamline — Max Mortgage Amount — lesser of (a) outstanding principal + interest + MIP due and (b) original principal balance; minus the UFMIP refund = max base mortgage (cents truncated). New UFMIP = base × 1.75%. Total is capped at the county FHA loan limit entered (flagged when the cap applies).

  • Reminders: FHA MIP rates; County loan limits.

FHA Streamline — Net Tangible Benefit (NTB) — two methods; one must be met.

  • Combined rate (note rate + annual MIP), prior → new:
Prior loan → Fixed → 1-yr ARM → Hybrid ARM
Fixed ≥ 0.5 pt lower ≥ 2 pts lower ≥ 2 pts lower
ARM, < 15 months to next change ≤ 2 pts higher ≥ 1 pt lower ≥ 1 pt lower
ARM, ≥ 15 months to next change ≤ 2 pts higher ≥ 2 pts lower ≥ 1 pt lower
  • Reduction in term: all three must pass — new term shorter than prior; new rate not above prior; new P&I + MIP no more than $50 above prior.
  • Reminders: FHA Streamline & seasoning rules; FHA MIP rates.

UFMIP Refund Estimator — FHA-to-FHA refinance. Base loan = total loan ÷ 1.0175; UFMIP paid = base × 1.75%; refund = UFMIP × chart %. Chart: 80% in month 1, down 2 points per month to 10% at month 36, none after 36 (formula: 82 − 2 × months).

  • Assumes the original UFMIP was 1.75% and fully financed. Use the refund from FHA Connection when available.
  • Reminders: FHA MIP rates; Year labels & references ("2026 Chart" label).

VA

VA Mortgage Calculation Worksheet (Beta) — follows VA's loan-calculation worksheet steps.

  • Purchase, ≤ $144,000 tier: max base loan = basic entitlement (from the COE) × 4. Step One = lesser of price or appraised value.
  • Purchase, > $144,000 tier: max guaranty = county loan limit entered × 25%; available entitlement = max guaranty − entitlement charged to prior VA loans; max base loan = available entitlement × 4. Step One is also capped at a fixed $850,000 (1–2 units) / $650,000 (3–4 units) — these are hard-coded and not tied to the county lookup; confirm their source.
  • Required down payment (when Step One exceeds the max base loan) = (Step One × 25%) − entitlement. Step Four applies the down payment entered; alerts if it's missing or short.
  • Refinance: same entitlement math, then available equity (appraised value − desired loan), required equity, required cash to close, and total loan (new base + funding fee entered).
  • Funding fee is entered manually, not calculated.
  • Reminders: VA funding fee; County loan limits.

VA Seasoning Calculator — VA-to-VA refinance (IRRRL / cash-out). Earliest closing (note date) is the day after the later of (a) the 6th monthly payment due date and (b) 210 days after the first payment due date. Shows the 6 payments that must be made in the month due.

  • Reminder: VA IRRRL / cash-out seasoning.

VA Residual Income (Beta) — VA Chapter 4 family-support test. Ported from the NLC Underwriting VA Residual Income Worksheet v1.2; the calculation code is unchanged.

  • Inputs: family size, filing status, property state (sets the VA region and state tax), optional local / county income tax %, base loan amount (sets the loan tier: under $80,000 or $80,000+), square footage; per-borrower taxable income (with Self-employed / Retirement flags), non-taxable income (un-grossed), liabilities, childcare/child support, other debts; shared PITIA, non-borrowing spouse debt and back-end DTI.
  • Residual = gross income − federal withholding − state withholding − local tax − Social Security − Medicare − state program deductions (SDI / PFML / WA Cares) − PITIA − maintenance & utilities ($0.14 × sq ft) − liabilities − childcare − other debts − non-borrowing spouse debt.
  • Taxes are 2026 withholding computed per borrower (each paycheck separately, then summed). Federal follows the PaycheckCity Salary calculator basis. S/E doubles SS and Medicare; Retirement excludes both (income still taxed). SS wage base $184,500.
  • State tax uses each state's official 2026 payroll withholding method where built. Ledger tags: W/H · exact — AZ, CA, CO, GA, IA, IL, LA, MA, MD, MN, MS, NC, NJ, NY, OH, SC, UT (validated live against PaycheckCity) and IN, KY, MI, PA (single-rate); W/H · est. — the other 21 states with income tax (annualized return brackets); no tax. Married two-income forks (CA, GA, IA, MS) follow co-borrower income. CO, MN, MS and NC round to the whole dollar.
  • Local / county tax is an optional flat % of each borrower's taxable wages (retirement-flagged income excluded); blank = none.
  • Required residual = VA regional floor by family size and loan tier (over 5 members: + $80 per member at $80,000+, + $75 under $80,000); × 1.20 when back-end DTI is over 41%.
  • The result stays grey ("Enter data") until Calculate residual is clicked and resets on any edit. Prints with the borrower's last name and date.
  • Beta: open items (the 21 estimated states, single-rate local tax, allowances/dependents) are tracked in the build/status document under Build Info → Reference Docs.
  • Maintained by: NLC Underwriting keeps the standalone worksheet current; new versions are re-ported into The Atlas.
  • Reminders: VA Residual — federal & FICA tables; VA Residual — state tax & program rates; VA residual income floors.

Investment / DSCR

RIO (DSCR) Calculator (Beta) — DSCR = 100% of gross monthly rental income ÷ PITIA (principal, interest, taxes, insurance, HOA; used for amortizing and interest-only loans). Optional minimum DSCR, loan purpose (product list), FICO and LTV for a pass/below-minimum check against the embedded eligibility matrix (as of 4/1/2026: investment, SFD/PUD/condo, 1–4 units; e.g. 80% LTV / 700 FICO / 100% DSCR; 70% LTV / 660 FICO / 120% DSCR).

  • Reminder: RIO (DSCR) eligibility matrix.

Income

Gross-Up Income Calculator — grosses up the non-taxable portion of an award amount.

  • Factors as built: FHA 15%, Conventional 25%, VA 25%.
  • With tax returns: non-taxable % = (total income − taxed portion) ÷ total income, from the returns. That % of the award is grossed up by the factor; the taxed remainder is added unchanged. If no return figures are entered, 100% of the award is treated as non-taxable.
  • Conventional, no tax returns: 15% of the award is treated as non-taxable and grossed up 25%.
  • Alerts when the taxed portion exceeds total income, or when the income is 100% taxable (no gross-up).
  • Reminder: Company policy calculators.

Compliance

QM & High Cost — Points & Fees (port of QM_HighCost_Calculator v11; 12 CFR 1026.32 & 1026.43(e)(3))

  • Reg Z total loan amount = Note − other financed fees − discount points $.
  • Bona fide discount exclusion by APOR tier: undiscounted rate ≤ APOR + 1% → up to 2 pts; ≤ APOR + 2% → up to 1 pt; above → 0. Only genuine buydown points (charged − par cost) with a real rate reduction qualify. A starting adjusted rate (SAR) is used for the rate-reduction test when entered.
  • QM cap tiers (2026, tier by note amount, cap applied to Reg Z amount): ≥ $137,958 → 3%; ≥ $82,775 → $4,139; ≥ $27,592 → 5%; ≥ $17,245 → $1,380; below → 8%.
  • High cost cap: greater of 5% of Reg Z amount or $1,000.
  • Maximum discount chargeable — no concession: the most you can charge as the loan sits today, solved with the same test as the Pass/Fail result so the two never disagree.
  • Concession alert (only when over the QM cap): shows the concession needed in points and dollars, rounded up with a small buffer to clear Encompass rounding. Percentage tiers: overage ÷ (1 + cap rate); flat-dollar tiers: the overage itself. If the concession needed exceeds the discount charged, the alert says to reduce fees or restructure.
  • Mavent must still be run to confirm state rules pass.
  • Known item: the high-cost cap applies 5% / $1,000 to every loan size. Under 1026.32(a)(1)(ii), loans below the small-loan threshold ($27,592 for 2026) use the lesser of 8% or $1,380.
  • Reminders: QM points & fees thresholds; HOEPA high-cost thresholds.

TX 2% Home Equity Fee Calculator — TX 50(a)(6); 7 TAC § 153.5.

  • Step 1: max fees = 2% of loan amount. Bona fide discount $ = loan × bona fide discount % (from Encompass: Forms → ATR/QM Management → Qualification → Points and Fees → Discount Points; use Test #3 only, based on the starting adjusted rate).
  • Step 2: borrower-column CD Sections A + B + C + E + H (including POC), minus exclusions: bona fide discount, survey, appraisal (appraiser's portion only), lender title premium, lender title endorsements, and lender credits (Section J — only if no discount points are charged, or under an approved campaign).
  • Step 3: cap − fees = room remaining, or the overage that must be cured.
  • Reminder: Texas 50(a)(6).

EPO Policy Calculator — company early-payoff policy: the current loan cannot be paid in full within 180 days of disbursement. Window ends on day 180; the new loan can close earlier but cannot fund until day 181 or later.

  • Reminder: Company policy calculators.

Tools

LC Property Tax Due Dates — pick the property state, then search or select the county / taxing agency to see its tax due date(s).

Escrow Aggregate Setup — Initial Account Worksheet — enter estimated close date, first payment date (auto-filled, editable), and cushion months. Property tax dates lock in from the tool above; add homeowner's insurance, flood (if applicable), and city tax dates. Use the Print button in its header to print the worksheet.


Cheat Sheet

  • 2026 County Loan Limit Lookup — FHA & Conforming
  • VA Funding Fee (purchase, construction, cash-out, IRRRL, assumption)
  • FHA Mortgage Insurance (UFMIP and annual MIP)
  • Key Timing & Date Rules (rescission, CD, LE, revised LE, appraisal delivery, intent to proceed)
  • Common Closing-Cost Reference
  • Seller Concession / Contribution Limits
  • Community Property States

Third Party Resources

Section Link
Guideline Research Guideline Guru
FHA HUD 4000.1 Single Family Housing Policy Handbook
Fannie Mae Selling Guide · Self-Employment Income Calculator
Freddie Mac Selling Guide · Self-Employment Income Calculator
VA VA Lenders Page
USDA USDA Rural Development Handbooks (incl. HB-1-3555)

Printing & version control

  • The Print button (and the print icon on pinned calculators) prints only the active calculator — header, navigation, and other pages are hidden.
  • The Print button on the Tools tab's Escrow Aggregate Setup prints only that worksheet, with the same footer.
  • Every printed page carries a footer: The Atlas v1.3 · <Calculator name> Printed MM/DD/YYYY h:mm AM/PM
  • The version in the footer is read from the header's version badge, so updating the badge updates every printout automatically.
  • To check whether someone is on the latest release, compare the printed version with the current badge and change log.

Build Info

A v1.3 · Build Info button sits in the bottom-right corner of every page (the number always matches the current version). It opens the Build Info page, available to everyone — no login. It has four sub-tabs:

Update Reminders — everything in The Atlas that changes over time and has to be checked to keep it accurate. Each item shows where it lives in the dashboard, where the new data comes from, and a status:

Status Meaning
Overdue An annual update's effective date has passed and it hasn't been marked done for this year
Check due A monthly, quarterly or semi-annual (Jan 1 / Jul 1) check is due for the current period
Due soon Due within 45 days
Scheduled Done for the current period; shows the next due date
Monitor No fixed date — update when the source changes

Reminders and their completion status are built into the file, so every copy shows the same list. To mark an item done (or add/remove one), update the file and release a new version.

Version History — every release with its date and a summary of changes. The newest entry sets the version badge in the header, the Build Info button, and the version printed on printouts, so they always match.

Admin Guide — this document, readable in the tab, with a Download .md button.

Reference Docs — supporting documents for specific calculators (currently the VA Residual Income build/status document from NLC Underwriting). Each is a collapsible section — click its title bar to expand or collapse it — with its own Download .md button. More calculator documents can be added as additional sections.

There is no admin login. Documents are added to the Document Hub by embedding them in the file and releasing a new version, so every copy stays the same.


Saved settings (per browser)

Stored in the browser's localStorage under the key tm_v6:

  • pinnedCalcs — the user's pinned calculators

Nothing is shared between users or devices. Clearing browser data resets pins to the defaults.


Maintenance notes

Releasing a new version 1. Add a new entry to the top of the version history (ATLAS_VERSIONS in the file). The header badge, Build Info button, print footer, and Build Info page update automatically. 2. Update any reminders that were completed (ATLAS_TODOS). 3. Update the What's New banner text. 4. Refresh this guide (current version and change log) and re-embed it. 5. Redistribute the file.

Editing the file safely The file contains large embedded (base64) documents. Edit by exact text replacement, not by deleting large ranges, and syntax-check the script after changes.


Change log

Version Date Changes
v1.3 11/11/2026 New VA Residual Income calculator (Beta), ported from the NLC Underwriting worksheet v1.2: 2026 federal, FICA, state and state-program withholding per borrower, with official 2026 state withholding formulas for 17 states (incl. mid-2026 changes); optional local / county income tax; VA regional residual floors by family size and loan tier; 120% test when DTI is over 41%; printable borrower record. Every calculator now has its own Clear fields button in its header; it resets only that calculator. Tools: Print button on the Escrow Aggregate Setup worksheet. Third Party Resources: USDA Rural Development Handbooks link. Document Hub: added the Who Signs What Matrix job aid (co-borrower, co-signer, guarantor, non-borrowing spouse). New Harbor look: updated color palette (navy header, cream page, orange accents), refreshed layout with a centered tab tray, and the new Atlas logo. Admin login and Admin tab replaced by a Build Info button (bottom right, open to everyone) with the same update reminders, version history, admin guide and new Reference Docs tab (VA Residual build/status document).
v1.2 10/27/2026 Admin tab (visible only after admin login): update reminders, version history, and the admin guide with .md download. Every calculator printout now carries a footer with the version number, calculator name, and print date/time. QM & High Cost calculator updated to v11: max discount shown with no concession; concession-needed alert (points and $) when over the QM cap. Header version badge and print footer are now driven by the version history, so they always match the latest release. New Temporary Buydown calculator: 3-2-1, 2-1, 1-1, 1-0 and custom, with a side-by-side compare view and cost as % of loan / sales price. Removed the browser-only + Add Doc button (added docs never synced to other users).
v1.1 10/07/2026 QM & High Cost calculator updated to v9: max discount solved with the same pass/fail test as the result bar; alerts when a lender credit is needed.
v1.0 10/02/2026 Launched as The Atlas: new logo with “Resource Dashboard” in the header. Home: What’s New banner, Rescission & Funding / CD calendar (persistent monthly flags, month/year dropdowns), and customizable pinned calculators with print. Lending Matrix updated to 10/1/26; Guideline Guru added; FHA 4000.1 Handbook link updated. Payment Shock 50% / 75% toggle; Gift of Equity calculator updated.
Supporting documents for individual calculators. Click a document to expand or collapse it.
▸VA Residual Income — Build StatusWorksheet v1.2 · NLC Underwriting · as of 11/4/2026

VA Residual Income Calculator — Build Status

File: va-residual-calculator.html (single self-contained HTML file; only external dependency is one Google Font) Version: v1.2 As of: 2026-11-04 Owner: Dano (NLC Underwriting) Purpose: Determine whether a VA borrower passes the Chapter 4 family-support residual-income test, using 2026 payroll withholding validated against PaycheckCity, with a pass/fail determination and a printable borrower record.


1. What changed in v1.2 (this session)

Triggered by the Residual Calculator — Tax Engine Review (Nov 3, 2026). The review was right that the state engine used tax-return brackets instead of withholding formulas, and that the errors leaned toward overstating residual. The net-pay engine file it recommended porting was never available, so each state was rebuilt from its official 2026 payroll source and validated live against PaycheckCity in Chrome.

  • 15 state withholding formulas rebuilt to the official method: AZ, CO, GA, IA, LA, MA, MD, MN, MS, NC, NJ, OH, SC, UT (+ CA/NY from v1.1).
  • Mid-2026 changes captured: GA 4.99% (June), UT 4.45% (June 1), NC 4.09% (June), OH new 1.6% / 2.99% / 3.4% table (Aug 1).
  • Whole-dollar rounding added for CO, MN, MS, NC (PaycheckCity applies mandatory per-period rounding).
  • Two-income forks extended to GA, IA, MS (CA already had one). Co-borrower income decides.
  • Program deductions: RI TDI 1.3% → 1.1%; CO FAMLI 0.45% → 0.44%; added NJ UI/WF/SWF (0.425% to $44,800), PA UC (0.07%), OR Statewide Transit (0.1%).
  • New optional field — Local / county income tax (%). Covers MD county, OH municipal, PA EIT, NYC, IN county, etc. Applied to each borrower's taxable wages (retirement-flagged income excluded). Blank = no local tax, which matches PaycheckCity's default (it adds local tax only when a work address is entered).
  • Accuracy tags made honest. The old "W/H · flat … effectively exact" tier was wrong for 10 states and is gone. Tags are now exact or est. only.
  • Federal ledger label corrected from "combined" to "per borrower".

Unchanged (per the review's "do not touch" list): federal basis (including the correct HoH brackets), FICA, per-borrower architecture, CA fork, VA floors, the 41% / 120% gate, the determination stamp.


2. Where the review was wrong (verified live in PaycheckCity)

State Review figure PaycheckCity Tool v1.2 What happened
IA $148.83 $107.67 $107.67 Review used the $13,000 spouse-working deduction on a single-earner file. Married one-income is $26,000. PaycheckCity has an explicit "Spouse working status" toggle (default False).
MS $111.33 $151.00 $151.00 Review applied the $12,000 personal exemption automatically. It's claimed in dollars on the 89-350; PaycheckCity's default is $0. The old tool figure was right.
MD $233.12 $206.21 $206.21 Review's figure doesn't reproduce. The real fix was a 1.5% indexed standard deduction ($3,400 / $6,800). County tax is now handled by the local field.
MA $241.67 $230.88 (YTD=0) $241.67 Both are "right." PaycheckCity's single paycheck with YTD = $0 deducts the full period FICA because the $2,000 Circular M cap isn't reached yet. Annualized, the true monthly average is $241.67 (kept: correct and conservative).

The other 10 review findings (SC, CO, MN, LA, NC, OH, NJ, AZ, UT, GA) were correct and are now implemented.


3. Calculation engines

Engine Basis Granularity
Federal withholding PaycheckCity Salary-calculator basis: full standard deduction ($16,100 / $32,200 / $24,150) then 2026 rate schedule Per borrower
FICA SS 6.2% to $184,500; Medicare 1.45% + 0.9% over $200k / $250k; S/E doubles; Retirement excludes Per borrower
State withholding Official 2026 payroll method per state (Section 4) Per borrower
Local / county tax Optional flat % of taxable wages Per borrower
State programs Employee-side SDI / PFML / WA Cares / UI, itemized, annualized caps Per borrower, W-2 only
VA floors VA Pamphlet 26-7, Ch. 4, Tables 9–11; 41% → 120% gate Household

4. State accuracy tiers

Tag States Notes
W/H · exact (live-validated) AZ, CA, CO, GA, IA, IL, LA, MA, MD, MN, MS, NC, NJ, NY, OH, SC, UT Matched to PaycheckCity across filing statuses and incomes (Section 6)
W/H · exact (review-confirmed) IN, KY, MI, PA Single-rate formulas; confirmed by the Nov 2026 review, same structure as IL (live-validated)
W/H · est. AL, AR, CT, DE, DC, HI, ID, KS, ME, MO, MT, NE, NM, ND, OK, OR, RI, VT, VA, WV, WI Annualized return brackets less state std deduction. Per the review, within $5/mo at MFJ $5k, but not built to the official method or validated live.
no tax AK, FL, NV, NH, SD, TN, TX, WA, WY WA still carries WA Cares + PFML program lines

Per-state method notes (exact tier)

  • AZ — 2.0% of gross (A-4 default election).
  • CO — 4.4% after allowance: $5,500 single/HoH, $11,000 MFJ. Rounded to the dollar.
  • GA — 4.99% after std deduction: $15,000 single/HoH/MFJ-both-working, $30,000 MFJ one income.
  • IA — 3.8% after deduction: $13,000 single/MFJ-spouse-working, $19,500 HoH, $26,000 MFJ one income.
  • LA — 3.09% of gross. Standard deduction must be claimed on the L-4; default assumes not claimed (PaycheckCity default, conservative). Claimed, it's $12,875 single / $25,750 MFJ-HoH.
  • MA — 5% after FICA (max $2,000, annualized) and $2,400 HoH exemption.
  • MD — return brackets after $3,400 / $6,800 std deduction (HoH uses single). County tax via the local field.
  • MN — 2026 withholding tables (married 0% to $14,700, then 5.35% / 6.8% / 7.85% / 9.85%). Rounded to the dollar.
  • MS — std deduction ($4,600 married one income; $2,300 single/spouse employed; $3,400 HoH), first $10,000 at 0%, then 4%. No personal exemption (must be claimed). Rounded.
  • NC — 4.09% after $12,750 (single/MFJ) or $19,125 (HoH). Rounded.
  • NJ — Rate Table A (single/MFS), Table B (MFJ/HoH). PaycheckCity defaults every filer to B; set rate code A when checking a single borrower.
  • OH — 1.6% to $26,050, 2.99% to $100,000, 3.4% above (Aug 1, 2026). Withholding starts at the first dollar even though the return has a $26,050 zero bracket.
  • SC — 0% / 3% / 6%, no deduction at zero exemptions.
  • UT — 4.45% less base allowance ($485 / $970) phased out 1.3% above $9,348 / $18,696. HoH = single.
  • CA — DE 44 Method B; two-income uses single schedule.
  • NY — NYS-50-T exact method.

5. Design principles for state withholding (now explicit)

  1. Match PaycheckCity's Salary calculator at the borrower's filing status with zero extra allowances.
  2. Filing-status deductions apply; affirmatively-claimed amounts don't. If the state applies a deduction automatically from filing status (GA, IA, NC, CO, MD), it's included. If the employee must claim it in dollars or by election on the state form (MS exemption, LA std deduction), it's excluded. This leans toward lower residual — the safe direction.
  3. Annual caps are annualized. A one-off PaycheckCity paycheck with YTD = $0 won't reflect annual caps (MA $2,000 FICA, NJ $44,800 UI). The tool gives the true monthly average.
  4. Two-income forks follow co-borrower income (CA, GA, IA, MS).

6. Validation log — live PaycheckCity (Chrome), Nov 4, 2026

43 of 43 data points match within 2.5¢ (rounding states compared after rounding).

State Scenario PaycheckCity Tool
IA MFJ one income / two income / single / HoH, $5k 107.67 / 148.83 / 148.83 / 128.25 same ✓
CO MFJ / single / HoH $5k; MFJ $10k 180 / 200 / 200; 400 same ✓
GA MFJ one / both / single / HoH $5k; MFJ $10k 124.75 / 187.13 / 187.13 / 187.13; 374.25 same ✓
MS MFJ one / spouse employed / single / HoH $5k 151 / 159 / 159 / 155 same ✓
LA default $5k; single $10k 154.50; 309.00 same ✓
NC MFJ / HoH $5k; single $10k 161 / 139; 366 same ✓
NJ MFJ / single (rate A) $5k; MFJ $10k 97.50 / 167.92; 355.83 same ✓
UT MFJ / single / HoH $5k 186.41 / 222.50 / 222.50 same ✓
OH MFJ $5k; single $10k 119.33; 275.66 same ✓
SC MFJ $5k; single $10k 245.33; 545.33 245.32; 545.32 ✓
AZ MFJ $5k 100.00 same ✓
MN MFJ $5k 202.00 same ✓
MD MFJ / single $5k; single / MFJ $10k 206.21 / 219.67; 460.63 / 443.71 same ✓
CA MFJ one income / single $5k; single $10k 82.47 / 164.32; 647.90 82.48 / 164.30; 647.88 ✓
NY MFJ $5k 220.51 same ✓
IL MFJ $5k 247.50 same ✓
Federal MFJ $5k / $10k; single $5k / $10k; HoH $5k 236.67 / 836.67; 418.33 / 1,464.17; 329.00 same ✓
Programs CO FAMLI; MN PFML; NJ TDI / FLI; MA PFML 22.00; 22.00; 9.50 / 11.50; 23.00 same ✓

End-to-end page test (headless browser): ledger, Calculate gating, edit-reverts-to-grey, 120% gate, local field, two-earner fork, and program lines all verified. No page errors.


7. Open items

  1. 21 "est." states still use return brackets. The review measured them within $5/mo at one test point, but they aren't built to official methods or validated live. Highest-value next upgrades by population/VA volume: VA, OK, WI, MO, OR, CT.
  2. Local tax is a single household rate. Borrowers working in different localities, or MD's county tax being computed on MD taxable income rather than gross, aren't modeled precisely. Gross-wage basis is slightly conservative.
  3. CO HoH allowance is set to the single amount ($5,500), confirmed by PaycheckCity output but not by a DR 1098 source document.
  4. MN $10k MFJ not run live (same official table validated at $5k MFJ and single).
  5. Pay frequency is modeled monthly. Rounding states (CO, MN, MS, NC) round per pay period, so bi-weekly paystubs can differ by cents.
  6. 0.9% additional Medicare uses combined wages with the filing-status threshold (rarely triggers in VA files).
  7. HI program rate latest available, not confirmed 2026.
  8. SE half-tax deduction and QBI not modeled (conservative).
  9. Allowances / dependents field — every state runs at the zero-allowance default. A per-borrower allowance input remains the main accuracy lever for large-family files, where state dependent exemptions can be material.

8. Annual maintenance

Withholding formulas change on their own schedule, sometimes mid-year (four did in 2026). Everything that changes lives in labeled objects in the <script>:

  • FED, FED_STD — federal brackets and standard deduction
  • SS_CAP, MED_THRESH — FICA caps/thresholds
  • ST — fallback return brackets + std deductions (est. states, plus IL/IN/KY/MD/MI/PA exact)
  • azWH … utWH, CA_WH, NY_WH, MN_WH, NJ_A, NJ_B, CO_ALLOW — official withholding formulas
  • STATE_AUTH — state → formula registry
  • STATE_EXACT_FALLBACK, STATE_ROUND — tagging and rounding lists
  • PROG — program deduction rates/caps
  • FLOORS, OVER5_ADD, REGION — VA tables

Re-run Section 6 against PaycheckCity after each update. Best sources: each state's DOR withholding publication, and the USDA National Finance Center state-tax bulletins (help.nfc.usda.gov/bulletins), which publish exact payroll formulas with effective dates.