portfolios.tools

Amortization Schedule Ledger — Free Online Calculator

Free amortization schedule ledger generates a full principal vs interest breakdown for any fixed rate loan. Instant browser results, no signup needed.

Amortization Schedule Ledger — Free Online Calculator
Results
Monthly Payment$1,896.2
Total Interest$382,633.47
Interest/Principal Ratio1.28%

Monthly Payment Breakdown

MonthPaymentPrincipalInterestBalance
1$1,896.2$271.2$1,625$299,728.8
2$1,896.2$272.67$1,623.53$299,456.12
3$1,896.2$274.15$1,622.05$299,181.97
4$1,896.2$275.64$1,620.57$298,906.34
5$1,896.2$277.13$1,619.08$298,629.21
6$1,896.2$278.63$1,617.57$298,350.58
7$1,896.2$280.14$1,616.07$298,070.44
8$1,896.2$281.66$1,614.55$297,788.79
9$1,896.2$283.18$1,613.02$297,505.6
10$1,896.2$284.72$1,611.49$297,220.89
11$1,896.2$286.26$1,609.95$296,934.63
12$1,896.2$287.81$1,608.4$296,646.82
13$1,896.2$289.37$1,606.84$296,357.46
14$1,896.2$290.93$1,605.27$296,066.52
15$1,896.2$292.51$1,603.69$295,774.01
16$1,896.2$294.09$1,602.11$295,479.92
17$1,896.2$295.69$1,600.52$295,184.23
18$1,896.2$297.29$1,598.91$294,886.94
19$1,896.2$298.9$1,597.3$294,588.04
20$1,896.2$300.52$1,595.69$294,287.52
21$1,896.2$302.15$1,594.06$293,985.37
22$1,896.2$303.78$1,592.42$293,681.59
23$1,896.2$305.43$1,590.78$293,376.16
24$1,896.2$307.08$1,589.12$293,069.08
25$1,896.2$308.75$1,587.46$292,760.33
26$1,896.2$310.42$1,585.79$292,449.91
27$1,896.2$312.1$1,584.1$292,137.81
28$1,896.2$313.79$1,582.41$291,824.02
29$1,896.2$315.49$1,580.71$291,508.53
30$1,896.2$317.2$1,579$291,191.33
31$1,896.2$318.92$1,577.29$290,872.41
32$1,896.2$320.65$1,575.56$290,551.77
33$1,896.2$322.38$1,573.82$290,229.39
34$1,896.2$324.13$1,572.08$289,905.26
35$1,896.2$325.88$1,570.32$289,579.37
36$1,896.2$327.65$1,568.55$289,251.73
37$1,896.2$329.42$1,566.78$288,922.3
38$1,896.2$331.21$1,565$288,591.09
39$1,896.2$333$1,563.2$288,258.09
40$1,896.2$334.81$1,561.4$287,923.29
41$1,896.2$336.62$1,559.58$287,586.67
42$1,896.2$338.44$1,557.76$287,248.22
43$1,896.2$340.28$1,555.93$286,907.95
44$1,896.2$342.12$1,554.08$286,565.83
45$1,896.2$343.97$1,552.23$286,221.85
46$1,896.2$345.84$1,550.37$285,876.02
47$1,896.2$347.71$1,548.5$285,528.31
48$1,896.2$349.59$1,546.61$285,178.72
49$1,896.2$351.49$1,544.72$284,827.23
50$1,896.2$353.39$1,542.81$284,473.84
51$1,896.2$355.3$1,540.9$284,118.54
52$1,896.2$357.23$1,538.98$283,761.31
53$1,896.2$359.16$1,537.04$283,402.15
54$1,896.2$361.11$1,535.09$283,041.04
55$1,896.2$363.07$1,533.14$282,677.97
56$1,896.2$365.03$1,531.17$282,312.94
57$1,896.2$367.01$1,529.2$281,945.93
58$1,896.2$369$1,527.21$281,576.93
59$1,896.2$371$1,525.21$281,205.94
60$1,896.2$373.01$1,523.2$280,832.93
61$1,896.2$375.03$1,521.18$280,457.91
62$1,896.2$377.06$1,519.15$280,080.85
63$1,896.2$379.1$1,517.1$279,701.75
64$1,896.2$381.15$1,515.05$279,320.6
65$1,896.2$383.22$1,512.99$278,937.38
66$1,896.2$385.29$1,510.91$278,552.09
67$1,896.2$387.38$1,508.82$278,164.71
68$1,896.2$389.48$1,506.73$277,775.23
69$1,896.2$391.59$1,504.62$277,383.64
70$1,896.2$393.71$1,502.49$276,989.93
71$1,896.2$395.84$1,500.36$276,594.09
72$1,896.2$397.99$1,498.22$276,196.1
73$1,896.2$400.14$1,496.06$275,795.96
74$1,896.2$402.31$1,493.89$275,393.65
75$1,896.2$404.49$1,491.72$274,989.16
76$1,896.2$406.68$1,489.52$274,582.48
77$1,896.2$408.88$1,487.32$274,173.6
78$1,896.2$411.1$1,485.11$273,762.5
79$1,896.2$413.32$1,482.88$273,349.18
80$1,896.2$415.56$1,480.64$272,933.62
81$1,896.2$417.81$1,478.39$272,515.8
82$1,896.2$420.08$1,476.13$272,095.73
83$1,896.2$422.35$1,473.85$271,673.37
84$1,896.2$424.64$1,471.56$271,248.73
85$1,896.2$426.94$1,469.26$270,821.79
86$1,896.2$429.25$1,466.95$270,392.54
87$1,896.2$431.58$1,464.63$269,960.96
88$1,896.2$433.92$1,462.29$269,527.05
89$1,896.2$436.27$1,459.94$269,090.78
90$1,896.2$438.63$1,457.58$268,652.15
91$1,896.2$441$1,455.2$268,211.15
92$1,896.2$443.39$1,452.81$267,767.75
93$1,896.2$445.8$1,450.41$267,321.96
94$1,896.2$448.21$1,447.99$266,873.75
95$1,896.2$450.64$1,445.57$266,423.11
96$1,896.2$453.08$1,443.13$265,970.03
97$1,896.2$455.53$1,440.67$265,514.5
98$1,896.2$458$1,438.2$265,056.5
99$1,896.2$460.48$1,435.72$264,596.02
100$1,896.2$462.98$1,433.23$264,133.04
101$1,896.2$465.48$1,430.72$263,667.56
102$1,896.2$468$1,428.2$263,199.55
103$1,896.2$470.54$1,425.66$262,729.01
104$1,896.2$473.09$1,423.12$262,255.93
105$1,896.2$475.65$1,420.55$261,780.27
106$1,896.2$478.23$1,417.98$261,302.05
107$1,896.2$480.82$1,415.39$260,821.23
108$1,896.2$483.42$1,412.78$260,337.81
109$1,896.2$486.04$1,410.16$259,851.77
110$1,896.2$488.67$1,407.53$259,363.09
111$1,896.2$491.32$1,404.88$258,871.77
112$1,896.2$493.98$1,402.22$258,377.79
113$1,896.2$496.66$1,399.55$257,881.13
114$1,896.2$499.35$1,396.86$257,381.78
115$1,896.2$502.05$1,394.15$256,879.73
116$1,896.2$504.77$1,391.43$256,374.96
117$1,896.2$507.51$1,388.7$255,867.45
118$1,896.2$510.26$1,385.95$255,357.2
119$1,896.2$513.02$1,383.18$254,844.18
120$1,896.2$515.8$1,380.41$254,328.38
121$1,896.2$518.59$1,377.61$253,809.79
122$1,896.2$521.4$1,374.8$253,288.39
123$1,896.2$524.23$1,371.98$252,764.16
124$1,896.2$527.06$1,369.14$252,237.1
125$1,896.2$529.92$1,366.28$251,707.18
126$1,896.2$532.79$1,363.41$251,174.39
127$1,896.2$535.68$1,360.53$250,638.71
128$1,896.2$538.58$1,357.63$250,100.13
129$1,896.2$541.5$1,354.71$249,558.64
130$1,896.2$544.43$1,351.78$249,014.21
131$1,896.2$547.38$1,348.83$248,466.83
132$1,896.2$550.34$1,345.86$247,916.49
133$1,896.2$553.32$1,342.88$247,363.17
134$1,896.2$556.32$1,339.88$246,806.85
135$1,896.2$559.33$1,336.87$246,247.51
136$1,896.2$562.36$1,333.84$245,685.15
137$1,896.2$565.41$1,330.79$245,119.74
138$1,896.2$568.47$1,327.73$244,551.27
139$1,896.2$571.55$1,324.65$243,979.72
140$1,896.2$574.65$1,321.56$243,405.07
141$1,896.2$577.76$1,318.44$242,827.31
142$1,896.2$580.89$1,315.31$242,246.42
143$1,896.2$584.04$1,312.17$241,662.38
144$1,896.2$587.2$1,309$241,075.18
145$1,896.2$590.38$1,305.82$240,484.8
146$1,896.2$593.58$1,302.63$239,891.23
147$1,896.2$596.79$1,299.41$239,294.43
148$1,896.2$600.03$1,296.18$238,694.41
149$1,896.2$603.28$1,292.93$238,091.13
150$1,896.2$606.54$1,289.66$237,484.59
151$1,896.2$609.83$1,286.37$236,874.76
152$1,896.2$613.13$1,283.07$236,261.63
153$1,896.2$616.45$1,279.75$235,645.17
154$1,896.2$619.79$1,276.41$235,025.38
155$1,896.2$623.15$1,273.05$234,402.23
156$1,896.2$626.53$1,269.68$233,775.7
157$1,896.2$629.92$1,266.29$233,145.78
158$1,896.2$633.33$1,262.87$232,512.45
159$1,896.2$636.76$1,259.44$231,875.69
160$1,896.2$640.21$1,255.99$231,235.48
161$1,896.2$643.68$1,252.53$230,591.8
162$1,896.2$647.17$1,249.04$229,944.64
163$1,896.2$650.67$1,245.53$229,293.97
164$1,896.2$654.2$1,242.01$228,639.77
165$1,896.2$657.74$1,238.47$227,982.03
166$1,896.2$661.3$1,234.9$227,320.73
167$1,896.2$664.88$1,231.32$226,655.85
168$1,896.2$668.48$1,227.72$225,987.36
169$1,896.2$672.11$1,224.1$225,315.26
170$1,896.2$675.75$1,220.46$224,639.51
171$1,896.2$679.41$1,216.8$223,960.1
172$1,896.2$683.09$1,213.12$223,277.02
173$1,896.2$686.79$1,209.42$222,590.23
174$1,896.2$690.51$1,205.7$221,899.72
175$1,896.2$694.25$1,201.96$221,205.48
176$1,896.2$698.01$1,198.2$220,507.47
177$1,896.2$701.79$1,194.42$219,805.68
178$1,896.2$705.59$1,190.61$219,100.09
179$1,896.2$709.41$1,186.79$218,390.68
180$1,896.2$713.25$1,182.95$217,677.42
181$1,896.2$717.12$1,179.09$216,960.31
182$1,896.2$721$1,175.2$216,239.3
183$1,896.2$724.91$1,171.3$215,514.4
184$1,896.2$728.83$1,167.37$214,785.56
185$1,896.2$732.78$1,163.42$214,052.78
186$1,896.2$736.75$1,159.45$213,316.03
187$1,896.2$740.74$1,155.46$212,575.28
188$1,896.2$744.75$1,151.45$211,830.53
189$1,896.2$748.79$1,147.42$211,081.74
190$1,896.2$752.84$1,143.36$210,328.9
191$1,896.2$756.92$1,139.28$209,571.97
192$1,896.2$761.02$1,135.18$208,810.95
193$1,896.2$765.14$1,131.06$208,045.81
194$1,896.2$769.29$1,126.91$207,276.52
195$1,896.2$773.46$1,122.75$206,503.06
196$1,896.2$777.65$1,118.56$205,725.42
197$1,896.2$781.86$1,114.35$204,943.56
198$1,896.2$786.09$1,110.11$204,157.46
199$1,896.2$790.35$1,105.85$203,367.11
200$1,896.2$794.63$1,101.57$202,572.48
201$1,896.2$798.94$1,097.27$201,773.54
202$1,896.2$803.26$1,092.94$200,970.28
203$1,896.2$807.62$1,088.59$200,162.67
204$1,896.2$811.99$1,084.21$199,350.68
205$1,896.2$816.39$1,079.82$198,534.29
206$1,896.2$820.81$1,075.39$197,713.48
207$1,896.2$825.26$1,070.95$196,888.22
208$1,896.2$829.73$1,066.48$196,058.5
209$1,896.2$834.22$1,061.98$195,224.28
210$1,896.2$838.74$1,057.46$194,385.54
211$1,896.2$843.28$1,052.92$193,542.25
212$1,896.2$847.85$1,048.35$192,694.4
213$1,896.2$852.44$1,043.76$191,841.96
214$1,896.2$857.06$1,039.14$190,984.9
215$1,896.2$861.7$1,034.5$190,123.2
216$1,896.2$866.37$1,029.83$189,256.83
217$1,896.2$871.06$1,025.14$188,385.77
218$1,896.2$875.78$1,020.42$187,509.98
219$1,896.2$880.52$1,015.68$186,629.46
220$1,896.2$885.29$1,010.91$185,744.16
221$1,896.2$890.09$1,006.11$184,854.07
222$1,896.2$894.91$1,001.29$183,959.16
223$1,896.2$899.76$996.45$183,059.4
224$1,896.2$904.63$991.57$182,154.77
225$1,896.2$909.53$986.67$181,245.24
226$1,896.2$914.46$981.75$180,330.78
227$1,896.2$919.41$976.79$179,411.37
228$1,896.2$924.39$971.81$178,486.98
229$1,896.2$929.4$966.8$177,557.58
230$1,896.2$934.43$961.77$176,623.14
231$1,896.2$939.5$956.71$175,683.65
232$1,896.2$944.58$951.62$174,739.06
233$1,896.2$949.7$946.5$173,789.36
234$1,896.2$954.85$941.36$172,834.52
235$1,896.2$960.02$936.19$171,874.5
236$1,896.2$965.22$930.99$170,909.28
237$1,896.2$970.45$925.76$169,938.84
238$1,896.2$975.7$920.5$168,963.14
239$1,896.2$980.99$915.22$167,982.15
240$1,896.2$986.3$909.9$166,995.85
241$1,896.2$991.64$904.56$166,004.2
242$1,896.2$997.01$899.19$165,007.19
243$1,896.2$1,002.42$893.79$164,004.77
244$1,896.2$1,007.84$888.36$162,996.93
245$1,896.2$1,013.3$882.9$161,983.63
246$1,896.2$1,018.79$877.41$160,964.83
247$1,896.2$1,024.31$871.89$159,940.52
248$1,896.2$1,029.86$866.34$158,910.66
249$1,896.2$1,035.44$860.77$157,875.22
250$1,896.2$1,041.05$855.16$156,834.18
251$1,896.2$1,046.69$849.52$155,787.49
252$1,896.2$1,052.36$843.85$154,735.14
253$1,896.2$1,058.06$838.15$153,677.08
254$1,896.2$1,063.79$832.42$152,613.29
255$1,896.2$1,069.55$826.66$151,543.75
256$1,896.2$1,075.34$820.86$150,468.4
257$1,896.2$1,081.17$815.04$149,387.24
258$1,896.2$1,087.02$809.18$148,300.21
259$1,896.2$1,092.91$803.29$147,207.3
260$1,896.2$1,098.83$797.37$146,108.47
261$1,896.2$1,104.78$791.42$145,003.69
262$1,896.2$1,110.77$785.44$143,892.92
263$1,896.2$1,116.78$779.42$142,776.14
264$1,896.2$1,122.83$773.37$141,653.3
265$1,896.2$1,128.92$767.29$140,524.39
266$1,896.2$1,135.03$761.17$139,389.36
267$1,896.2$1,141.18$755.03$138,248.18
268$1,896.2$1,147.36$748.84$137,100.82
269$1,896.2$1,153.57$742.63$135,947.25
270$1,896.2$1,159.82$736.38$134,787.42
271$1,896.2$1,166.11$730.1$133,621.32
272$1,896.2$1,172.42$723.78$132,448.89
273$1,896.2$1,178.77$717.43$131,270.12
274$1,896.2$1,185.16$711.05$130,084.96
275$1,896.2$1,191.58$704.63$128,893.39
276$1,896.2$1,198.03$698.17$127,695.36
277$1,896.2$1,204.52$691.68$126,490.83
278$1,896.2$1,211.05$685.16$125,279.79
279$1,896.2$1,217.61$678.6$124,062.18
280$1,896.2$1,224.2$672$122,837.98
281$1,896.2$1,230.83$665.37$121,607.15
282$1,896.2$1,237.5$658.71$120,369.65
283$1,896.2$1,244.2$652$119,125.45
284$1,896.2$1,250.94$645.26$117,874.51
285$1,896.2$1,257.72$638.49$116,616.79
286$1,896.2$1,264.53$631.67$115,352.26
287$1,896.2$1,271.38$624.82$114,080.88
288$1,896.2$1,278.27$617.94$112,802.62
289$1,896.2$1,285.19$611.01$111,517.43
290$1,896.2$1,292.15$604.05$110,225.28
291$1,896.2$1,299.15$597.05$108,926.13
292$1,896.2$1,306.19$590.02$107,619.94
293$1,896.2$1,313.26$582.94$106,306.68
294$1,896.2$1,320.38$575.83$104,986.3
295$1,896.2$1,327.53$568.68$103,658.77
296$1,896.2$1,334.72$561.49$102,324.05
297$1,896.2$1,341.95$554.26$100,982.1
298$1,896.2$1,349.22$546.99$99,632.89
299$1,896.2$1,356.53$539.68$98,276.36
300$1,896.2$1,363.87$532.33$96,912.49
301$1,896.2$1,371.26$524.94$95,541.22
302$1,896.2$1,378.69$517.51$94,162.54
303$1,896.2$1,386.16$510.05$92,776.38
304$1,896.2$1,393.67$502.54$91,382.71
305$1,896.2$1,401.21$494.99$89,981.5
306$1,896.2$1,408.8$487.4$88,572.69
307$1,896.2$1,416.44$479.77$87,156.26
308$1,896.2$1,424.11$472.1$85,732.15
309$1,896.2$1,431.82$464.38$84,300.33
310$1,896.2$1,439.58$456.63$82,860.75
311$1,896.2$1,447.37$448.83$81,413.38
312$1,896.2$1,455.21$440.99$79,958.16
313$1,896.2$1,463.1$433.11$78,495.07
314$1,896.2$1,471.02$425.18$77,024.04
315$1,896.2$1,478.99$417.21$75,545.05
316$1,896.2$1,487$409.2$74,058.05
317$1,896.2$1,495.06$401.15$72,562.99
318$1,896.2$1,503.15$393.05$71,059.84
319$1,896.2$1,511.3$384.91$69,548.54
320$1,896.2$1,519.48$376.72$68,029.06
321$1,896.2$1,527.71$368.49$66,501.35
322$1,896.2$1,535.99$360.22$64,965.36
323$1,896.2$1,544.31$351.9$63,421.05
324$1,896.2$1,552.67$343.53$61,868.38
325$1,896.2$1,561.08$335.12$60,307.29
326$1,896.2$1,569.54$326.66$58,737.75
327$1,896.2$1,578.04$318.16$57,159.71
328$1,896.2$1,586.59$309.62$55,573.12
329$1,896.2$1,595.18$301.02$53,977.94
330$1,896.2$1,603.82$292.38$52,374.12
331$1,896.2$1,612.51$283.69$50,761.61
332$1,896.2$1,621.25$274.96$49,140.36
333$1,896.2$1,630.03$266.18$47,510.33
334$1,896.2$1,638.86$257.35$45,871.48
335$1,896.2$1,647.73$248.47$44,223.74
336$1,896.2$1,656.66$239.55$42,567.08
337$1,896.2$1,665.63$230.57$40,901.45
338$1,896.2$1,674.65$221.55$39,226.8
339$1,896.2$1,683.73$212.48$37,543.07
340$1,896.2$1,692.85$203.36$35,850.23
341$1,896.2$1,702.02$194.19$34,148.21
342$1,896.2$1,711.23$184.97$32,436.98
343$1,896.2$1,720.5$175.7$30,716.47
344$1,896.2$1,729.82$166.38$28,986.65
345$1,896.2$1,739.19$157.01$27,247.46
346$1,896.2$1,748.61$147.59$25,498.84
347$1,896.2$1,758.09$138.12$23,740.76
348$1,896.2$1,767.61$128.6$21,973.15
349$1,896.2$1,777.18$119.02$20,195.97
350$1,896.2$1,786.81$109.39$18,409.16
351$1,896.2$1,796.49$99.72$16,612.67
352$1,896.2$1,806.22$89.99$14,806.45
353$1,896.2$1,816$80.2$12,990.45
354$1,896.2$1,825.84$70.36$11,164.61
355$1,896.2$1,835.73$60.47$9,328.88
356$1,896.2$1,845.67$50.53$7,483.21
357$1,896.2$1,855.67$40.53$5,627.54
358$1,896.2$1,865.72$30.48$3,761.82
359$1,896.2$1,875.83$20.38$1,885.99
360$1,896.2$1,885.99$10.22$0

