How DwellQ Works: Engine, Data Sources, and Formulas
Key Findings
The Net Worth Comparison Framework
DwellQ compares two parallel financial futures: renting (investing the capital you would have used as a down payment, plus any monthly surplus) versus buying (building equity through mortgage payments, appreciation, and tax benefits, minus all ownership costs). Both paths are simulated month-by-month over the full holding period. The result is a net worth comparison at every point in time, showing when (or whether) one path overtakes the other.
Month-by-Month Simulation
Unlike simple calculators that use annual averages, DwellQ models each month individually. This matters because mortgage amortization, PMI drop-off, ARM rate resets, property tax reassessments, and investment compounding all happen on specific timelines. Monthly simulation captures: principal vs interest split on every payment, exact PMI removal month (when LTV reaches 78%), ARM rate adjustments at specified intervals, property tax reassessment at annual boundaries, rent growth compounding, and investment portfolio growth including monthly contributions from the renter’s surplus.
The Renter’s Portfolio
DwellQ models the renter as an active investor, not a passive consumer. The renter starts with the full down payment amount invested in a diversified portfolio (default: 7% nominal annual return). Each month, if the renter’s total housing cost (rent + renter’s insurance + utilities) is less than the buyer’s total cost (mortgage + property tax + insurance + maintenance + HOA), the surplus is added to the portfolio. If renting costs more, the deficit is withdrawn. This dynamic monthly tracking is what most calculators omit entirely.
Tax Intelligence (Q+)
The Q+ premium tier models tax implications at every level: mortgage interest deduction (only the portion above the standard deduction threshold), property tax deduction (subject to the SALT cap, which varies by filing status and year per OBBBA 2025 provisions), PMI deductibility (income-phased), state income tax rates, and capital gains tax at exit (with the $250K/$500K home sale exclusion for buyers). DwellQ compares itemized deductions against the standard deduction each year and only applies the larger benefit—the same logic the IRS uses.
Data Sources
Mortgage rates: Federal Reserve Economic Data (FRED), updated weekly via API. Appreciation rates: FHFA House Price Index (Purchase-Only), state-level quarterly data. Property tax rates: Tax Foundation and ATTOM Data, 50 states + DC. Insurance rates: Insurance Information Institute (III) and NAIC, 50 states + DC. Standard deduction: IRS Publication 501. SALT cap: One Big Beautiful Bill Act (OBBBA, H.R. 1, 2025). S&P 500 returns: FRED Total Return Index, used for default investment return assumption. All sources are publicly available and cited in every calculation.
What DwellQ Does Not Do
DwellQ produces scenario-based projections, not predictions. It does not forecast future home prices, interest rates, or market movements. It does not account for individual tax situations beyond the inputs provided (consult a CPA for tax advice). It does not include location-specific factors like flood risk, HOA special assessments, or local rent control unless manually adjusted by the user. The value of the tool is in modeling the complete set of relevant variables and letting you test sensitivity—not in claiming to know the future.
Frequently Asked Questions
- Federal Reserve Bank of St. Louis. FRED: 30-Year Fixed Mortgage Rate, S&P 500 Total Return Index.[fred.stlouisfed.org]
- Federal Housing Finance Agency. House Price Index (Purchase-Only), Quarterly.[fhfa.gov/data/hpi]
- Tax Foundation. State and Local Property Tax Rates by State.[taxfoundation.org]
- Insurance Information Institute. Homeowners Insurance Facts and Statistics.[iii.org]
- IRS. Publication 501: Standard Deduction. Publication 936: Mortgage Interest Deduction.[irs.gov]
- One Big Beautiful Bill Act, H.R. 1, 119th Congress (2025). SALT Cap Provisions.
- Beracha, E. and Johnson, K.H. ‘Lessons from Over 30 Years of Buy vs Rent Decisions.’ Real Estate Economics, 40(2), 2012.