Loan Calculator

$
%
months
Insurance and income (optional)
%

Applied to the loan amount. PMI usually costs about 0.3% to 1.5% a year when the down payment is under 20%.

 / month

Used to compute your debt-to-income ratio (DTI) for this loan.

Estimated term —
Total loan cost —
Interest cost —
Year-by-year amortization schedule
YearInterestPrincipal paidInsuranceRemaining balance

Loan calculator guide

Monthly payment or loan term: two ways to model a loan

This calculator estimates a fixed-rate amortizing loan, whether it is a mortgage, a car loan or a personal loan. It answers the two questions everyone asks before borrowing: "How much will I pay each month?" and "How long will it take to repay if I pay a set amount every month?". In both cases it shows the total cost of the loan, the total interest and a year-by-year amortization schedule, so you can compare scenarios before talking to a lender or a broker.

Filling in the calculator

  1. Currency: choose the currency used to display amounts. It does not change the calculation.
  2. Loan amount: enter the amount you want to borrow, excluding your down payment.
  3. Choose a mode with the two tabs:
    • Monthly payment: enter the annual interest rate and the term in months (180 months = 15 years, 360 months = 30 years);
    • Loan term: enter the monthly payment you can afford and the annual interest rate.
  4. Insurance and income (optional): open this panel to add a mortgage insurance or PMI rate and your gross monthly income. The calculator then shows the payment including insurance and your debt-to-income ratio for this loan.
  5. Read the result, updated as you type, then expand the amortization schedule to see, year by year, how much of your payments goes to interest and how much to principal.

How the monthly payment is calculated

The calculator uses the standard formula for a loan with equal monthly payments. The monthly rate is the annual rate divided by 12: i = annual rate ÷ 12.

Payment = P × i ÷ (1 − (1 + i)−n)

Term n = −ln(1 − P × i ÷ M) ÷ ln(1 + i)

where P is the amount borrowed, n the number of monthly payments and M the monthly payment. At a 0% rate, the payment is simply P ÷ n. In "loan term" mode the last payment is smaller than the others, and the total cost shown takes this into account.

Example: borrowing 150,000 at 3.5% over 240 months gives a monthly payment of about 869.94, a total cost of 208,785 and 58,785 of interest. Paying 900 a month at the same rate cuts the term to 229 months (19 years and 1 month) and the interest to about 55,700.

Reading the amortization schedule

Each payment first covers the month's interest, calculated on the remaining balance; the rest pays down the principal. Early in the loan the balance is high, so interest takes a large share of every payment. In the example above, the first year costs about 5,170 of interest for 5,270 of principal repaid; the last year, less than 200 of interest for more than 10,200 of principal. That is why extra payments save far more interest early in a loan than near the end.

Insurance and debt-to-income: what lenders look at

Questions about the results

Are property taxes and homeowners insurance included?

No. The payment covers principal and interest, plus mortgage insurance if you enter a rate. Property taxes, homeowners insurance and HOA fees often paid through an escrow account come on top.

Why does it say the payment doesn't even cover the interest?

If the payment is lower than or equal to the first month's interest (P × i), the balance never goes down and the loan can never be repaid. Increase the payment or reduce the amount borrowed.

Which rate should I enter?

The nominal annual interest rate quoted by the lender, without fees. Enter mortgage insurance separately in the "Insurance and income" panel.

Can it handle an adjustable-rate mortgage?

Not directly: it assumes the same rate for the whole term. To estimate an ARM after its fixed period, run a second simulation with the remaining balance from the amortization schedule, the new rate and the remaining term.

Is the result a loan offer?

No, it is an estimate for information only. Only the Loan Estimate and closing documents from your lender are binding.

Official sources

Further reading

📖 Read our article: Mortgage: 7 Ways to Lower the Cost of Your Loan