Like this tool? Help keep portfolios.tools free forever.

$5
$1$50

How It Works

Enter loan amount, annual interest rate, and term in months. The calculator generates complete amortization schedule showing how each monthly payment splits between principal and interest over loan life. Month one on three hundred thousand dollar mortgage at six percent allocates roughly eighty three percent of payment to interest. Crossover where principal exceeds interest often occurs past month two hundred on thirty year loan. Printable amortization schedule supports mortgage planning meetings with lender or spouse when comparing fifteen versus thirty year note on same purchase price and rate spread. Use full schedule to identify month when cumulative principal paid exceeds cumulative interest paid which motivates early extra principal payments in first third of loan life. Total interest paid figure often exceeds purchase price on thirty year mortgage at market rates motivating refinance or prepayment analysis.

Review monthly payment amount, total interest paid, interest to principal ratio, and full monthly ledger. Total interest paid often surprises first time homebuyers comparing thirty versus fifteen year terms. Extra hundred dollar monthly principal payment from month one can remove four plus years from thirty year schedule on typical mortgage rate. Cumulative interest column shows running total paid to lender which motivates extra principal payments early in schedule when interest portion dominates each payment. Compare thirty year versus fifteen year total interest paid on same loan amount and rate before choosing mortgage term at origination or refinance decision. Scroll amortization table to month where principal portion first exceeds interest portion as motivational milestone for prepayment planning. Compare fifteen year versus thirty year schedule on same principal and rate before selecting mortgage term at origination decision point. First month principal exceeds interest milestone on long mortgage motivates early extra principal payment strategy for lifetime interest savings maximization. Extra principal payments reduce interest portion of scheduled payment immediately while keeping contractual maturity date unless lender recasts amortization schedule formally. Interest only periods common in commercial real estate bridge loans defer principal until stabilization milestone triggers conversion to fully amortizing schedule. Biweekly payment acceleration on residential loans effectively adds thirteenth monthly payment annually shortening payoff by several years on typical thirty year note. Ledger export supports tax reporting of deductible interest versus principal return of capital on investment property schedules.

