Amortization Mortgages Calculator

Formatting only. This does not change the calculation.
The nominal annual rate (APR before fees), not the monthly rate.
Added to the term in years, for terms such as 5 years and 6 months. To state a tenure purely in months, set the years to 0 and enter the whole tenure here.
Additional principal paid on top of the scheduled payment.
Payment
1,896.20
Amortization Schedule Calculator
Total interest
382,636.71
Total of payments
682,636.71
Number of payments
360
Payoff time
30 years
Rate per period
0.541667 %
Interest per unit borrowed
1.2755
Interest saved by extra payments
0
Payments saved
0
Interest in the first payment
1,625
Principal in the first payment
271.2
Payment where principal overtakes interest
233
Payment where the balance is half repaid
257
Balance after one year
296,646.88
Worked out from Standard annuity-immediate payment formula, PMT = P i / (1 - (1+i)^-n) and 1 other source.

How this is worked out

5 steps
  1. Each period, interest = outstanding balance x 0.541667%; the rest of the payment reduces principal.
  2. Payment 1: 1625 interest and 271.2 principal.
  3. From payment 233 onwards more of each payment goes to principal than to interest.
  4. The balance is half repaid by payment 257.
  5. Year 1 ends with 296646.88 outstanding, 1.12% of the loan retired.
Amortisation scheduletable
periodpaymentinterestprincipalbalance
11,896.21,625271.2299,728.8
21,896.21,623.53272.67299,456.13
31,896.21,622.05274.15299,181.98
41,896.21,620.57275.63298,906.35
51,896.21,619.08277.12298,629.23
61,896.21,617.57278.63298,350.6
71,896.21,616.07280.13298,070.47
81,896.21,614.55281.65297,788.82
91,896.21,613.02283.18297,505.64
101,896.21,611.49284.71297,220.93
111,896.21,609.95286.25296,934.68
121,896.21,608.4287.8296,646.88
131,896.21,606.84289.36296,357.52
141,896.21,605.27290.93296,066.59
151,896.21,603.69292.51295,774.08
161,896.21,602.11294.09295,479.99
171,896.21,600.52295.68295,184.31
181,896.21,598.92297.28294,887.03
191,896.21,597.3298.9294,588.13
201,896.21,595.69300.51294,287.62
211,896.21,594.06302.14293,985.48
221,896.21,592.42303.78293,681.7
231,896.21,590.78305.42293,376.28
241,896.21,589.12307.08293,069.2
251,896.21,587.46308.74292,760.46
261,896.21,585.79310.41292,450.05
271,896.21,584.1312.1292,137.95
281,896.21,582.41313.79291,824.16
291,896.21,580.71315.49291,508.67
301,896.21,579.01317.19291,191.48
311,896.21,577.29318.91290,872.57
321,896.21,575.56320.64290,551.93
331,896.21,573.82322.38290,229.55
341,896.21,572.08324.12289,905.43
351,896.21,570.32325.88289,579.55
361,896.21,568.56327.64289,251.91
371,896.21,566.78329.42288,922.49
381,896.21,565331.2288,591.29
391,896.21,563.2333288,258.29
401,896.21,561.4334.8287,923.49
411,896.21,559.59336.61287,586.88
421,896.21,557.76338.44287,248.44
431,896.21,555.93340.27286,908.17
441,896.21,554.09342.11286,566.06
451,896.21,552.23343.97286,222.09
461,896.21,550.37345.83285,876.26
471,896.21,548.5347.7285,528.56
481,896.21,546.61349.59285,178.97
491,896.21,544.72351.48284,827.49
501,896.21,542.82353.38284,474.11
511,896.21,540.9355.3284,118.81
521,896.21,538.98357.22283,761.59
531,896.21,537.04359.16283,402.43
541,896.21,535.1361.1283,041.33
551,896.21,533.14363.06282,678.27
561,896.21,531.17365.03282,313.24
571,896.21,529.2367281,946.24
581,896.21,527.21368.99281,577.25
591,896.21,525.21370.99281,206.26
601,896.21,523.2373280,833.26
611,896.21,521.18375.02280,458.24
621,896.21,519.15377.05280,081.19
631,896.21,517.11379.09279,702.1
641,896.21,515.05381.15279,320.95
651,896.21,512.99383.21278,937.74
661,896.21,510.91385.29278,552.45
671,896.21,508.83387.37278,165.08
681,896.21,506.73389.47277,775.61
691,896.21,504.62391.58277,384.03
701,896.21,502.5393.7276,990.33
711,896.21,500.36395.84276,594.49
721,896.21,498.22397.98276,196.51
731,896.21,496.06400.14275,796.37
741,896.21,493.9402.3275,394.07
751,896.21,491.72404.48274,989.59
761,896.21,489.53406.67274,582.92
771,896.21,487.32408.88274,174.04
781,896.21,485.11411.09273,762.95
791,896.21,482.88413.32273,349.63
801,896.21,480.64415.56272,934.07
811,896.21,478.39417.81272,516.26
821,896.21,476.13420.07272,096.19
831,896.21,473.85422.35271,673.84
841,896.21,471.57424.63271,249.21
851,896.21,469.27426.93270,822.28
861,896.21,466.95429.25270,393.03
871,896.21,464.63431.57269,961.46
881,896.21,462.29433.91269,527.55
891,896.21,459.94436.26269,091.29
901,896.21,457.58438.62268,652.67
911,896.21,455.2441268,211.67
921,896.21,452.81443.39267,768.28
931,896.21,450.41445.79267,322.49
941,896.21,448448.2266,874.29
951,896.21,445.57450.63266,423.66
961,896.21,443.13453.07265,970.59
971,896.21,440.67455.53265,515.06
981,896.21,438.21457.99265,057.07
991,896.21,435.73460.47264,596.6
1001,896.21,433.23462.97264,133.63
1011,896.21,430.72465.48263,668.15
1021,896.21,428.2468263,200.15
1031,896.21,425.67470.53262,729.62
1041,896.21,423.12473.08262,256.54
1051,896.21,420.56475.64261,780.9
1061,896.21,417.98478.22261,302.68
1071,896.21,415.39480.81260,821.87
1081,896.21,412.79483.41260,338.46
1091,896.21,410.17486.03259,852.43
1101,896.21,407.53488.67259,363.76
1111,896.21,404.89491.31258,872.45
1121,896.21,402.23493.97258,378.48
1131,896.21,399.55496.65257,881.83
1141,896.21,396.86499.34257,382.49
1151,896.21,394.16502.04256,880.45
1161,896.21,391.44504.76256,375.69
1171,896.21,388.7507.5255,868.19
1181,896.21,385.95510.25255,357.94
1191,896.21,383.19513.01254,844.93
1201,896.21,380.41515.79254,329.14

