Simple Mortgage Calculator

Mortgage parameters

This is the amount you will borrow and is called the loan's principal. The yearly interest rate (in %) should be a number between 0.01 and 100. Lower values are better for you! The total duration of the loan in years. It can be a fraction with 1/12 increments per extra month, for example 3.5 years (3 years and 6 months).
How frequently you will make payments? (in months) Minimum every month and maximum every year (12 months). In which month will you make your first payment? That is, how frequently interests are calculated. Banks will normally compound the interest at the same frequency that payments are made. Only consider a more frequent interest compounding than payment frequency if the loaner is willing to give you such a deal (for example, to reduce costs from commissions on currency trades or wire transfers).

Punchline


            

Loan's principle over time

The following interactive plot shows how the loan's principal changes over time as well as how much you've payed. You can use the bottom panel to zoom into a region of interest. You can also hover your mouse on top of a line to see the closest value.

Amortization table

The following interactive table shows how much you pay (and when), the total amount you have payed and the remaining principal (it is only shown for the months when interest compounding is calculated).

Download

Download the amortization table in CSV format. Download
Main source: Mortgage calculator by Wikipedia. Also used these instructions linked from 'Mortgage Calculator (and Amortization Charts) with R'. You may also want to check out the 'Mortgage Refinance Calculator'.
Chart made with rCharts with the NVD3 library.
Powered by Shiny and hosted by RStudio. Developed by L. Collado Torres. Version 0.0.2. Code hosted by GitHub.