Compare fifteen year versus thirty year schedule on same principal and rate before selecting mortgage term at origination decision point. First month principal exceeds interest milestone on long mortgage motivates early extra principal payment strategy for lifetime interest savings maximization. Extra principal payments reduce interest portion of scheduled payment immediately while keeping contractual maturity date unless lender recasts amortization schedule formally. Interest only periods common in commercial real estate bridge loans defer principal until stabilization milestone triggers conversion to fully amortizing schedule. Biweekly payment acceleration on residential loans effectively adds thirteenth monthly payment annually shortening payoff by several years on typical thirty year note. Ledger export supports tax reporting of deductible interest versus principal return of capital on investment property schedules.

Use Amortization Schedule Ledger whenever inputs change: after market moves, new contributions, or revised personal assumptions. Bookmark the page for quick reruns without installing software.

Step by step

  1. Enter loan amount, annual rate, and term in months
  2. Review monthly payment, total interest, and interest to principal ratio
  3. Scroll amortization table to plan prepayments and payoff date

Worked example

Enter loan amount, annual interest rate, and term in months. Enter the sample inputs described in How it works to reproduce the scenario step by step.

Adjust one input at a time to see sensitivity. Amortization Schedule Ledger updates instantly so you can stress test optimistic and conservative assumptions before acting.

