Skip to content

Instantly share code, notes, and snippets.

@jhannah

jhannah/gist:7961433dcd9195f907d9d8e82ddb9564

Last active December 29, 2023 22:09
Show Gist options
  • Star 2 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jhannah/7961433dcd9195f907d9d8e82ddb9564 to your computer and use it in GitHub Desktop.
Save jhannah/7961433dcd9195f907d9d8e82ddb9564 to your computer and use it in GitHub Desktop.
Download ZIP
Mortgage: Amortization schedule / payments
Raw
gistfile1.txt
2.13% APR
Payment 1: Aug 1 2021
$ pip3 install amortization (https://github.com/roniemartinez/amortization)
$ amortize --principal 176000 --period 180 --interest-rate 0.0213 --schedule
Number Amount Interest Principal Balance
-------- ---------- ---------- ----------- ----------
1 1,143.14 312.40 830.74 175,169.26 Aug 1 2021
2 1,143.14 310.93 832.21 174,337.05
3 1,143.14 309.45 833.69 173,503.36
4 1,143.14 307.97 835.17 172,668.19
5 1,143.14 306.49 836.65 171,831.54
6 1,143.14 305.00 838.14 170,993.40 Jan 1 2022
7 1,143.14 303.51 839.63 170,153.77
8 1,143.14 302.02 841.12 169,312.65
9 1,143.14 300.53 842.61 168,470.04
10 1,143.14 299.03 844.11 167,625.93
11 1,143.14 297.54 845.60 166,780.33
12 1,143.14 296.04 847.10 165,933.23 Jul 1 2022
13 1,143.14 294.53 848.61 165,084.62
14 1,143.14 293.03 850.11 164,234.51
15 1,143.14 291.52 851.62 163,382.89
16 1,143.14 290.00 853.14 162,529.75
17 1,143.14 288.49 854.65 161,675.10
18 1,143.14 286.97 856.17 160,818.93 Jan 1 2023
19 1,143.14 285.45 857.69 159,961.24
20 1,143.14 283.93 859.21 159,102.03
21 1,143.14 282.41 860.73 158,241.30
22 1,143.14 280.88 862.26 157,379.04
23 1,143.14 279.35 863.79 156,515.25
24 1,143.14 277.81 865.33 155,649.92 Jul 1 2023
25 1,143.14 276.28 866.86 154,783.06
26 1,143.14 274.74 868.40 153,914.66
27 1,143.14 273.20 869.94 153,044.72
28 1,143.14 271.65 871.49 152,173.23
29 1,143.14 270.11 873.03 151,300.20
30 1,143.14 268.56 874.58 150,425.62 Jan 1 2024
31 1,143.14 267.01 876.13 149,549.49
32 1,143.14 265.45 877.69 148,671.80
33 1,143.14 263.89 879.25 147,792.55
34 1,143.14 262.33 880.81 146,911.74
35 1,143.14 260.77 882.37 146,029.37
36 1,143.14 259.20 883.94 145,145.43 Jul 1 2024
37 1,143.14 257.63 885.51 144,259.92
38 1,143.14 256.06 887.08 143,372.84
39 1,143.14 254.49 888.65 142,484.19
40 1,143.14 252.91 890.23 141,593.96
41 1,143.14 251.33 891.81 140,702.15
42 1,143.14 249.75 893.39 139,808.76 Jan 1 2025
43 1,143.14 248.16 894.98 138,913.78
44 1,143.14 246.57 896.57 138,017.21
45 1,143.14 244.98 898.16 137,119.05
46 1,143.14 243.39 899.75 136,219.30
47 1,143.14 241.79 901.35 135,317.95
48 1,143.14 240.19 902.95 134,415.00
49 1,143.14 238.59 904.55 133,510.45
50 1,143.14 236.98 906.16 132,604.29
51 1,143.14 235.37 907.77 131,696.52
52 1,143.14 233.76 909.38 130,787.14
53 1,143.14 232.15 910.99 129,876.15
54 1,143.14 230.53 912.61 128,963.54
55 1,143.14 228.91 914.23 128,049.31
56 1,143.14 227.29 915.85 127,133.46
57 1,143.14 225.66 917.48 126,215.98
58 1,143.14 224.03 919.11 125,296.87
59 1,143.14 222.40 920.74 124,376.13
60 1,143.14 220.77 922.37 123,453.76
61 1,143.14 219.13 924.01 122,529.75
62 1,143.14 217.49 925.65 121,604.10
63 1,143.14 215.85 927.29 120,676.81
64 1,143.14 214.20 928.94 119,747.87
65 1,143.14 212.55 930.59 118,817.28
66 1,143.14 210.90 932.24 117,885.04
67 1,143.14 209.25 933.89 116,951.15
68 1,143.14 207.59 935.55 116,015.60
69 1,143.14 205.93 937.21 115,078.39
70 1,143.14 204.26 938.88 114,139.51
71 1,143.14 202.60 940.54 113,198.97
72 1,143.14 200.93 942.21 112,256.76
73 1,143.14 199.26 943.88 111,312.88
74 1,143.14 197.58 945.56 110,367.32
75 1,143.14 195.90 947.24 109,420.08
76 1,143.14 194.22 948.92 108,471.16
77 1,143.14 192.54 950.60 107,520.56
78 1,143.14 190.85 952.29 106,568.27
79 1,143.14 189.16 953.98 105,614.29
80 1,143.14 187.47 955.67 104,658.62
81 1,143.14 185.77 957.37 103,701.25
82 1,143.14 184.07 959.07 102,742.18
83 1,143.14 182.37 960.77 101,781.41
84 1,143.14 180.66 962.48 100,818.93
85 1,143.14 178.95 964.19 99,854.74
86 1,143.14 177.24 965.90 98,888.84
87 1,143.14 175.53 967.61 97,921.23
88 1,143.14 173.81 969.33 96,951.90
89 1,143.14 172.09 971.05 95,980.85
90 1,143.14 170.37 972.77 95,008.08
91 1,143.14 168.64 974.50 94,033.58
92 1,143.14 166.91 976.23 93,057.35
93 1,143.14 165.18 977.96 92,079.39
94 1,143.14 163.44 979.70 91,099.69
95 1,143.14 161.70 981.44 90,118.25
96 1,143.14 159.96 983.18 89,135.07
97 1,143.14 158.21 984.93 88,150.14
98 1,143.14 156.47 986.67 87,163.47
99 1,143.14 154.72 988.42 86,175.05
100 1,143.14 152.96 990.18 85,184.87
101 1,143.14 151.20 991.94 84,192.93
102 1,143.14 149.44 993.70 83,199.23
103 1,143.14 147.68 995.46 82,203.77
104 1,143.14 145.91 997.23 81,206.54
105 1,143.14 144.14 999.00 80,207.54
106 1,143.14 142.37 1,000.77 79,206.77
107 1,143.14 140.59 1,002.55 78,204.22
108 1,143.14 138.81 1,004.33 77,199.89
109 1,143.14 137.03 1,006.11 76,193.78
110 1,143.14 135.24 1,007.90 75,185.88
111 1,143.14 133.45 1,009.69 74,176.19
112 1,143.14 131.66 1,011.48 73,164.71
113 1,143.14 129.87 1,013.27 72,151.44
114 1,143.14 128.07 1,015.07 71,136.37
115 1,143.14 126.27 1,016.87 70,119.50
116 1,143.14 124.46 1,018.68 69,100.82
117 1,143.14 122.65 1,020.49 68,080.33
118 1,143.14 120.84 1,022.30 67,058.03
119 1,143.14 119.03 1,024.11 66,033.92
120 1,143.14 117.21 1,025.93 65,007.99
121 1,143.14 115.39 1,027.75 63,980.24
122 1,143.14 113.56 1,029.58 62,950.66
123 1,143.14 111.74 1,031.40 61,919.26
124 1,143.14 109.91 1,033.23 60,886.03
125 1,143.14 108.07 1,035.07 59,850.96
126 1,143.14 106.24 1,036.90 58,814.06
127 1,143.14 104.39 1,038.75 57,775.31
128 1,143.14 102.55 1,040.59 56,734.72
129 1,143.14 100.70 1,042.44 55,692.28
130 1,143.14 98.85 1,044.29 54,647.99
131 1,143.14 97.00 1,046.14 53,601.85
132 1,143.14 95.14 1,048.00 52,553.85
133 1,143.14 93.28 1,049.86 51,503.99
134 1,143.14 91.42 1,051.72 50,452.27
135 1,143.14 89.55 1,053.59 49,398.68
136 1,143.14 87.68 1,055.46 48,343.22
137 1,143.14 85.81 1,057.33 47,285.89
138 1,143.14 83.93 1,059.21 46,226.68
139 1,143.14 82.05 1,061.09 45,165.59
140 1,143.14 80.17 1,062.97 44,102.62
141 1,143.14 78.28 1,064.86 43,037.76
142 1,143.14 76.39 1,066.75 41,971.01
143 1,143.14 74.50 1,068.64 40,902.37
144 1,143.14 72.60 1,070.54 39,831.83
145 1,143.14 70.70 1,072.44 38,759.39
146 1,143.14 68.80 1,074.34 37,685.05
147 1,143.14 66.89 1,076.25 36,608.80
148 1,143.14 64.98 1,078.16 35,530.64
149 1,143.14 63.07 1,080.07 34,450.57
150 1,143.14 61.15 1,081.99 33,368.58
151 1,143.14 59.23 1,083.91 32,284.67
152 1,143.14 57.31 1,085.83 31,198.84
153 1,143.14 55.38 1,087.76 30,111.08
154 1,143.14 53.45 1,089.69 29,021.39
155 1,143.14 51.51 1,091.63 27,929.76
156 1,143.14 49.58 1,093.56 26,836.20
157 1,143.14 47.63 1,095.51 25,740.69
158 1,143.14 45.69 1,097.45 24,643.24
159 1,143.14 43.74 1,099.40 23,543.84
160 1,143.14 41.79 1,101.35 22,442.49
161 1,143.14 39.84 1,103.30 21,339.19
162 1,143.14 37.88 1,105.26 20,233.93
163 1,143.14 35.92 1,107.22 19,126.71
164 1,143.14 33.95 1,109.19 18,017.52
165 1,143.14 31.98 1,111.16 16,906.36
166 1,143.14 30.01 1,113.13 15,793.23
167 1,143.14 28.03 1,115.11 14,678.12
168 1,143.14 26.05 1,117.09 13,561.03
169 1,143.14 24.07 1,119.07 12,441.96
170 1,143.14 22.08 1,121.06 11,320.90
171 1,143.14 20.09 1,123.05 10,197.85
172 1,143.14 18.10 1,125.04 9,072.81
173 1,143.14 16.10 1,127.04 7,945.77
174 1,143.14 14.10 1,129.04 6,816.73
175 1,143.14 12.10 1,131.04 5,685.69
176 1,143.14 10.09 1,133.05 4,552.64
177 1,143.14 8.08 1,135.06 3,417.58
178 1,143.14 6.07 1,137.07 2,280.51
179 1,143.14 4.05 1,139.09 1,141.42
180 1,143.45 2.03 1,141.42 0.00
Totals 205,765.51 29,765.51 176,000.00
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment