F

Amortization Schedule Calculator

Amortization Schedule Calculator builds a month-by-month table of principal, interest, and remaining balance, with CSV download for spreadsheets.

Loan details

Monthly payment

$1,580.17

$318,861.22

Total interest

$568,861.22

Total paid

360

Payments

Amortization schedule

MonthPaymentPrincipalInterestBalance
1$1,580.17$226.00$1,354.17$249,774.00
2$1,580.17$227.23$1,352.94$249,546.77
3$1,580.17$228.46$1,351.71$249,318.31
4$1,580.17$229.70$1,350.47$249,088.61
5$1,580.17$230.94$1,349.23$248,857.67
6$1,580.17$232.19$1,347.98$248,625.48
7$1,580.17$233.45$1,346.72$248,392.04
8$1,580.17$234.71$1,345.46$248,157.32
9$1,580.17$235.98$1,344.19$247,921.34
10$1,580.17$237.26$1,342.91$247,684.07
11$1,580.17$238.55$1,341.62$247,445.53
12$1,580.17$239.84$1,340.33$247,205.69
13$1,580.17$241.14$1,339.03$246,964.55
14$1,580.17$242.45$1,337.72$246,722.10
15$1,580.17$243.76$1,336.41$246,478.34
16$1,580.17$245.08$1,335.09$246,233.26
17$1,580.17$246.41$1,333.76$245,986.86
18$1,580.17$247.74$1,332.43$245,739.12
19$1,580.17$249.08$1,331.09$245,490.03
20$1,580.17$250.43$1,329.74$245,239.60
21$1,580.17$251.79$1,328.38$244,987.81
22$1,580.17$253.15$1,327.02$244,734.66
23$1,580.17$254.52$1,325.65$244,480.13
24$1,580.17$255.90$1,324.27$244,224.23
25$1,580.17$257.29$1,322.88$243,966.94
26$1,580.17$258.68$1,321.49$243,708.26
27$1,580.17$260.08$1,320.09$243,448.18
28$1,580.17$261.49$1,318.68$243,186.68
29$1,580.17$262.91$1,317.26$242,923.78
30$1,580.17$264.33$1,315.84$242,659.44
31$1,580.17$265.76$1,314.41$242,393.68
32$1,580.17$267.20$1,312.97$242,126.47
33$1,580.17$268.65$1,311.52$241,857.82
34$1,580.17$270.11$1,310.06$241,587.72
35$1,580.17$271.57$1,308.60$241,316.15
36$1,580.17$273.04$1,307.13$241,043.10
37$1,580.17$274.52$1,305.65$240,768.58
38$1,580.17$276.01$1,304.16$240,492.58
39$1,580.17$277.50$1,302.67$240,215.08
40$1,580.17$279.01$1,301.16$239,936.07
41$1,580.17$280.52$1,299.65$239,655.55
42$1,580.17$282.04$1,298.13$239,373.52
43$1,580.17$283.56$1,296.61$239,089.96
44$1,580.17$285.10$1,295.07$238,804.86
45$1,580.17$286.64$1,293.53$238,518.21
46$1,580.17$288.20$1,291.97$238,230.02
47$1,580.17$289.76$1,290.41$237,940.26
48$1,580.17$291.33$1,288.84$237,648.93
49$1,580.17$292.91$1,287.27$237,356.03
50$1,580.17$294.49$1,285.68$237,061.53
51$1,580.17$296.09$1,284.08$236,765.45
52$1,580.17$297.69$1,282.48$236,467.76
53$1,580.17$299.30$1,280.87$236,168.45
54$1,580.17$300.92$1,279.25$235,867.53
55$1,580.17$302.55$1,277.62$235,564.98
56$1,580.17$304.19$1,275.98$235,260.78
57$1,580.17$305.84$1,274.33$234,954.94
58$1,580.17$307.50$1,272.67$234,647.44
59$1,580.17$309.16$1,271.01$234,338.28
60$1,580.17$310.84$1,269.33$234,027.44
61$1,580.17$312.52$1,267.65$233,714.92
62$1,580.17$314.21$1,265.96$233,400.71
63$1,580.17$315.92$1,264.25$233,084.79
64$1,580.17$317.63$1,262.54$232,767.16
65$1,580.17$319.35$1,260.82$232,447.82
66$1,580.17$321.08$1,259.09$232,126.74
67$1,580.17$322.82$1,257.35$231,803.92
68$1,580.17$324.57$1,255.60$231,479.36
69$1,580.17$326.32$1,253.85$231,153.03
70$1,580.17$328.09$1,252.08$230,824.94
71$1,580.17$329.87$1,250.30$230,495.07
72$1,580.17$331.66$1,248.51$230,163.42
73$1,580.17$333.45$1,246.72$229,829.97
74$1,580.17$335.26$1,244.91$229,494.71
75$1,580.17$337.07$1,243.10$229,157.64
76$1,580.17$338.90$1,241.27$228,818.74
77$1,580.17$340.74$1,239.43$228,478.00
78$1,580.17$342.58$1,237.59$228,135.42
79$1,580.17$344.44$1,235.73$227,790.98
80$1,580.17$346.30$1,233.87$227,444.68
81$1,580.17$348.18$1,231.99$227,096.50
82$1,580.17$350.06$1,230.11$226,746.44
83$1,580.17$351.96$1,228.21$226,394.48
84$1,580.17$353.87$1,226.30$226,040.61
85$1,580.17$355.78$1,224.39$225,684.83
86$1,580.17$357.71$1,222.46$225,327.12
87$1,580.17$359.65$1,220.52$224,967.47
88$1,580.17$361.60$1,218.57$224,605.87
89$1,580.17$363.55$1,216.62$224,242.32
90$1,580.17$365.52$1,214.65$223,876.79
91$1,580.17$367.50$1,212.67$223,509.29
92$1,580.17$369.49$1,210.68$223,139.80
93$1,580.17$371.50$1,208.67$222,768.30
94$1,580.17$373.51$1,206.66$222,394.79
95$1,580.17$375.53$1,204.64$222,019.26
96$1,580.17$377.57$1,202.60$221,641.69
97$1,580.17$379.61$1,200.56$221,262.08
98$1,580.17$381.67$1,198.50$220,880.42
99$1,580.17$383.73$1,196.44$220,496.68
100$1,580.17$385.81$1,194.36$220,110.87
101$1,580.17$387.90$1,192.27$219,722.97
102$1,580.17$390.00$1,190.17$219,332.96
103$1,580.17$392.12$1,188.05$218,940.84
104$1,580.17$394.24$1,185.93$218,546.60
105$1,580.17$396.38$1,183.79$218,150.23
106$1,580.17$398.52$1,181.65$217,751.71
107$1,580.17$400.68$1,179.49$217,351.02
108$1,580.17$402.85$1,177.32$216,948.17
109$1,580.17$405.03$1,175.14$216,543.14
110$1,580.17$407.23$1,172.94$216,135.91
111$1,580.17$409.43$1,170.74$215,726.48
112$1,580.17$411.65$1,168.52$215,314.82
113$1,580.17$413.88$1,166.29$214,900.94
114$1,580.17$416.12$1,164.05$214,484.82
115$1,580.17$418.38$1,161.79$214,066.44
116$1,580.17$420.64$1,159.53$213,645.80
117$1,580.17$422.92$1,157.25$213,222.88
118$1,580.17$425.21$1,154.96$212,797.66
119$1,580.17$427.52$1,152.65$212,370.15
120$1,580.17$429.83$1,150.34$211,940.32
121$1,580.17$432.16$1,148.01$211,508.16
122$1,580.17$434.50$1,145.67$211,073.66
123$1,580.17$436.85$1,143.32$210,636.80
124$1,580.17$439.22$1,140.95$210,197.58
125$1,580.17$441.60$1,138.57$209,755.98
126$1,580.17$443.99$1,136.18$209,311.99
127$1,580.17$446.40$1,133.77$208,865.59
128$1,580.17$448.81$1,131.36$208,416.78
129$1,580.17$451.25$1,128.92$207,965.53
130$1,580.17$453.69$1,126.48$207,511.84
131$1,580.17$456.15$1,124.02$207,055.69
132$1,580.17$458.62$1,121.55$206,597.07
133$1,580.17$461.10$1,119.07$206,135.97
134$1,580.17$463.60$1,116.57$205,672.37
135$1,580.17$466.11$1,114.06$205,206.26
136$1,580.17$468.64$1,111.53$204,737.62
137$1,580.17$471.17$1,109.00$204,266.45
138$1,580.17$473.73$1,106.44$203,792.72
139$1,580.17$476.29$1,103.88$203,316.43
140$1,580.17$478.87$1,101.30$202,837.56
141$1,580.17$481.47$1,098.70$202,356.09
142$1,580.17$484.07$1,096.10$201,872.02
143$1,580.17$486.70$1,093.47$201,385.32
144$1,580.17$489.33$1,090.84$200,895.99
145$1,580.17$491.98$1,088.19$200,404.00
146$1,580.17$494.65$1,085.52$199,909.35
147$1,580.17$497.33$1,082.84$199,412.03
148$1,580.17$500.02$1,080.15$198,912.01
149$1,580.17$502.73$1,077.44$198,409.28
150$1,580.17$505.45$1,074.72$197,903.82
151$1,580.17$508.19$1,071.98$197,395.63
152$1,580.17$510.94$1,069.23$196,884.69
153$1,580.17$513.71$1,066.46$196,370.98
154$1,580.17$516.49$1,063.68$195,854.48
155$1,580.17$519.29$1,060.88$195,335.19
156$1,580.17$522.10$1,058.07$194,813.09
157$1,580.17$524.93$1,055.24$194,288.15
158$1,580.17$527.78$1,052.39$193,760.38
159$1,580.17$530.63$1,049.54$193,229.74
160$1,580.17$533.51$1,046.66$192,696.23
161$1,580.17$536.40$1,043.77$192,159.84
162$1,580.17$539.30$1,040.87$191,620.53
163$1,580.17$542.23$1,037.94$191,078.31
164$1,580.17$545.16$1,035.01$190,533.14
165$1,580.17$548.12$1,032.05$189,985.03
166$1,580.17$551.08$1,029.09$189,433.94
167$1,580.17$554.07$1,026.10$188,879.87
168$1,580.17$557.07$1,023.10$188,322.80
169$1,580.17$560.09$1,020.08$187,762.71
170$1,580.17$563.12$1,017.05$187,199.59
171$1,580.17$566.17$1,014.00$186,633.42
172$1,580.17$569.24$1,010.93$186,064.18
173$1,580.17$572.32$1,007.85$185,491.86
174$1,580.17$575.42$1,004.75$184,916.44
175$1,580.17$578.54$1,001.63$184,337.90
176$1,580.17$581.67$998.50$183,756.22
177$1,580.17$584.82$995.35$183,171.40
178$1,580.17$587.99$992.18$182,583.41
179$1,580.17$591.18$988.99$181,992.23
180$1,580.17$594.38$985.79$181,397.85
181$1,580.17$597.60$982.57$180,800.25
182$1,580.17$600.84$979.33$180,199.42
183$1,580.17$604.09$976.08$179,595.33
184$1,580.17$607.36$972.81$178,987.97
185$1,580.17$610.65$969.52$178,377.32
186$1,580.17$613.96$966.21$177,763.36
187$1,580.17$617.29$962.88$177,146.07
188$1,580.17$620.63$959.54$176,525.44
189$1,580.17$623.99$956.18$175,901.45
190$1,580.17$627.37$952.80$175,274.08
191$1,580.17$630.77$949.40$174,643.31
192$1,580.17$634.19$945.98$174,009.13
193$1,580.17$637.62$942.55$173,371.51
194$1,580.17$641.07$939.10$172,730.43
195$1,580.17$644.55$935.62$172,085.88
196$1,580.17$648.04$932.13$171,437.85
197$1,580.17$651.55$928.62$170,786.30
198$1,580.17$655.08$925.09$170,131.22
199$1,580.17$658.63$921.54$169,472.59
200$1,580.17$662.19$917.98$168,810.40
201$1,580.17$665.78$914.39$168,144.62
202$1,580.17$669.39$910.78$167,475.23
203$1,580.17$673.01$907.16$166,802.22
204$1,580.17$676.66$903.51$166,125.56
205$1,580.17$680.32$899.85$165,445.24
206$1,580.17$684.01$896.16$164,761.23
207$1,580.17$687.71$892.46$164,073.52
208$1,580.17$691.44$888.73$163,382.08
209$1,580.17$695.18$884.99$162,686.90
210$1,580.17$698.95$881.22$161,987.95
211$1,580.17$702.74$877.43$161,285.21
212$1,580.17$706.54$873.63$160,578.67
213$1,580.17$710.37$869.80$159,868.30
214$1,580.17$714.22$865.95$159,154.08
215$1,580.17$718.09$862.08$158,436.00
216$1,580.17$721.98$858.19$157,714.02
217$1,580.17$725.89$854.28$156,988.14
218$1,580.17$729.82$850.35$156,258.32
219$1,580.17$733.77$846.40$155,524.55
220$1,580.17$737.75$842.42$154,786.80
221$1,580.17$741.74$838.43$154,045.06
222$1,580.17$745.76$834.41$153,299.30
223$1,580.17$749.80$830.37$152,549.50
224$1,580.17$753.86$826.31$151,795.64
225$1,580.17$757.94$822.23$151,037.70
226$1,580.17$762.05$818.12$150,275.65
227$1,580.17$766.18$813.99$149,509.47
228$1,580.17$770.33$809.84$148,739.15
229$1,580.17$774.50$805.67$147,964.65
230$1,580.17$778.69$801.48$147,185.95
231$1,580.17$782.91$797.26$146,403.04
232$1,580.17$787.15$793.02$145,615.89
233$1,580.17$791.42$788.75$144,824.47
234$1,580.17$795.70$784.47$144,028.76
235$1,580.17$800.01$780.16$143,228.75
236$1,580.17$804.35$775.82$142,424.40
237$1,580.17$808.70$771.47$141,615.70
238$1,580.17$813.09$767.09$140,802.61
239$1,580.17$817.49$762.68$139,985.12
240$1,580.17$821.92$758.25$139,163.21
241$1,580.17$826.37$753.80$138,336.84
242$1,580.17$830.85$749.32$137,505.99
243$1,580.17$835.35$744.82$136,670.65
244$1,580.17$839.87$740.30$135,830.77
245$1,580.17$844.42$735.75$134,986.35
246$1,580.17$848.99$731.18$134,137.36
247$1,580.17$853.59$726.58$133,283.77
248$1,580.17$858.22$721.95$132,425.55
249$1,580.17$862.86$717.31$131,562.69
250$1,580.17$867.54$712.63$130,695.15
251$1,580.17$872.24$707.93$129,822.91
252$1,580.17$876.96$703.21$128,945.95
253$1,580.17$881.71$698.46$128,064.23
254$1,580.17$886.49$693.68$127,177.75
255$1,580.17$891.29$688.88$126,286.46
256$1,580.17$896.12$684.05$125,390.34
257$1,580.17$900.97$679.20$124,489.36
258$1,580.17$905.85$674.32$123,583.51
259$1,580.17$910.76$669.41$122,672.75
260$1,580.17$915.69$664.48$121,757.06
261$1,580.17$920.65$659.52$120,836.41
262$1,580.17$925.64$654.53$119,910.77
263$1,580.17$930.65$649.52$118,980.11
264$1,580.17$935.69$644.48$118,044.42
265$1,580.17$940.76$639.41$117,103.66
266$1,580.17$945.86$634.31$116,157.80
267$1,580.17$950.98$629.19$115,206.82
268$1,580.17$956.13$624.04$114,250.68
269$1,580.17$961.31$618.86$113,289.37
270$1,580.17$966.52$613.65$112,322.85
271$1,580.17$971.75$608.42$111,351.10
272$1,580.17$977.02$603.15$110,374.08
273$1,580.17$982.31$597.86$109,391.77
274$1,580.17$987.63$592.54$108,404.14
275$1,580.17$992.98$587.19$107,411.16
276$1,580.17$998.36$581.81$106,412.80
277$1,580.17$1,003.77$576.40$105,409.03
278$1,580.17$1,009.20$570.97$104,399.82
279$1,580.17$1,014.67$565.50$103,385.15
280$1,580.17$1,020.17$560.00$102,364.99
281$1,580.17$1,025.69$554.48$101,339.29
282$1,580.17$1,031.25$548.92$100,308.04
283$1,580.17$1,036.83$543.34$99,271.21
284$1,580.17$1,042.45$537.72$98,228.76
285$1,580.17$1,048.10$532.07$97,180.66
286$1,580.17$1,053.77$526.40$96,126.89
287$1,580.17$1,059.48$520.69$95,067.40
288$1,580.17$1,065.22$514.95$94,002.18
289$1,580.17$1,070.99$509.18$92,931.19
290$1,580.17$1,076.79$503.38$91,854.40
291$1,580.17$1,082.63$497.54$90,771.77
292$1,580.17$1,088.49$491.68$89,683.28
293$1,580.17$1,094.39$485.78$88,588.90
294$1,580.17$1,100.31$479.86$87,488.58
295$1,580.17$1,106.27$473.90$86,382.31
296$1,580.17$1,112.27$467.90$85,270.04
297$1,580.17$1,118.29$461.88$84,151.75
298$1,580.17$1,124.35$455.82$83,027.40
299$1,580.17$1,130.44$449.73$81,896.97
300$1,580.17$1,136.56$443.61$80,760.41
301$1,580.17$1,142.72$437.45$79,617.69
302$1,580.17$1,148.91$431.26$78,468.78
303$1,580.17$1,155.13$425.04$77,313.65
304$1,580.17$1,161.39$418.78$76,152.26
305$1,580.17$1,167.68$412.49$74,984.58
306$1,580.17$1,174.00$406.17$73,810.58
307$1,580.17$1,180.36$399.81$72,630.22
308$1,580.17$1,186.76$393.41$71,443.46
309$1,580.17$1,193.18$386.99$70,250.28
310$1,580.17$1,199.65$380.52$69,050.63
311$1,580.17$1,206.15$374.02$67,844.48
312$1,580.17$1,212.68$367.49$66,631.80
313$1,580.17$1,219.25$360.92$65,412.55
314$1,580.17$1,225.85$354.32$64,186.70
315$1,580.17$1,232.49$347.68$62,954.21
316$1,580.17$1,239.17$341.00$61,715.04
317$1,580.17$1,245.88$334.29$60,469.16
318$1,580.17$1,252.63$327.54$59,216.53
319$1,580.17$1,259.41$320.76$57,957.12
320$1,580.17$1,266.24$313.93$56,690.88
321$1,580.17$1,273.09$307.08$55,417.79
322$1,580.17$1,279.99$300.18$54,137.80
323$1,580.17$1,286.92$293.25$52,850.88
324$1,580.17$1,293.89$286.28$51,556.98
325$1,580.17$1,300.90$279.27$50,256.08
326$1,580.17$1,307.95$272.22$48,948.13
327$1,580.17$1,315.03$265.14$47,633.09
328$1,580.17$1,322.16$258.01$46,310.94
329$1,580.17$1,329.32$250.85$44,981.62
330$1,580.17$1,336.52$243.65$43,645.10
331$1,580.17$1,343.76$236.41$42,301.34
332$1,580.17$1,351.04$229.13$40,950.30
333$1,580.17$1,358.36$221.81$39,591.94
334$1,580.17$1,365.71$214.46$38,226.23
335$1,580.17$1,373.11$207.06$36,853.12
336$1,580.17$1,380.55$199.62$35,472.57
337$1,580.17$1,388.03$192.14$34,084.54
338$1,580.17$1,395.55$184.62$32,689.00
339$1,580.17$1,403.10$177.07$31,285.89
340$1,580.17$1,410.70$169.47$29,875.19
341$1,580.17$1,418.35$161.82$28,456.84
342$1,580.17$1,426.03$154.14$27,030.81
343$1,580.17$1,433.75$146.42$25,597.06
344$1,580.17$1,441.52$138.65$24,155.54
345$1,580.17$1,449.33$130.84$22,706.21
346$1,580.17$1,457.18$122.99$21,249.04
347$1,580.17$1,465.07$115.10$19,783.96
348$1,580.17$1,473.01$107.16$18,310.96
349$1,580.17$1,480.99$99.18$16,829.97
350$1,580.17$1,489.01$91.16$15,340.96
351$1,580.17$1,497.07$83.10$13,843.89
352$1,580.17$1,505.18$74.99$12,338.71
353$1,580.17$1,513.34$66.83$10,825.37
354$1,580.17$1,521.53$58.64$9,303.84
355$1,580.17$1,529.77$50.40$7,774.07
356$1,580.17$1,538.06$42.11$6,236.01
357$1,580.17$1,546.39$33.78$4,689.61
358$1,580.17$1,554.77$25.40$3,134.85
359$1,580.17$1,563.19$16.98$1,571.66
360$1,580.17$1,571.66$8.51$0.00