When to use this calculator

Reach for Amortization Schedule Ledger when generate a full principal vs interest breakdown for any fixed rate loan.. It suits quick what if analysis before trades, allocation changes, or plan updates.

Pair with related tools when the decision spans taxes, liquidity, or multi year projections beyond what one formula captures.

Common mistakes

Copying outputs without checking input units or stale market prices is a frequent error with Amortization Schedule Ledger. Confirm tickers, percentages, and dates before acting.

Running a single baseline scenario ignores tail risks. Stress test with conservative inputs and compare against related tools listed below when the decision is material.

The Formula

Monthly payment: P = L × r × (1 + r)^n / ((1 + r)^n - 1)

Each month: interest = balance × r

principal = P - interest

balance_new = balance - principal

where L = loanAmount, r = annualRate / 12 / 100, n = termMonths

Fixed rate amortization assumed. Adjustable rate loans need new schedule at each reset. Extra payments not modeled in base schedule. Monthly rate equals annual rate divided by twelve. Assumes fixed rate fully amortizing loan. Level payment fixed rate fully amortizing loan. Biweekly equivalent not modeled. Export mental milestone at first month principal exceeds interest as prepayment motivation anchor on long mortgage schedules. Per period interest equals remaining balance times periodic rate with principal portion as payment minus interest component each row in schedule table export.

