NichesTools

Mortgage Amortization Planner

The amortization calendar divides a fixed‑rate mortgage into equal payments that service both interest and principal. Each month the lender collects interest on the outstanding balance; the remainder of the payment reduces the loan principal. Repeating this process over the agreed term (years × 12) produces a predictable payoff schedule with a clear total amount paid and cumulative interest. The calculator uses the standard fixed‑rate monthly payment formula: p = P imes \frac{r(1+r)^n}{(1+r)^n-1} on the base case, where P = principal, r = annual interest rate divided by 12, and n is the number of payments. Zero‑interest loans are handled as a simple division of the principal by the payment count. Both the total amount repaid and total interest are derived directly from that monthly payment and the set term, ensuring all outputs are mathematically consistent.

Enter the amount of money you are borrowing to purchase a home. Expressed in dollars.
Annual nominal interest rate applied to the loan, expressed as a percentage (e.g., 5 for 5%).
The number of years you will repay the loan over.

What it is

The Mortgage Amortization Planner provides a precise calculation of the amount you will pay each month on a fixed‑rate mortgage, as well as the cumulative cost over the life of the loan. It models how the interest component declines while the principal portion grows, producing a clear payoff schedule that helps buyers evaluate loan options and plan cash flows. Understanding this structure is essential for budgeting, comparing rates, and estimating total ownership costs. It also serves as a foundational tool for deeper financial literacy and planning.

How to use it

Enter your loan amount in dollars, the annual fixed interest rate as a percentage, and the term length in years. The calculator returns the monthly payment, the total number of months required to repay the loan, the overall cost you will pay over the life of the mortgage, and the sum of all interest charges. Use these figures to compare different rates or terms and to decide which deal fits your financial goals.

Worked example

For a $200,000 loan at 5 % annual interest over 30 years: • Convert the yearly rate to a monthly rate: r = 0.05/12 ≈ 0.0041667. • Number of payments n = 30×12 = 360 months. • Monthly payment calculated by p = P·r(1+r)^n/( (1+r)^n−1) → p ≈ $1,073.64 per month. • Total paid over the life: 1,073.64 × 360 ≈ $386,511.57. • Interest paid = total - principal = $386,511.57 – $200,000 ≈ $186,511.57. These results can be checked directly against a standard mortgage spreadsheet or online calculator.

Inputs

  • Loan Principal: 200000
  • Annual Interest Rate (%): 5
  • Term Length (Years): 30

Result

  • Loan Term (Months): 360
  • Monthly Payment: 1073.64
  • Total Paid Over Life: 386511.57
  • Total Interest Paid: 186511.57

Frequently asked questions

Can I use the tool for a biweekly payment schedule?

This version focuses on fixed‑rate monthly payments. If you wish to model biweekly or other payment frequencies, adjust your inputs accordingly in another tool that supports those options.

How does this compare to a mortgage with adjustable rates?

Adjustable‑rate mortgages involve changing interest over time; they cannot be accurately represented with a simple fixed-rate formula. For ARM products, use a dedicated calculator that accepts rate change events and recalculates amortization schedules accordingly.

Related tools