How to use Amortization Schedule Calculator

  1. Enter loan amount, rate, and term.
  2. Generate the amortization schedule.
  3. Download CSV if you want to analyze it in Excel or Sheets.

Worked examples

Concrete numbers and cases you can check against the tool above.

First months of a $250,000 30-year loan at 6%

Payment is about $1,499. Early months are interest-heavy: month 1 might apply ~$1,250 to interest and ~$249 to principal. By the last years that ratio flips. Export CSV if you want to chart remaining balance in a spreadsheet.

When to use Amortization Schedule Calculator

Month-by-month principal and interest tables explain how loans actually pay down. CSV export makes further analysis easy in Sheets or Excel.

Common use cases

  • Show a borrower how early payments skew to interest.
  • Export a schedule for tax or planning records.
  • Compare schedules after changing term length.
  • Teach amortization mechanics in a finance class.

Inputs and outputs

  • Loan inputs: amount, rate, term
  • Output: On-screen schedule and CSV download

Privacy

This tool runs entirely in your browser. Your data never leaves your device β€” nothing is uploaded to our servers.

Frequently asked questions

Why do early payments go mostly to interest?
That is normal amortization: interest is charged on the remaining balance, which is highest at the start.
Can I model extra payments?
If the tool includes extra-payment fields, enter them; otherwise the schedule reflects the standard payment only.
Is the CSV uploaded?
No. It is generated in your browser for download.

Related tools

More free utilities you may need next β€” also listed in Calculators & Converters and the All Tools directory.

View full category β†’