Home Loan Calculator
Estimate a home loan
Estimate how much a lender would finance and your monthly payment from the property value and the down payment percentage. Useful for gauging what home you can afford: you need the value, down payment %, interest rate and term.
Calculate financing and payment
Result
Monthly payment
€801.00
- Down payment
- €40,000.00
- Loan amount
- €160,000.00
- Total interest
- €80,298.98
- Total paid to the lender
- €240,298.98
Formula version: 1.0.0
Show year-by-year breakdown
| Year | Paid | Interest | Principal repaid | Balance |
|---|---|---|---|---|
| 1 | €9,612.00 | €5,535.01 | €4,076.99 | €155,923.01 |
| 2 | €9,612.00 | €5,390.00 | €4,222.00 | €151,701.01 |
| 3 | €9,612.00 | €5,239.85 | €4,372.15 | €147,328.86 |
| 4 | €9,612.00 | €5,084.34 | €4,527.66 | €142,801.20 |
| 5 | €9,612.00 | €4,923.30 | €4,688.70 | €138,112.50 |
| 6 | €9,612.00 | €4,756.54 | €4,855.46 | €133,257.04 |
| 7 | €9,612.00 | €4,583.85 | €5,028.15 | €128,228.89 |
| 8 | €9,612.00 | €4,405.02 | €5,206.98 | €123,021.91 |
| 9 | €9,612.00 | €4,219.81 | €5,392.19 | €117,629.72 |
| 10 | €9,612.00 | €4,028.03 | €5,583.97 | €112,045.75 |
| 11 | €9,612.00 | €3,829.42 | €5,782.58 | €106,263.17 |
| 12 | €9,612.00 | €3,623.75 | €5,988.25 | €100,274.92 |
| 13 | €9,612.00 | €3,410.77 | €6,201.23 | €94,073.69 |
| 14 | €9,612.00 | €3,190.24 | €6,421.76 | €87,651.93 |
| 15 | €9,612.00 | €2,961.83 | €6,650.17 | €81,001.76 |
| 16 | €9,612.00 | €2,725.30 | €6,886.70 | €74,115.06 |
| 17 | €9,612.00 | €2,480.35 | €7,131.65 | €66,983.41 |
| 18 | €9,612.00 | €2,226.67 | €7,385.33 | €59,598.08 |
| 19 | €9,612.00 | €1,964.01 | €7,647.99 | €51,950.09 |
| 20 | €9,612.00 | €1,692.00 | €7,920.00 | €44,030.09 |
| 21 | €9,612.00 | €1,410.32 | €8,201.68 | €35,828.41 |
| 22 | €9,612.00 | €1,118.60 | €8,493.40 | €27,335.01 |
| 23 | €9,612.00 | €816.52 | €8,795.48 | €18,539.53 |
| 24 | €9,612.00 | €503.71 | €9,108.29 | €9,431.24 |
| 25 | €9,610.98 | €179.74 | €9,431.24 | €0.00 |
How to use the home loan calculator
- Enter the property value.
- Enter the percentage you'll put down.
- Enter the fixed interest rate and term, then review the loan amount and payment.
Home loan formula
Loan = value × (1 − down %) · Payment = L × i / (1 − (1 + i)^−n)
What each variable means
- L
- loan amount
- i
- monthly rate
- n
- term in months
The down payment lowers the amount you borrow and, with it, the payment and interest.
Home loan example
A €200,000 home with 20% down (€40,000): €160,000 is financed. At 3.5% over 25 years, the payment is €801 a month and you'll pay €80,298.98 in interest.
Illustrative example with the data shown; not a guaranteed outcome.
Assumptions and limitations
- Fixed rate and constant payment.
- Purchase taxes, notary, insurance and fees are not included.
- The percentage applies to the value entered, which may differ from the appraisal.
Frequently asked questions
How is this different from the mortgage calculator?
Here the down payment is a percentage of the value; in the mortgage calculator you enter it as an amount and can add purchase costs.
How much down payment do I need?
Besides the down payment, budget for purchase costs. Many lenders finance up to 80% of the value.
Related calculators
See loans & mortgages calculatorsIndicative result for information only; not financial or tax advice. Read the legal notice · How we calculate results
Spotted a possible error in this calculator? Let us know