Mortgage Affordability Calculator EU 2026: DTI & LTV

TL;DR

A mortgage affordability calculator computes the maximum loan and house price a household can carry given income, existing debts, LTV ceiling, interest rate and term. Four concrete outputs at a 4 percent fixed 25-year rate:

• Household net income EUR 4,500/mo, DTI cap 35 percent -> max monthly payment EUR 1,575 -> max loan ~EUR 298,000.
• With 20 percent down payment -> max house price ~EUR 372,500.
• If rate jumps to 5 percent (stress test) -> max loan drops to ~EUR 269,000 (-10 percent).
• If household nets EUR 6,500/mo (couple) and supports both kids and a car loan EUR 300/mo -> effective DTI cap shrinks to 30 percent -> max payment EUR 1,650 -> max loan ~EUR 312,000.

Information only - not lending or investment advice.

What the Calculator Computes

A mortgage affordability calculator solves maximum loan amount under three simultaneous constraints:

1. Debt-to-income (DTI): monthly debt service / monthly net income <= DTI_cap (commonly 30-40 percent).
2. Loan-to-value (LTV): loan / property price <= LTV_cap (commonly 80-100 percent).
3. Stress test rate: payment recalculated at rate + 2-3 pp survives DTI cap.

The standard payment formula:

PMT = L * (r * (1 + r)^n) / ((1 + r)^n - 1)

where L = loan amount, r = monthly rate (annual / 12), n = months.

Inverting for max loan at a given payment ceiling:

L_max = PMT_max * ((1 + r)^n - 1) / (r * (1 + r)^n)

Then Price_max = L_max / LTV_cap and Down_payment = Price_max - L_max.

Inputs Needed

Worked Example 1: Beginner Profile

Maria & Carlos, Spanish couple, both 30, joint net income EUR 4,200/mo, no debts, savings EUR 60,000, want a flat in Valencia.

• DTI cap (Spanish norm): 35 percent -> max payment EUR 1,470.
• Rate: 3.7 percent fixed 30-yr 2026.
• Monthly rate: 0.003083.
• Months: 360.
• L_max = 1,470 * ((1.003083^360 - 1) / (0.003083 * 1.003083^360)) ~ EUR 319,400.
• LTV cap Spain (first home): 80 percent -> Price_max = 319,400 / 0.80 = EUR 399,250.
• Down payment needed: EUR 79,850 + ~10 percent transaction costs (ITP, notary, registry, valuation) ~ EUR 40,000 = total cash EUR 120,000.
• Maria & Carlos have EUR 60k - short by EUR 60k. Calculator output: they can afford a property closer to EUR 250,000 with 25 percent down + transaction costs covered.
• Stress test: at 5.5 percent (+1.8 pp), the same payment supports only EUR 259,000 loan. Banks may decline if stress fails.

Outcome: Headline affordability EUR 400k, realistic affordability ~EUR 250k. Save another 2-3 years or look further out.

Worked Example 2: Advanced Profile with Edge Cases

Lars, 41, Dutch senior consultant, net EUR 7,200/mo, partner net EUR 3,800/mo, joint EUR 11,000. Existing car lease EUR 450/mo. Two kids. Savings EUR 180,000.

• DTI cap (Dutch NHG / AFM 2026 norms): variable by income bracket, ~30 percent for high earners with mortgage interest deduction (HRA) phasing -> max gross payment ~EUR 3,300.
• After subtracting car lease and a kid-cost adjustment of ~EUR 800/mo (Nibud norm), effective max housing budget ~EUR 2,800/mo.
• Rate: 4.0 percent fixed 20-yr (Dutch annuity standard).
• L_max ~ EUR 462,000 at EUR 2,800 payment.
• LTV cap Netherlands: 100 percent for primary residence -> Price_max = EUR 462,000.
• Transaction costs (overdrachtsbelasting 2 percent, notary, valuation) ~ EUR 14,000.
• Down payment: NL allows 0 percent down but it's wise to put EUR 50-100k to reduce rate tier and HRA washout.
• Edge case 1 (HRA tapering): Dutch mortgage interest deduction caps at the 36.93 percent bracket in 2026 (was 49.5 percent pre-2020). High earners get less benefit, calculator must adjust net cost.
• Edge case 2 (Box 3 alternative): paying off mortgage faster reduces Box 3 wealth tax. After NHG limit (~EUR 405,000 in 2026), no NHG protection - higher rate.
• Edge case 3 (energy label): Dutch banks lend extra EUR 10,000-25,000 for A-label homes (verduurzaming). Calculator should support this bonus.