Limitations and assumptions

Fixed rate amortization assumed. Adjustable rate loans need new schedule at each reset. Extra payments not modeled in base schedule. Monthly rate equals annual rate divided by twelve. Assumes fixed rate fully amortizing loan. Level payment fixed rate fully amortizing loan. Biweekly equivalent not modeled. Export mental milestone at first month principal exceeds interest as prepayment motivation anchor on long mortgage schedules. Per period interest equals remaining balance times periodic rate with principal portion as payment minus interest component each row in schedule table export. Amortization Schedule Ledger does not replace personalized advice. Fees, slippage, account specific rules, and behavioral constraints may change real world outcomes.

Key terms

How much total interest will I pay
Total interest is sum of all interest payments over loan life.
How are monthly payments split between principal and interest
Monthly payment equals standard amortization formula on loan amount, monthly rate, and total months.
Model assumption
Early in loan most payment goes to interest.

Compare alternatives

Compare vehicle finance with Lease vs Buy and refi economics with Mortgage Refinance Break Even on portfolios. Use those calculators when amortization schedule ledger alone does not capture the full decision.

Internal links on portfolios.tools help you chain calculators: run Amortization Schedule Ledger first, then validate edge cases with a specialized tool from the related section below.

FAQ

How much total interest will I pay?