First 120 of 360 rows.

Yearly summarytable
yearinterestprincipalendingBalance
119,401.283,353.12296,646.88
219,176.723,577.68293,069.2
318,937.113,817.29289,251.91
418,681.464,072.94285,178.97
518,408.694,345.71280,833.26
618,117.654,636.75276,196.51
717,807.14,947.3271,249.21
817,475.785,278.62265,970.59
917,122.275,632.13260,338.46
1016,745.086,009.32254,329.14
1116,342.616,411.79247,917.35
1215,913.226,841.18241,076.17
1315,455.047,299.36233,776.81
1414,966.27,788.2225,988.61
1514,444.568,309.84217,678.77
1613,888.078,866.33208,812.44
1713,294.289,460.12199,352.32
1812,660.710,093.7189,258.62
1911,984.7110,769.69178,488.93
2011,263.4511,490.95166,997.98
2110,493.8712,260.53154,737.45
229,672.7613,081.64141,655.81
238,796.6713,957.73127,698.08
247,861.8914,892.51112,805.57
256,864.5115,889.8996,915.68
265,800.3516,954.0579,961.63
274,664.9118,089.4961,872.14
283,453.4119,300.9942,571.15
292,160.7620,593.6421,977.51
30781.621,977.510
Chart series, one row a yeartable
yearinterestprincipalcumulativeInterestcumulativePrincipalendingBalancepercentPaidOff
119,401.283,353.1219,401.283,353.12296,646.881.12
219,176.723,577.6838,5786,930.8293,069.22.31
318,937.113,817.2957,515.1110,748.09289,251.913.58
418,681.464,072.9476,196.5714,821.03285,178.974.94
518,408.694,345.7194,605.2619,166.74280,833.266.39
618,117.654,636.75112,722.9123,803.49276,196.517.93
717,807.14,947.3130,530.0128,750.79271,249.219.58
817,475.785,278.62148,005.7934,029.41265,970.5911.34
917,122.275,632.13165,128.0639,661.54260,338.4613.22
1016,745.086,009.32181,873.1445,670.86254,329.1415.22
1116,342.616,411.79198,215.7552,082.65247,917.3517.36
1215,913.226,841.18214,128.9758,923.83241,076.1719.64
1315,455.047,299.36229,584.0166,223.19233,776.8122.07
1414,966.27,788.2244,550.2174,011.39225,988.6124.67
1514,444.568,309.84258,994.7782,321.23217,678.7727.44
1613,888.078,866.33272,882.8491,187.56208,812.4430.4
1713,294.289,460.12286,177.12100,647.68199,352.3233.55
1812,660.710,093.7298,837.82110,741.38189,258.6236.91
1911,984.7110,769.69310,822.53121,511.07178,488.9340.5
2011,263.4511,490.95322,085.98133,002.02166,997.9844.33
2110,493.8712,260.53332,579.85145,262.55154,737.4548.42
229,672.7613,081.64342,252.61158,344.19141,655.8152.78
238,796.6713,957.73351,049.28172,301.92127,698.0857.43
247,861.8914,892.51358,911.17187,194.43112,805.5762.4
256,864.5115,889.89365,775.68203,084.3296,915.6867.69
265,800.3516,954.05371,576.03220,038.3779,961.6373.35
274,664.9118,089.49376,240.94238,127.8661,872.1479.38
283,453.4119,300.99379,694.35257,428.8542,571.1585.81
292,160.7620,593.64381,855.11278,022.4921,977.5192.67
30781.621,977.51382,636.71300,0000100

Results are general information, not financial, tax, legal, medical or engineering advice.