Mortgage Calculator

Payment Calculation Table

Loan Principal Amount $  
Annual Interest Rate (%)     %
Number of Payments    
Monthly Payment (Principal & Interest) $ 1,170.01  
 

Instructions

Enter mortgage loan data into the table above to calculate your monthly payment and produce an amortization table with principal, interest, and remaining balance information for each payment. To enter new amounts, type them into the table and press the "Update" button.

Amortization Schedule

#
PAYMENT
INTEREST
PRINCIPAL
BALANCE
1
1,170.01
1,036.22
133.79
171,378.21
2
1,170.01
1,035.41
134.60
171,243.61
3
1,170.01
1,034.60
135.41
171,108.20
4
1,170.01
1,033.78
136.23
170,971.96
5
1,170.01
1,032.96
137.05
170,834.91
6
1,170.01
1,032.13
137.88
170,697.03
7
1,170.01
1,031.29
138.72
170,558.31
8
1,170.01
1,030.46
139.55
170,418.76
9
1,170.01
1,029.61
140.40
170,278.36
10
1,170.01
1,028.77
141.24
170,137.12
11
1,170.01
1,027.91
142.10
169,995.02
12
1,170.01
1,027.05
142.96
169,852.06
13
1,170.01
1,026.19
143.82
169,708.24
14
1,170.01
1,025.32
144.69
169,563.55
15
1,170.01
1,024.45
145.56
169,417.99
16
1,170.01
1,023.57
146.44
169,271.55
17
1,170.01
1,022.68
147.33
169,124.22
18
1,170.01
1,021.79
148.22
168,976.00
19
1,170.01
1,020.90
149.11
168,826.89
20
1,170.01
1,020.00
150.01
168,676.87
21
1,170.01
1,019.09
150.92
168,525.95
22
1,170.01
1,018.18
151.83
168,374.12
23
1,170.01
1,017.26
152.75
168,221.37
24
1,170.01
1,016.34
153.67
168,067.70
25
1,170.01
1,015.41
154.60
167,913.10
26
1,170.01
1,014.47
155.54
167,757.56
27
1,170.01
1,013.54
156.47
167,601.09
28
1,170.01
1,012.59
157.42
167,443.67
29
1,170.01
1,011.64
158.37
167,285.29
30
1,170.01
1,010.68
159.33
167,125.97
31
1,170.01
1,009.72
160.29
166,965.68
32
1,170.01
1,008.75
161.26
166,804.42
33
1,170.01
1,007.78
162.23
166,642.18
34
1,170.01
1,006.80
163.21
166,478.97
35
1,170.01
1,005.81
164.20
166,314.77
36
1,170.01
1,004.82
165.19
166,149.58
37
1,170.01
1,003.82
166.19
165,983.39
38
1,170.01
1,002.82
167.19
165,816.20
39
1,170.01
1,001.81
168.20
165,647.99
40
1,170.01
1,000.79
169.22
165,478.77
41
1,170.01
999.77
170.24
165,308.53
42
1,170.01
998.74
171.27
165,137.26
43
1,170.01
997.70
172.31
164,964.95
44
1,170.01
996.66
173.35
164,791.61
45
1,170.01
995.62
174.39
164,617.21
46
1,170.01
994.56
175.45
164,441.76
47
1,170.01
993.50
176.51
164,265.26
48
1,170.01
992.44
177.57
164,087.68
49
1,170.01
991.36
178.65
163,909.04
50
1,170.01
990.28
179.73
163,729.31
51
1,170.01
989.20
180.81
163,548.50
52
1,170.01
988.11
181.90
163,366.59
53
1,170.01
987.01
183.00
163,183.59
54
1,170.01
985.90
184.11
162,999.48
55
1,170.01
984.79
185.22
162,814.26
56
1,170.01
983.67
186.34
162,627.92
57
1,170.01
982.54
187.47
162,440.45
58
1,170.01
981.41
188.60
162,251.85
59
1,170.01
980.27
189.74
162,062.11
60
1,170.01
979.13
190.88
161,871.23
61
1,170.01
977.97
192.04
161,679.19
62
1,170.01
976.81
193.20
161,485.99
63
1,170.01
975.64
194.37
161,291.63
64
1,170.01
974.47
195.54
161,096.09
65
1,170.01
973.29
196.72
160,899.37
66
1,170.01
972.10
197.91
160,701.46
67
1,170.01
970.90
199.11
160,502.35
68
1,170.01
969.70
200.31
160,302.04
69
1,170.01
968.49
201.52
160,100.53
70
1,170.01
967.27
202.74
159,897.79
71
1,170.01
966.05
203.96
159,693.83
72
1,170.01
964.82
205.19
159,488.64
73
1,170.01
963.58
206.43
159,282.20
74
1,170.01
962.33
207.68
159,074.52
75
1,170.01
961.08
208.93
158,865.59
76
1,170.01
959.81
210.20
158,655.39
77
1,170.01
958.54
211.47
158,443.92
78
1,170.01
957.27
212.74
158,231.18
79
1,170.01
955.98
214.03
158,017.15
80
1,170.01
954.69
215.32
157,801.83
81
1,170.01
953.39
216.62
157,585.20
82
1,170.01
952.08
217.93
157,367.27
83
1,170.01
950.76
219.25
157,148.02
84
1,170.01
949.44
220.57
156,927.45
85
1,170.01
948.10
221.91
156,705.54
86
1,170.01
946.76
223.25
156,482.29
87
1,170.01
945.41
224.60
156,257.70
88
1,170.01
944.06
225.95
156,031.74
89
1,170.01
942.69
227.32
155,804.42
90
1,170.01
941.32
228.69
155,575.73
91
1,170.01
939.94
230.07
155,345.66
92
1,170.01
938.55
231.46
155,114.20
93
1,170.01
937.15
232.86
154,881.33
94
1,170.01
935.74
234.27
154,647.07
95
1,170.01
934.33
235.68
154,411.38
96
1,170.01
932.90
237.11
154,174.27
97
1,170.01
931.47
238.54
153,935.73
98
1,170.01
930.03
239.98
153,695.75
99
1,170.01
928.58
241.43
153,454.32
100
1,170.01
927.12
242.89
153,211.43
101
1,170.01
925.65
244.36
152,967.07
102
1,170.01
924.18
245.83
152,721.24
103
1,170.01
922.69
247.32
152,473.92
104
1,170.01
921.20
248.81
152,225.11
105
1,170.01
919.69
250.32
151,974.79
106
1,170.01
918.18
251.83
151,722.96
107
1,170.01
916.66
253.35
151,469.61
108
1,170.01
915.13
254.88
151,214.73
109
1,170.01
913.59
256.42
150,958.31
110
1,170.01
912.04
257.97
150,700.34
111
1,170.01
910.48
259.53
150,440.81
112
1,170.01
908.91
261.10
150,179.71
113
1,170.01
907.34
262.67
149,917.04
114
1,170.01
905.75
264.26
149,652.78
115
1,170.01
904.15
265.86
149,386.92
116
1,170.01
902.55
267.46
149,119.45
117
1,170.01
900.93
269.08
148,850.37
118
1,170.01
899.30
270.71
148,579.67
119
1,170.01
897.67
272.34
148,307.33
120
1,170.01
896.02
273.99
148,033.34
121
1,170.01
894.37
275.64
147,757.70
122
1,170.01
892.70
277.31
147,480.39
123
1,170.01
891.03
278.98
147,201.41
124
1,170.01
889.34
280.67
146,920.74
125
1,170.01
887.65
282.36
146,638.38
126
1,170.01
885.94
284.07
146,354.31
127
1,170.01
884.22
285.79
146,068.52
128
1,170.01
882.50
287.51
145,781.01
129
1,170.01
880.76
289.25
145,491.76
130
1,170.01
879.01
291.00
145,200.76
131
1,170.01
877.25
292.76
144,908.01
132
1,170.01
875.49
294.52
144,613.48
133
1,170.01
873.71
296.30
144,317.18
134
1,170.01
871.92
298.09
144,019.09
135
1,170.01
870.12
299.89
143,719.19
136
1,170.01
868.30
301.71
143,417.48
137
1,170.01
866.48
303.53
143,113.95
138
1,170.01
864.65
305.36
142,808.59
139
1,170.01
862.80
307.21
142,501.38
140
1,170.01
860.95
309.06
142,192.32
141
1,170.01
859.08
310.93
141,881.39
142
1,170.01
857.20
312.81
141,568.58
143
1,170.01
855.31
314.70
141,253.88
144
1,170.01
853.41
316.60
140,937.28
145
1,170.01
851.50
318.51
140,618.76
146
1,170.01
849.57
320.44
140,298.32
147
1,170.01
847.64
322.37
139,975.95
148
1,170.01
845.69
324.32
139,651.63
149
1,170.01
843.73
326.28
139,325.35
150
1,170.01
841.76
328.25
138,997.09
151
1,170.01
839.77
330.24
138,666.86
152
1,170.01
837.78
332.23
138,334.63
153
1,170.01
835.77
334.24
138,000.39
154
1,170.01
833.75
336.26
137,664.13
155
1,170.01
831.72
338.29
137,325.84
156
1,170.01
829.68
340.33
136,985.51
157
1,170.01
827.62
342.39
136,643.12
158
1,170.01
825.55
344.46
136,298.66
159
1,170.01
823.47
346.54
135,952.12
160
1,170.01
821.38
348.63
135,603.49
161
1,170.01
819.27
350.74
135,252.75
162
1,170.01
817.15
352.86
134,899.89
163
1,170.01
815.02
354.99
134,544.90
164
1,170.01
812.88
357.13
134,187.77
165
1,170.01
810.72
359.29
133,828.48
166
1,170.01
808.55
361.46
133,467.01
167
1,170.01
806.36
363.65
133,103.37
168
1,170.01
804.17
365.84
132,737.52
169
1,170.01
801.96
368.05
132,369.47
170
1,170.01
799.73
370.28
131,999.19
171
1,170.01
797.50
372.51
131,626.68
172
1,170.01
795.24
374.77
131,251.91
173
1,170.01
792.98
377.03
130,874.88
174
1,170.01
790.70
379.31
130,495.57
175
1,170.01
788.41
381.60
130,113.97
176
1,170.01
786.11
383.90
129,730.07
177
1,170.01
783.79
386.22
129,343.85
178
1,170.01
781.45
388.56
128,955.29
179
1,170.01
779.10
390.91
128,564.38
180
1,170.01
776.74
393.27
128,171.12
181
1,170.01
774.37
395.64
127,775.47
182
1,170.01
771.98
398.03
127,377.44
183
1,170.01
769.57
400.44
126,977.00
184
1,170.01
767.15
402.86
126,574.15
185
1,170.01
764.72
405.29
126,168.85
186
1,170.01
762.27
407.74
125,761.11
187
1,170.01
759.81
410.20
125,350.91
188
1,170.01
757.33
412.68
124,938.23
189
1,170.01
754.84
415.17
124,523.05
190
1,170.01
752.33
417.68
124,105.37
191
1,170.01
749.80
420.21
123,685.16
192
1,170.01
747.26
422.75
123,262.42
193
1,170.01
744.71
425.30
122,837.12
194
1,170.01
742.14
427.87
122,409.25
195
1,170.01
739.56
430.45
121,978.80
196
1,170.01
736.96
433.05
121,545.74
197
1,170.01
734.34
435.67
121,110.07
198
1,170.01
731.71
438.30
120,671.77
199
1,170.01
729.06
440.95
120,230.82
200
1,170.01
726.39
443.62
119,787.20
201
1,170.01
723.71
446.30
119,340.90
202
1,170.01
721.02
448.99
118,891.91
203
1,170.01
718.31
451.70
118,440.21
204
1,170.01
715.58
454.43
117,985.77
205
1,170.01
712.83
457.18
117,528.59
206
1,170.01
710.07
459.94
117,068.65
207
1,170.01
707.29
462.72
116,605.93
208
1,170.01
704.49
465.52
116,140.42
209
1,170.01
701.68
468.33
115,672.09
210
1,170.01
698.85
471.16
115,200.93
211
1,170.01
696.01
474.00
114,726.93
212
1,170.01
693.14
476.87
114,250.06
213
1,170.01
690.26
479.75
113,770.31
214
1,170.01
687.36
482.65
113,287.66
215
1,170.01
684.45
485.56
112,802.10
216
1,170.01
681.51
488.50
112,313.60
217
1,170.01
678.56
491.45
111,822.15
218
1,170.01
675.59
494.42
111,327.73
219
1,170.01
672.61
497.40
110,830.33
220
1,170.01
669.60
500.41
110,329.92
221
1,170.01
666.58
503.43
109,826.49
222
1,170.01
663.54
506.47
109,320.01
223
1,170.01
660.48
509.53
108,810.48
224
1,170.01
657.40
512.61
108,297.86
225
1,170.01
654.30
515.71
107,782.15
226
1,170.01
651.18
518.83
107,263.33
227
1,170.01
648.05
521.96
106,741.37
228
1,170.01
644.90
525.11
106,216.25
229
1,170.01
641.72
528.29
105,687.96
230
1,170.01
638.53
531.48
105,156.49
231
1,170.01
635.32
534.69
104,621.80
232
1,170.01
632.09
537.92
104,083.88
233
1,170.01
628.84
541.17
103,542.71
234
1,170.01
625.57
544.44
102,998.27
235
1,170.01
622.28
547.73
102,450.54
236
1,170.01
618.97
551.04
101,899.50
237
1,170.01
615.64
554.37
101,345.13
238
1,170.01
612.29
557.72
100,787.42
239
1,170.01
608.92
561.09
100,226.33
240
1,170.01
605.53
564.48
99,661.85
241
1,170.01
602.12
567.89
99,093.97
242
1,170.01
598.69
571.32
98,522.65
243
1,170.01
595.24
574.77
97,947.88
244
1,170.01
591.77
578.24
97,369.64
245
1,170.01
588.27
581.74
96,787.90
246
1,170.01
584.76
585.25
96,202.66
247
1,170.01
581.22
588.79
95,613.87
248
1,170.01
577.67
592.34
95,021.53
249
1,170.01
574.09
595.92
94,425.61
250
1,170.01
570.49
599.52
93,826.08
251
1,170.01
566.87
603.14
93,222.94
252
1,170.01
563.22
606.79
92,616.15
253
1,170.01
559.56
610.45
92,005.70
254
1,170.01
555.87
614.14
91,391.55
255
1,170.01
552.16
617.85
90,773.70
256
1,170.01
548.42
621.59
90,152.12
257
1,170.01
544.67
625.34
89,526.78
258
1,170.01
540.89
629.12
88,897.66
259
1,170.01
537.09
632.92
88,264.74
260
1,170.01
533.27
636.74
87,627.99
261
1,170.01
529.42
640.59
86,987.40
262
1,170.01
525.55
644.46
86,342.94
263
1,170.01
521.66
648.35
85,694.59
264
1,170.01
517.74
652.27
85,042.31
265
1,170.01
513.80
656.21
84,386.10
266
1,170.01
509.83
660.18
83,725.92
267
1,170.01
505.84
664.17
83,061.76
268
1,170.01
501.83
668.18
82,393.58
269
1,170.01
497.79
672.22
81,721.36
270
1,170.01
493.73
676.28
81,045.09
271
1,170.01
489.65
680.36
80,364.72
272
1,170.01
485.54
684.47
79,680.25
273
1,170.01
481.40
688.61
78,991.64
274
1,170.01
477.24
692.77
78,298.87
275
1,170.01
473.06
696.95
77,601.92
276
1,170.01
468.84
701.17
76,900.75
277
1,170.01
464.61
705.40
76,195.35
278
1,170.01
460.35
709.66
75,485.69
279
1,170.01
456.06
713.95
74,771.74
280
1,170.01
451.75
718.26
74,053.48
281
1,170.01
447.41
722.60
73,330.87
282
1,170.01
443.04
726.97
72,603.90
283
1,170.01
438.65
731.36
71,872.54
284
1,170.01
434.23
735.78
71,136.76
285
1,170.01
429.78
740.23
70,396.54
286
1,170.01
425.31
744.70
69,651.84
287
1,170.01
420.81
749.20
68,902.64
288
1,170.01
416.29
753.72
68,148.92
289
1,170.01
411.73
758.28
67,390.64
290
1,170.01
407.15
762.86
66,627.78
291
1,170.01
402.54
767.47
65,860.32
292
1,170.01
397.91
772.10
65,088.21
293
1,170.01
393.24
776.77
64,311.44
294
1,170.01
388.55
781.46
63,529.98
295
1,170.01
383.83
786.18
62,743.80
296
1,170.01
379.08
790.93
61,952.87
297
1,170.01
374.30
795.71
61,157.15
298
1,170.01
369.49
800.52
60,356.64
299
1,170.01
364.65
805.36
59,551.28
300
1,170.01
359.79
810.22
58,741.06
301
1,170.01
354.89
815.12
57,925.94
302
1,170.01
349.97
820.04
57,105.90
303
1,170.01
345.01
825.00
56,280.91
304
1,170.01
340.03
829.98
55,450.93
305
1,170.01
335.02
834.99
54,615.93
306
1,170.01
329.97
840.04
53,775.90
307
1,170.01
324.90
845.11
52,930.78
308
1,170.01
319.79
850.22
52,080.56
309
1,170.01
314.65
855.36
51,225.20
310
1,170.01
309.49
860.52
50,364.68
311
1,170.01
304.29
865.72
49,498.96
312
1,170.01
299.06
870.95
48,628.00
313
1,170.01
293.79
876.22
47,751.79
314
1,170.01
288.50
881.51
46,870.28
315
1,170.01
283.17
886.84
45,983.44
316
1,170.01
277.82
892.19
45,091.25
317
1,170.01
272.43
897.58
44,193.67
318
1,170.01
267.00
903.01
43,290.66
319
1,170.01
261.55
908.46
42,382.20
320
1,170.01
256.06
913.95
41,468.25
321
1,170.01
250.54
919.47
40,548.77
322
1,170.01
244.98
925.03
39,623.74
323
1,170.01
239.39
930.62
38,693.13
324
1,170.01
233.77
936.24
37,756.89
325
1,170.01
228.11
941.90
36,814.99
326
1,170.01
222.42
947.59
35,867.41
327
1,170.01
216.70
953.31
34,914.10
328
1,170.01
210.94
959.07
33,955.03
329
1,170.01
205.14
964.87
32,990.16
330
1,170.01
199.32
970.69
32,019.47
331
1,170.01
193.45
976.56
31,042.91
332
1,170.01
187.55
982.46
30,060.45
333
1,170.01
181.62
988.39
29,072.05
334
1,170.01
175.64
994.37
28,077.69
335
1,170.01
169.64
1,000.37
27,077.31
336
1,170.01
163.59
1,006.42
26,070.90
337
1,170.01
157.51
1,012.50
25,058.40
338
1,170.01
151.39
1,018.62
24,039.78
339
1,170.01
145.24
1,024.77
23,015.01
340
1,170.01
139.05
1,030.96
21,984.05
341
1,170.01
132.82
1,037.19
20,946.86
342
1,170.01
126.55
1,043.46
19,903.41
343
1,170.01
120.25
1,049.76
18,853.64
344
1,170.01
113.91
1,056.10
17,797.54
345
1,170.01
107.53
1,062.48
16,735.06
346
1,170.01
101.11
1,068.90
15,666.16
347
1,170.01
94.65
1,075.36
14,590.80
348
1,170.01
88.15
1,081.86
13,508.94
349
1,170.01
81.62
1,088.39
12,420.55
350
1,170.01
75.04
1,094.97
11,325.58
351
1,170.01
68.43
1,101.58
10,223.99
352
1,170.01
61.77
1,108.24
9,115.75
353
1,170.01
55.07
1,114.94
8,000.82
354
1,170.01
48.34
1,121.67
6,879.14
355
1,170.01
41.56
1,128.45
5,750.70
356
1,170.01
34.74
1,135.27
4,615.43
357
1,170.01
27.88
1,142.13
3,473.30
358
1,170.01
20.98
1,149.03
2,324.28
359
1,170.01
14.04
1,155.97
1,168.31
360
1,175.37
7.06
1,168.31
0.00
Totals
421,208.96
249,696.96
171,512.00

© 2023 TANYA KULAGA, REALTOR, CRS, ABR, GRI|REALTY EXECUTIVES — HEDGES REAL ESTATE|1037 VERMONT ST, LAWRENCE, KS 66044