Total interest is sum of all interest payments over loan life. Thirty year mortgage at four percent has roughly zero point seven two ratio meaning seventy two cents interest per dollar borrowed. Interest to principal ratio above one means more than one dollar interest per dollar borrowed over life. Refinance resets amortization clock to new rate and term changing total interest path materially.

How are monthly payments split between principal and interest?

Monthly payment equals standard amortization formula on loan amount, monthly rate, and total months. Extra principal payments reduce future interest immediately because balance drops. Biweekly payment schemes make thirteen monthly payments per year accelerating payoff slightly. Interest only period before amortization start common in ARM teaser structures not in fixed rate model here.

Why is interest higher at the start of the loan?

Early in loan most payment goes to interest. As balance falls interest portion shrinks and principal accelerates. Extra payments at loan start save more total interest. ARM loans require new amortization schedule at each reset. Property tax and insurance escrow excluded from payment breakdown shown. Extra principal payment in month one saves more lifetime interest than same dollar payment in year twenty because interest portion dominates early payments.

Can I compare different loan terms?

Fifteen year loan has higher monthly payment but dramatically less total interest than thirty year at same rate. On $250,000 at five point five percent, fifteen year saves over $120,000 lifetime interest. PMI drops when LTV reaches eighty percent on conventional loans separate from amortization math here. HELOC interest only phase differs from amortizing first mortgage schedule. Fifteen year mortgage saves six figures lifetime interest versus thirty year on typical primary residence loan amount and rate spread.

