# Mortgage Calculator with Amortization Schedule and Extra Payment

> Free mortgage calculator: monthly payment, fixed-payment vs equal-principal, total interest, taxes and insurance, extra payments and a yearly schedule as CSV.

- URL: https://qilingtools.com/en/math/mortgage
- Category: Math Tools (https://qilingtools.com/en/math)
- Tags: [Math](https://qilingtools.com/en/tags/math), [Finance](https://qilingtools.com/en/tags/finance), [Everyday Life](https://qilingtools.com/en/tags/life)
- Last updated: 2026-10-26
- Price: Free, no sign-up
- Privacy: Runs locally in the browser; files are never uploaded

Work out what a home really costs each month and over the life of the loan. Enter the home price and down payment percentage (or the loan amount directly), the term and the interest rate to get the monthly principal-and-interest payment, the total interest and the total of all payments. Add property tax, homeowners insurance and HOA dues to see the full monthly housing cost. The comparison table sets a standard fixed payment against an equal-principal loan, where payments start higher but total interest is lower. The extra payment simulator shows what one lump sum after a chosen payment does: keep the payment and pay off years sooner, or keep the term and lower the payment — with the interest saved for each. The amortization schedule summarizes each year and expands to every monthly payment; export it as CSV or send the remaining-balance curve to the graphing tool.

## How to use

1. Enter the home price and down payment (or the loan amount), the term in years and the interest rate
2. Optionally add property tax, insurance and HOA to see the full monthly cost
3. Simulate an extra payment, review the amortization schedule and export it as CSV

## Features

- Monthly payment from price and down payment or loan amount
- Monthly cost including property tax, insurance and HOA
- Fixed payment vs equal principal comparison
- One-time extra payment: shorten term or lower payment, with interest saved
- Yearly amortization schedule expandable to monthly rows
- CSV export and remaining-balance chart

## FAQ

### How is the monthly mortgage payment calculated?

For a standard fixed-payment (amortizing) loan the payment is M = P·i(1+i)ⁿ / [(1+i)ⁿ − 1], where P is the loan amount, i the annual rate divided by 12 and n the number of monthly payments. For example, $320,000 at 6.5% for 30 years is about $2,022.62 a month before taxes and insurance.

### How much does an extra payment save?

An extra payment goes straight to principal, so every later payment carries less interest. Keeping the same payment (shortening the term) usually saves the most interest; keeping the term and lowering the payment frees up monthly cash instead. Turn on the extra payment simulation to see the interest saved and the new number of payments for either choice.

### What is the difference between fixed payment and equal principal?

With a fixed payment every installment is the same and early payments are mostly interest. With equal principal you repay the same amount of principal each month plus interest on the remaining balance, so payments start higher and fall steadily, and total interest is lower. The comparison table shows both side by side.

### Does the payment include taxes and insurance?

The main figure is principal and interest only. Fill in the annual property tax rate, yearly homeowners insurance and monthly HOA dues to get the total monthly housing cost (often called PITI plus HOA). Private mortgage insurance and closing costs are not included, and your lender’s escrow figures may differ slightly.

## Related tools

- [Graphing Calculator](https://qilingtools.com/en/math/graph): Free online function graphing calculator: type sin(x), x^2 or 1/x and see the curve at once, with several functions, parametric and polar curves, PNG export.
- [Scientific Calculator](https://qilingtools.com/en/math/calculator): Free online scientific calculator: type 2*(3+4)^2, sin(pi/6) or log(8,2) and see the answer as you type, with degrees or radians and a history list.
- [Equation Solver](https://qilingtools.com/en/math/equation): Free online equation solver: enter coefficients for linear, quadratic (with discriminant, vertex and complex roots) and cubic equations, plus 2×2 systems.
- [Fraction Calculator](https://qilingtools.com/en/math/fraction): Free online fraction calculator: add, subtract, multiply and divide fractions with automatic reduction, plus fraction ↔ decimal with repeating digits.
- [Percentage Calculator](https://qilingtools.com/en/math/percentage): Free online percentage calculator: X% of Y, X as a percent of Y, increase and decrease, a value after a percentage change and the original behind it.
- [Prime Factorization](https://qilingtools.com/en/math/prime): Free online prime factorization: factor an integer with exponents, list every divisor and their sum, test primality with neighbouring primes, or list a range.
- [GCD and LCM](https://qilingtools.com/en/math/gcd-lcm): Free online GCD and LCM calculator: works with two or more integers, says whether they are coprime, shows each prime factorization and every Euclidean step.
- [Statistics Calculator](https://qilingtools.com/en/math/statistics): Free online statistics calculator: paste a data set for the mean, median, mode, range, quartiles, variance, standard deviation, standard error and outliers.