Outcome: Lars can afford a EUR 460-500k home in the Netherlands with realistic Dutch tax adjustments - tight in Amsterdam, comfortable in mid-sized cities.

EU Country Variations

A multi-country calculator should swap DTI, LTV, stress rate, and transaction cost defaults based on country selection.

Common Mistakes

1. Using gross income for DTI. Most EU lenders use net (post-tax, post-social-security). Calculator must accept net.
2. Ignoring existing debts. Car loans, student debt, credit cards, BNPL all reduce DTI capacity 1:1 on monthly service.
3. Forgetting transaction costs. Spanish ITP/AJD 6-10 percent, Italian imposta di registro 2-9 percent, German Grunderwerbsteuer 3.5-6.5 percent, Polish PCC 2 percent + notary. Add to cash needed, not loan amount.
4. Ignoring property tax and maintenance. Annual property tax + maintenance + insurance can add 1-2 percent of property value per year - reduces real disposable income.
5. Underestimating stress rate impact. A 4 percent fixed-rate decision today is robust. A 3 percent variable in 2021 became 5-6 percent in 2023; calculator should always show the +2-3 pp scenario.
6. Counting both partners' income at 100 percent. Conservative banks discount the lower income 20-30 percent. Use 90 percent of the smaller income as a sanity check.
7. Ignoring future life events. Pregnancy, parental leave, single-income shock - run a survivor stress test on one income only.
8. Confusing nominal payment with real cost. A 30-year mortgage at 4 percent has total interest cost ~70 percent of principal nominally; real cost (after inflation) is much lower.

Sensitivity Analysis

Baseline: net EUR 4,500/mo, DTI 35 percent, 4 percent rate, 25-yr term, 20 percent down.

Interest rate is the most volatile external lever; existing debts and DTI cap are most controllable internally.

DIY in Excel

Set up:

• B1: net_monthly_income

• B2: DTI_cap (e.g. 0.35)

• B3: existing_debts_monthly

• B4: max_payment = B1*B2 - B3

• B5: annual_rate (e.g. 0.04)

• B6: monthly_rate = B5/12

• B7: term_years (e.g. 25)

• B8: months = B7*12

• B9: max_loan = B4 * ((1+B6)^B8 - 1) / (B6 * (1+B6)^B8)

  (in Excel: = -PV(B6, B8, B4))

• B10: LTV_cap (e.g. 0.80)

• B11: max_price = B9 / B10

• B12: down_payment = B11 - B9

• B13: transaction_cost = B11 * 0.08 (country-specific)

• B14: total_cash_needed = B12 + B13

For stress test, change B5 to base+2 pp and read B9 / B11 again.

Build a 2-D data table over rate (rows 3-6 percent) and term (columns 20-35 yr) to see the full surface.

Polish Reader Angle (Belka, IKE/IKZE, ZUS, FX)

Pawel & Kasia, Warsaw, joint net PLN 14,000/mc, no debts, savings PLN 200,000, want a 60 sq.m flat.

• KNF Rekomendacja S DTI cap: 40-50 percent for higher earners after 2024 rules; effective ~40 percent -> max payment PLN 5,600/mc.
• Stress test: rate + 2.5 pp WIBOR mandated. Current WIRON-based mortgages 2026 ~6.5 percent; stress at 9 percent.
• At 6.5 percent fixed 25 yr (max loan at base rate):
  • r_monthly = 0.00542
  • L_max = 5,600 * ((1.00542^300 - 1) / (0.00542 * 1.00542^300)) ~ PLN 830,000.
• At stress 9 percent: L_max ~ PLN 668,000 - this is the binding constraint.
• LTV cap Poland: 80 percent (or 90 percent with mortgage insurance). At 80 percent LTV -> max price ~ PLN 835,000.
• Down payment 20 percent: PLN 167,000. Plus PCC 2 percent (PLN 16,700), notary + court fees (PLN 8,000-10,000) = total cash ~ PLN 195,000.
• Pawel & Kasia have PLN 200,000 - just enough.
• Belka note: mortgage interest is not tax-deductible in Poland (unlike Germany Riester-bauspar or Netherlands HRA). Investment alternative: keeping cash in IKE-sheltered ETFs at 7 percent vs 6.5 percent mortgage rate - close to break-even, marginal pro-mortgage-payoff after Belka.
• ZUS note: business owners on B2B should add ZUS forecast contributions to "existing debts" - banks include them.
• FX risk: avoid CHF/EUR mortgages post-2008-2015 crises. PLN-denominated is the safe default.
• Wakacje kredytowe 2024-2026 program: temporary payment pause, useful in income shock - factor into stress modelling.