What related loan calculators should I use?

Use Lease vs Buy for vehicle financing decisions. Mortgage Refinance Break Even compares rate reduction against closing costs. Compare refi break even when rates drop two hundred basis points below current note rate. Sinking fund planner aggregates multiple loan payments with other savings goals. Sinking Fund Planner aggregates multiple loan payments with other savings goals in household budget planning workflow beyond single loan schedule.

How do I use this amortization schedule ledger on phone or tablet?

Yes. Amortization Schedule Ledger runs entirely in your mobile browser with the same formulas as desktop. Optional localStorage may remember inputs on your device when enabled in browser settings.

Where is my data stored when I use Amortization Schedule Ledger?

Nowhere on our servers. Calculations execute locally in your browser. Optional localStorage saves form fields on your device only and never transmits portfolio numbers over the network.

Should I rely on Amortization Schedule Ledger for tax or legal decisions?

No. Amortization Schedule Ledger provides educational math only. Tax law, account rules, and personal circumstances vary. Consult a qualified tax or legal professional before transactions with material consequences.

Related Tools

Compare vehicle finance with Lease vs Buy and refi economics with Mortgage Refinance Break Even on portfolios.tools when extending amortization analysis beyond single loan schedule. Extend analysis with Mortgage Refinance Break Even, Lease vs Buy, and Sinking Fund Planner on portfolios.tools. Compare Mortgage Refinance Break Even, Lease vs Buy, and Sinking Fund Planner on portfolios.tools for household debt planning.