Generic Loan Amortization Schedule Calculator

Here is a version that writes the output to a PDF file for easier printing and saving.
This will work for any mortgage, car loan or any amortized loan over a fixed period of time.



Loan Amount
Annual Interest Rate
Payment Each Period ( to let calculate*)
Periods per Year (12 for monthly, 26 for bi-weekly, 52 for weekly, etc.)
Total Number of Payments OR Total Number of Years


Your interest rate per period is 0.5833 % for 120 total periods ( 10.0000 years)

PeriodYearsStart BalInterest PrincipalTot IntEnd Bal
1 0.083$ 100,000.00$ 583.34$ 577.75$ 583.34 $ 99,422.25
2 0.167$ 99,422.25$ 579.97$ 581.12$ 1,163.31 $ 98,841.13
3 0.250$ 98,841.13$ 576.58$ 584.51$ 1,739.89 $ 98,256.62
4 0.333$ 98,256.62$ 573.17$ 587.92$ 2,313.06 $ 97,668.70
5 0.417$ 97,668.70$ 569.74$ 591.35$ 2,882.80 $ 97,077.35
6 0.500$ 97,077.35$ 566.29$ 594.80$ 3,449.09 $ 96,482.55
7 0.583$ 96,482.55$ 562.82$ 598.27$ 4,011.91 $ 95,884.28
8 0.667$ 95,884.28$ 559.33$ 601.76$ 4,571.24 $ 95,282.52
9 0.750$ 95,282.52$ 555.82$ 605.27$ 5,127.06 $ 94,677.25
10 0.833$ 94,677.25$ 552.29$ 608.80$ 5,679.35 $ 94,068.45
11 0.917$ 94,068.45$ 548.74$ 612.35$ 6,228.09 $ 93,456.10
12 1.000$ 93,456.10$ 545.17$ 615.92$ 6,773.26 $ 92,840.18
13 1.083$ 92,840.18$ 541.57$ 619.52$ 7,314.83 $ 92,220.66
14 1.167$ 92,220.66$ 537.96$ 623.13$ 7,852.79 $ 91,597.53
15 1.250$ 91,597.53$ 534.32$ 626.77$ 8,387.11 $ 90,970.76
16 1.333$ 90,970.76$ 530.67$ 630.42$ 8,917.78 $ 90,340.34
17 1.417$ 90,340.34$ 526.99$ 634.10$ 9,444.77 $ 89,706.24
18 1.500$ 89,706.24$ 523.29$ 637.80$ 9,968.06 $ 89,068.44
19 1.583$ 89,068.44$ 519.57$ 641.52$ 10,487.63 $ 88,426.92
20 1.667$ 88,426.92$ 515.83$ 645.26$ 11,003.46 $ 87,781.66
21 1.750$ 87,781.66$ 512.06$ 649.03$ 11,515.52 $ 87,132.63
22 1.833$ 87,132.63$ 508.28$ 652.81$ 12,023.80 $ 86,479.82
23 1.917$ 86,479.82$ 504.47$ 656.62$ 12,528.27 $ 85,823.20
24 2.000$ 85,823.20$ 500.64$ 660.45$ 13,028.91 $ 85,162.75
25 2.083$ 85,162.75$ 496.79$ 664.30$ 13,525.70 $ 84,498.45
26 2.167$ 84,498.45$ 492.91$ 668.18$ 14,018.61 $ 83,830.27
27 2.250$ 83,830.27$ 489.01$ 672.08$ 14,507.62 $ 83,158.19
28 2.333$ 83,158.19$ 485.09$ 676.00$ 14,992.71 $ 82,482.19
29 2.417$ 82,482.19$ 481.15$ 679.94$ 15,473.86 $ 81,802.25
30 2.500$ 81,802.25$ 477.18$ 683.91$ 15,951.04 $ 81,118.34
31 2.583$ 81,118.34$ 473.20$ 687.89$ 16,424.24 $ 80,430.45
32 2.667$ 80,430.45$ 469.18$ 691.91$ 16,893.42 $ 79,738.54
33 2.750$ 79,738.54$ 465.15$ 695.94$ 17,358.57 $ 79,042.60
34 2.833$ 79,042.60$ 461.09$ 700.00$ 17,819.66 $ 78,342.60
35 2.917$ 78,342.60$ 457.00$ 704.09$ 18,276.66 $ 77,638.51
36 3.000$ 77,638.51$ 452.90$ 708.19$ 18,729.56 $ 76,930.32
37 3.083$ 76,930.32$ 448.77$ 712.32$ 19,178.33 $ 76,218.00
38 3.167$ 76,218.00$ 444.61$ 716.48$ 19,622.94 $ 75,501.52
39 3.250$ 75,501.52$ 440.43$ 720.66$ 20,063.37 $ 74,780.86
40 3.333$ 74,780.86$ 436.23$ 724.86$ 20,499.60 $ 74,056.00
41 3.417$ 74,056.00$ 432.00$ 729.09$ 20,931.60 $ 73,326.91
42 3.500$ 73,326.91$ 427.75$ 733.34$ 21,359.35 $ 72,593.57
43 3.583$ 72,593.57$ 423.47$ 737.62$ 21,782.82 $ 71,855.95
44 3.667$ 71,855.95$ 419.16$ 741.93$ 22,201.98 $ 71,114.02
45 3.750$ 71,114.02$ 414.84$ 746.25$ 22,616.82 $ 70,367.77
46 3.833$ 70,367.77$ 410.48$ 750.61$ 23,027.30 $ 69,617.16
47 3.917$ 69,617.16$ 406.11$ 754.98$ 23,433.41 $ 68,862.18
48 4.000$ 68,862.18$ 401.70$ 759.39$ 23,835.11 $ 68,102.79
49 4.083$ 68,102.79$ 397.27$ 763.82$ 24,232.38 $ 67,338.97
50 4.167$ 67,338.97$ 392.82$ 768.27$ 24,625.20 $ 66,570.70
51 4.250$ 66,570.70$ 388.33$ 772.76$ 25,013.53 $ 65,797.94
52 4.333$ 65,797.94$ 383.83$ 777.26$ 25,397.36 $ 65,020.68
53 4.417$ 65,020.68$ 379.29$ 781.80$ 25,776.65 $ 64,238.88
54 4.500$ 64,238.88$ 374.73$ 786.36$ 26,151.38 $ 63,452.52
55 4.583$ 63,452.52$ 370.14$ 790.95$ 26,521.52 $ 62,661.57
56 4.667$ 62,661.57$ 365.53$ 795.56$ 26,887.05 $ 61,866.01
57 4.750$ 61,866.01$ 360.89$ 800.20$ 27,247.94 $ 61,065.81
58 4.833$ 61,065.81$ 356.22$ 804.87$ 27,604.16 $ 60,260.94
59 4.917$ 60,260.94$ 351.53$ 809.56$ 27,955.69 $ 59,451.38
60 5.000$ 59,451.38$ 346.80$ 814.29$ 28,302.49 $ 58,637.09
61 5.083$ 58,637.09$ 342.05$ 819.04$ 28,644.54 $ 57,818.05
62 5.167$ 57,818.05$ 337.28$ 823.81$ 28,981.82 $ 56,994.24
63 5.250$ 56,994.24$ 332.47$ 828.62$ 29,314.29 $ 56,165.62
64 5.333$ 56,165.62$ 327.64$ 833.45$ 29,641.93 $ 55,332.17
65 5.417$ 55,332.17$ 322.78$ 838.31$ 29,964.71 $ 54,493.86
66 5.500$ 54,493.86$ 317.89$ 843.20$ 30,282.60 $ 53,650.66
67 5.583$ 53,650.66$ 312.97$ 848.12$ 30,595.57 $ 52,802.54
68 5.667$ 52,802.54$ 308.02$ 853.07$ 30,903.59 $ 51,949.47
69 5.750$ 51,949.47$ 303.04$ 858.05$ 31,206.63 $ 51,091.42
70 5.833$ 51,091.42$ 298.04$ 863.05$ 31,504.67 $ 50,228.37
71 5.917$ 50,228.37$ 293.00$ 868.09$ 31,797.67 $ 49,360.28
72 6.000$ 49,360.28$ 287.94$ 873.15$ 32,085.61 $ 48,487.13
73 6.083$ 48,487.13$ 282.85$ 878.24$ 32,368.46 $ 47,608.89
74 6.167$ 47,608.89$ 277.72$ 883.37$ 32,646.18 $ 46,725.52
75 6.250$ 46,725.52$ 272.57$ 888.52$ 32,918.75 $ 45,837.00
76 6.333$ 45,837.00$ 267.39$ 893.70$ 33,186.14 $ 44,943.30
77 6.417$ 44,943.30$ 262.17$ 898.92$ 33,448.31 $ 44,044.38
78 6.500$ 44,044.38$ 256.93$ 904.16$ 33,705.24 $ 43,140.22
79 6.583$ 43,140.22$ 251.66$ 909.43$ 33,956.90 $ 42,230.79
80 6.667$ 42,230.79$ 246.35$ 914.74$ 34,203.25 $ 41,316.05
81 6.750$ 41,316.05$ 241.02$ 920.07$ 34,444.27 $ 40,395.98
82 6.833$ 40,395.98$ 235.65$ 925.44$ 34,679.92 $ 39,470.54
83 6.917$ 39,470.54$ 230.25$ 930.84$ 34,910.17 $ 38,539.70
84 7.000$ 38,539.70$ 224.82$ 936.27$ 35,134.99 $ 37,603.43
85 7.083$ 37,603.43$ 219.36$ 941.73$ 35,354.35 $ 36,661.70
86 7.167$ 36,661.70$ 213.86$ 947.23$ 35,568.21 $ 35,714.47
87 7.250$ 35,714.47$ 208.34$ 952.75$ 35,776.55 $ 34,761.72
88 7.333$ 34,761.72$ 202.78$ 958.31$ 35,979.33 $ 33,803.41
89 7.417$ 33,803.41$ 197.19$ 963.90$ 36,176.52 $ 32,839.51
90 7.500$ 32,839.51$ 191.57$ 969.52$ 36,368.09 $ 31,869.99
91 7.583$ 31,869.99$ 185.91$ 975.18$ 36,554.00 $ 30,894.81
92 7.667$ 30,894.81$ 180.22$ 980.87$ 36,734.22 $ 29,913.94
93 7.750$ 29,913.94$ 174.50$ 986.59$ 36,908.72 $ 28,927.35
94 7.833$ 28,927.35$ 168.75$ 992.34$ 37,077.47 $ 27,935.01
95 7.917$ 27,935.01$ 162.96$ 998.13$ 37,240.43 $ 26,936.88
96 8.000$ 26,936.88$ 157.14$ 1,003.95$ 37,397.57 $ 25,932.93
97 8.083$ 25,932.93$ 151.28$ 1,009.81$ 37,548.85 $ 24,923.12
98 8.167$ 24,923.12$ 145.39$ 1,015.70$ 37,694.24 $ 23,907.42
99 8.250$ 23,907.42$ 139.46$ 1,021.63$ 37,833.70 $ 22,885.79
100 8.333$ 22,885.79$ 133.51$ 1,027.58$ 37,967.21 $ 21,858.21
101 8.417$ 21,858.21$ 127.51$ 1,033.58$ 38,094.72 $ 20,824.63
102 8.500$ 20,824.63$ 121.48$ 1,039.61$ 38,216.20 $ 19,785.02
103 8.583$ 19,785.02$ 115.42$ 1,045.67$ 38,331.62 $ 18,739.35
104 8.667$ 18,739.35$ 109.32$ 1,051.77$ 38,440.94 $ 17,687.58
105 8.750$ 17,687.58$ 103.18$ 1,057.91$ 38,544.12 $ 16,629.67
106 8.833$ 16,629.67$ 97.01$ 1,064.08$ 38,641.13 $ 15,565.59
107 8.917$ 15,565.59$ 90.80$ 1,070.29$ 38,731.93 $ 14,495.30
108 9.000$ 14,495.30$ 84.56$ 1,076.53$ 38,816.49 $ 13,418.77
109 9.083$ 13,418.77$ 78.28$ 1,082.81$ 38,894.77 $ 12,335.96
110 9.167$ 12,335.96$ 71.96$ 1,089.13$ 38,966.73 $ 11,246.83
111 9.250$ 11,246.83$ 65.61$ 1,095.48$ 39,032.34 $ 10,151.35
112 9.333$ 10,151.35$ 59.22$ 1,101.87$ 39,091.56 $ 9,049.48
113 9.417$ 9,049.48$ 52.79$ 1,108.30$ 39,144.35 $ 7,941.18
114 9.500$ 7,941.18$ 46.33$ 1,114.76$ 39,190.68 $ 6,826.42
115 9.583$ 6,826.42$ 39.83$ 1,121.26$ 39,230.51 $ 5,705.16
116 9.667$ 5,705.16$ 33.29$ 1,127.80$ 39,263.80 $ 4,577.36
117 9.750$ 4,577.36$ 26.71$ 1,134.38$ 39,290.51 $ 3,442.98
118 9.833$ 3,442.98$ 20.09$ 1,141.00$ 39,310.60 $ 2,301.98
119 9.917$ 2,301.98$ 13.43$ 1,147.66$ 39,324.03 $ 1,154.32
12010.000$ 1,154.32$ 6.74$ 1,154.35$ 39,330.77 $ -0.03

Total Payments: $ 139,330.80
Total Interest $ 39,330.77


Hugh - Calculators