A Polish mortgage calculator should default to WIRON-based rates, apply KNF DTI cap, run the +2.5 pp stress, and include PCC + notary in cash needs.

Hidden Costs the Affordability Calculator Misses

Beyond DTI and LTV, a complete affordability check needs to account for:

• Insurance: building insurance is mandatory in most EU countries; life/disability insurance is required for the mortgage in France (assurance emprunteur, often 0.2-0.4 percent of loan annually) and Belgium. Add 0.3-0.5 percent of loan per year on top of interest.
• Maintenance reserve: 1-1.5 percent of property value per year for older buildings, less for new. A EUR 400,000 flat needs roughly EUR 4,000-6,000/yr maintenance budget.
• HOA / commune fees: apartments in Spain, Italy, Portugal carry community fees EUR 50-300/month. Houses in France (taxe fonciere) and Italy (IMU on second homes) carry annual property taxes.
• Energy efficiency upgrades: EU EPBD recast (effective 2026-2030) mandates F/G label buildings be upgraded by certain dates. Buying a F/G label house can carry EUR 30,000-80,000 mandatory upgrade cost within 5 years.
• Resale liquidity: small towns and lower-tier cities have 12-24 month resale times. Calculator users should budget for delayed exit, especially in Italy's south, eastern Germany, and rural Spain.

A defensive affordability model treats the headline DTI capacity as the upper bound and shaves 10-20 percent for these hidden costs.

Buy vs Rent vs Invest: The Other Calculator

Mortgage affordability says "you can afford this". The companion question is "should you?" - which is a buy-vs-rent calculation.

The simplified model:

• Total monthly cost of owning = mortgage payment + property tax + insurance + maintenance + opportunity cost on down payment + opportunity cost on transaction costs.
• Total monthly cost of renting = rent + tenant insurance.
• If owning > renting by more than expected real appreciation (~1-2 percent/yr in EU long term), renting + investing the difference wins financially.

Concretely: a EUR 400,000 flat in Madrid 2026 might cost EUR 1,900/mo all-in for owners vs EUR 1,500/mo equivalent rental. The EUR 400/mo difference plus EUR 80k down payment opportunity cost (EUR 4,000-6,000/yr at 5-7 percent) is significant. Whether buying wins depends critically on holding period - typically >10 years for buying to dominate in high-cost EU metros.

A calculator that only shows the bank's maximum loan without showing the rent-equivalent comparison can mislead first-time buyers into overcommitting.

Freenance Note

A mortgage decision is a 25-year commitment that swallows the largest share of net income. Freenance's Financial Freedom Runway shows the post-mortgage cash buffer projection - so you can see whether the affordability number from this calculator still leaves room for emergency fund, retirement contributions, and lifestyle, not just the bank's DTI green light.

FAQ

Q: Should I borrow the maximum the calculator allows? A: No. Most planners suggest 25-30 percent DTI for resilience even when banks accept 35-40 percent. The extra 5-10 percent of income should fund pension and emergency buffer.

Q: Fixed vs variable rate in 2026? A: Fixed gives certainty - cost premium 0.3-0.8 pp vs starting variable rate. Variable benefits if EU rates fall but exposes to shock. 5-10-year fixed is a common middle ground.

Q: How much should I put down? A: 20 percent eliminates most LTV penalties and mortgage insurance in most EU countries. 30 percent unlocks best rates. Below 20 percent often means insurance + higher rate + tighter stress test.

Q: Does my partner's income always help? A: Joint applications combine incomes but also combine debts. Banks may discount the lower income or treat it more conservatively. Verify case-by-case.

Q: How are bonuses and variable income treated? A: Most EU banks use 2-3 year averages of variable income. Self-employed need 2-3 years of tax returns; some banks discount by 20-30 percent.

Q: What if my mortgage decision affects my FIRE timeline? A: A larger mortgage = lower savings rate = longer FIRE timeline. Model both: buy vs rent + invest the down payment. In high-price/high-rate environments (NL, FR, DE 2026), rent+invest can beat buy on a strictly financial basis for 5-10 year horizons.

Sources

ECB MFI interest rate statistics 2026. AFM (NL) and Nibud cost-of-living norms. HCSF (FR) DTI binding rule. KNF Rekomendacja S (PL). National notary association fee tables. Standard amortisation formula.

Disclaimer

This article is for informational and educational purposes only and does not constitute lending, investment, tax, or legal advice. Mortgage rules, DTI caps, LTV caps, stress test requirements and transaction costs in EU member states change frequently; verify with a licensed mortgage broker or your national regulator before applying. Past performance and current rates do not guarantee future borrowing terms.