Calculate Ability

Loan Calculator

Monthly payment, total interest and amortization schedule.

Inputs

$
%
yrs

Results

Monthly payment

$1,580.17

360 payments of principal and interest

Total principal$250,000
Total interest$318,861
Total repaid$568,861
Interest as share of principal128%

$1,580.17/mo · $318,861 interest

Amortization schedule

MonthPaymentInterestPrincipalBalance
1$1,580.17$1,354.17$226.00$249,774.00
2$1,580.17$1,352.94$227.23$249,546.77
3$1,580.17$1,351.71$228.46$249,318.31
4$1,580.17$1,350.47$229.70$249,088.61
5$1,580.17$1,349.23$230.94$248,857.67
6$1,580.17$1,347.98$232.19$248,625.48
7$1,580.17$1,346.72$233.45$248,392.04
8$1,580.17$1,345.46$234.71$248,157.32
9$1,580.17$1,344.19$235.98$247,921.34
10$1,580.17$1,342.91$237.26$247,684.07
11$1,580.17$1,341.62$238.55$247,445.53
12$1,580.17$1,340.33$239.84$247,205.69

How this is calculated

A fully amortizing loan is repaid in equal instalments that cover the interest accrued that month plus a slice of the principal. The payment comes from the standard annuity formula:

M = P × r ÷ (1 − (1 + r)^−n)

Here P is the principal, r is the monthly interest rate (annual rate divided by twelve) and n is the total number of payments. With a zero interest rate the formula collapses to principal divided by the number of payments.

Each row of the schedule is built by applying the payment to the outstanding balance:

interest = balance × r  |  principal = payment − interest  |  balance = balance − principal

Early payments are mostly interest because the balance is high. As the balance falls, more of each payment goes to principal, which is why extra payments made in the first years of a loan save far more interest than the same amount paid later.

Frequently asked questions