Skip to content
Marvin's Toolbox.

Loan Calculator

Work out the monthly payment, total interest and payoff date of a loan or mortgage, find the loan you can afford from a payment, or how long a payment takes. See the full amortization schedule, the balance after a fixed-rate period and how extra payments shorten it.

Runs entirely in your browser. Nothing you put in here gets uploaded.

Loan

EUR
% / year

The nominal rate per year, as the bank quotes it.

Term
years
months

The first payment is due one period later.

years

Optional. Shows what is still owed when it ends.

Monthly payment

Extra repayments

Pay more than the regular payment to repay the loan sooner and save interest.

EUR

Goes straight to the principal.

Special repayments
Interest saved

Balance over time

Amortization schedule

About the Loan Calculator Tool

This tool works out an annuity loan, the kind with the same payment every month that most mortgages, car loans and personal loans use. Give it the loan amount, the interest rate and the term to get the payment, or turn the question around and find the loan a payment affords or how long a payment takes to clear a loan.

Below the answer you get the total interest, the payoff date, a chart of the balance over time and the full amortization schedule, by year or by payment, ready to download as CSV.

What you can do

  • Calculate the monthly payment of a loan or mortgage
  • Find out how much you can borrow for a given monthly payment
  • Work out how long it takes to pay off a loan
  • See the total interest and the payoff date
  • Create an amortization schedule and download it as CSV
  • See how extra monthly payments shorten a loan and how much interest they save
  • Plan one-off special repayments
  • Find the remaining balance when a fixed-rate period ends
  • Enter a mortgage by its initial repayment rate
  • Calculate weekly, biweekly, quarterly or yearly payments

How to use the Loan Calculator

  1. 1Pick what to calculate with the tabs: the payment, the loan amount or the term.
  2. 2Fill in the loan amount or the payment, the interest rate and the term. The term can also be an initial repayment rate in percent per year.
  3. 3Set how often you pay, when the loan starts and, if your rate is fixed for a while, how many years it is fixed.
  4. 4Add an extra amount for every payment or one-off special repayments to see the interest and time they save.
  5. 5Read the schedule by year or by payment, and download it as CSV for a spreadsheet.

How the payment is calculated

The payment comes from the standard annuity formula: the loan times the periodic rate, divided by one minus (1 + rate) to the power of minus the number of payments. The periodic rate is the yearly rate divided by the number of payments per year, which is how banks quote a nominal rate. At 0% the loan is simply split into equal parts.

Each payment first covers the interest on the open balance, rounded to the cent, and the rest repays the loan. Since the payment is rounded too, the last payment is a little higher or lower so the balance lands on exactly zero. The effective rate shown next to the result is the nominal rate compounded over a year. It leaves out fees, so the rate in your loan contract can be higher.

Initial repayment rate

Mortgages in Germany and Austria are often agreed as an interest rate plus an initial repayment rate, for example 4% interest and 2% repayment. The yearly payment is then 6% of the loan, split over the payments of the year. Pick Repayment rate under Term to enter a loan this way, and the tool works out how long it runs.

Fixed-rate periods and extra payments

Many mortgages fix the rate for 5, 10 or 15 years only. Enter that period and the result shows what you still owe when it ends, which is the amount you need to refinance. The schedule marks the payment where it happens.

Extra payments and special repayments go straight to the principal and never past what is still owed. A special repayment is paid together with the first regular payment on or after its date. The savings compare the same loan with and without them, and the chart draws the balance without them as a dashed line.

Tools that share a tag with this one.

See what a monthly ETF savings plan can grow to. Set a starting amount, contribution, expected return, fund costs and duration to get the final value, your contributions, the gains, the cost of the TER and the effect of inflation and tax, year by year. Also finds the contribution a target needs and how long withdrawals last.

Enter a salary as an hourly, monthly or yearly figure and the rest fill in for you, including what you actually earn per second, minute, hour and working day. Set your currency and adjust your hours per day, days per week and weeks per year.

Enter a resolution to get its simplified aspect ratio, or start from a ratio and one side to get the missing dimension. Knows the common ratios like 16:9, 4:3 and 21:9 and shows how close your size is to each.

Calculate AND, OR, XOR, NOT and bit shifts with a live binary view of every operand and the result. Enter numbers in decimal, hex, octal or binary and see each bit line up as you type.

Convert Unix file permissions between checkboxes, octal like 755 and symbolic notation like rwxr-xr-x, all kept in sync as you edit any of them. Covers setuid, setgid and the sticky bit, and shows the matching chmod command ready to copy.

Convert between px, rem, em, percent, pt and viewport units with a configurable root font size. Type into any field and the others update as you go, set the parent font size for em math, and read a conversion table for common sizes.