ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
To use this document, go to the File menu and "Make a copy" for your own use (do not request access)
Learn more:
https://www.thebalance.com/how-amortization-works-315522
2
Or click here for your own copy
*IMPORTANT: These numbers and formulas might not be accurate or appropriate for your situation. You MUST verify all details, calculations, and projections with your financial institution before making Consult your tax advisor, financial advisor, and legal counsel before taking any action or making any decisions.
3
4
Enter your loan details in the green boxes
5
Loan AmountInterest RateTerm in Years
Monthly Payment
Extra Monthly
6
$100,000.006.00%30$599.550
7
8
Instructions:
Double click the video below, or visit
9
Month
StartingBalance
You PaidInterestPrincipalEndingBalanceTotalInterest(3 Minutes)
https://youtu.be/1mRGK8Zggf4
10
1$100,000.00$599.55$500.00$99.55$99,900.45$500.00
11
2$99,900.45$599.55$499.50$100.05$99,800.40$999.50
12
3$99,800.40$599.55$499.00$100.55$99,699.85$1,498.50
13
4$99,699.85$599.55$498.50$101.05$99,598.80$1,997.00
14
5$99,598.80$599.55$497.99$101.56$99,497.24$2,495.00
15
6$99,497.24$599.55$497.49$102.06$99,395.18$2,992.48
16
7$99,395.18$599.55$496.98$102.57$99,292.61$3,489.46
17
8$99,292.61$599.55$496.46$103.09$99,189.52$3,985.92
18
9$99,189.52$599.55$495.95$103.60$99,085.92$4,481.87
19
10$99,085.92$599.55$495.43$104.12$98,981.79$4,977.30
20
11$98,981.79$599.55$494.91$104.64$98,877.15$5,472.21
21
12$98,877.15$599.55$494.39$105.16$98,771.99$5,966.59
22
13$98,771.99$599.55$493.86$105.69$98,666.30$6,460.45
23
14$98,666.30$599.55$493.33$106.22$98,560.08$6,953.79
24
15$98,560.08$599.55$492.80$106.75$98,453.33$7,446.59
25
16$98,453.33$599.55$492.27$107.28$98,346.04$7,938.85
26
17$98,346.04$599.55$491.73$107.82$98,238.22$8,430.58
27
18$98,238.22$599.55$491.19$108.36$98,129.86$8,921.77Other tips:
Double click the video below, or visit
28
19$98,129.86$599.55$490.65$108.90$98,020.96$9,412.42
https://youtu.be/Utzru1S2vAI
29
20$98,020.96$599.55$490.10$109.45$97,911.52$9,902.53
30
21$97,911.52$599.55$489.56$109.99$97,801.53$10,392.09
31
22$97,801.53$599.55$489.01$110.54$97,690.98$10,881.09
32
23$97,690.98$599.55$488.45$111.10$97,579.89$11,369.55
33
24$97,579.89$599.55$487.90$111.65$97,468.24$11,857.45
34
25$97,468.24$599.55$487.34$112.21$97,356.03$12,344.79
35
26$97,356.03$599.55$486.78$112.77$97,243.26$12,831.57
36
27$97,243.26$599.55$486.22$113.33$97,129.92$13,317.79
37
28$97,129.92$599.55$485.65$113.90$97,016.02$13,803.44
38
29$97,016.02$599.55$485.08$114.47$96,901.55$14,288.52
39
30$96,901.55$599.55$484.51$115.04$96,786.51$14,773.02
40
31$96,786.51$599.55$483.93$115.62$96,670.89$15,256.96
41
32$96,670.89$599.55$483.35$116.20$96,554.69$15,740.31
42
33$96,554.69$599.55$482.77$116.78$96,437.92$16,223.08
43
34$96,437.92$599.55$482.19$117.36$96,320.56$16,705.27
44
35$96,320.56$599.55$481.60$117.95$96,202.61$17,186.88
45
36$96,202.61$599.55$481.01$118.54$96,084.07$17,667.89
46
37$96,084.07$599.55$480.42$119.13$95,964.94$18,148.31
47
38$95,964.94$599.55$479.82$119.73$95,845.21$18,628.13
48
39$95,845.21$599.55$479.23$120.32$95,724.89$19,107.36
49
40$95,724.89$599.55$478.62$120.93$95,603.96$19,585.98
50
41$95,603.96$599.55$478.02$121.53$95,482.43$20,064.00
51
42$95,482.43$599.55$477.41$122.14$95,360.29$20,541.42
52
43$95,360.29$599.55$476.80$122.75$95,237.55$21,018.22
53
44$95,237.55$599.55$476.19$123.36$95,114.18$21,494.41
54
45$95,114.18$599.55$475.57$123.98$94,990.20$21,969.98
55
46$94,990.20$599.55$474.95$124.60$94,865.60$22,444.93
56
47$94,865.60$599.55$474.33$125.22$94,740.38$22,919.26
57
48$94,740.38$599.55$473.70$125.85$94,614.53$23,392.96
58
49$94,614.53$599.55$473.07$126.48$94,488.05$23,866.03
59
50$94,488.05$599.55$472.44$127.11$94,360.94$24,338.47
60
51$94,360.94$599.55$471.80$127.75$94,233.20$24,810.28
61
52$94,233.20$599.55$471.17$128.38$94,104.81$25,281.44
62
53$94,104.81$599.55$470.52$129.03$93,975.79$25,751.97
63
54$93,975.79$599.55$469.88$129.67$93,846.12$26,221.84
64
55$93,846.12$599.55$469.23$130.32$93,715.80$26,691.07
65
56$93,715.80$599.55$468.58$130.97$93,584.82$27,159.65
66
57$93,584.82$599.55$467.92$131.63$93,453.20$27,627.58
67
58$93,453.20$599.55$467.27$132.28$93,320.91$28,094.84
68
59$93,320.91$599.55$466.60$132.95$93,187.97$28,561.45
69
60$93,187.97$599.55$465.94$133.61$93,054.36$29,027.39
70
61$93,054.36$599.55$465.27$134.28$92,920.08$29,492.66
71
62$92,920.08$599.55$464.60$134.95$92,785.13$29,957.26
72
63$92,785.13$599.55$463.93$135.62$92,649.50$30,421.19
73
64$92,649.50$599.55$463.25$136.30$92,513.20$30,884.43
74
65$92,513.20$599.55$462.57$136.98$92,376.22$31,347.00
75
66$92,376.22$599.55$461.88$137.67$92,238.55$31,808.88
76
67$92,238.55$599.55$461.19$138.36$92,100.19$32,270.07
77
68$92,100.19$599.55$460.50$139.05$91,961.14$32,730.57
78
69$91,961.14$599.55$459.81$139.74$91,821.39$33,190.38
79
70$91,821.39$599.55$459.11$140.44$91,680.95$33,649.49
80
71$91,680.95$599.55$458.40$141.15$91,539.80$34,107.89
81
72$91,539.80$599.55$457.70$141.85$91,397.95$34,565.59
82
73$91,397.95$599.55$456.99$142.56$91,255.39$35,022.58
83
74$91,255.39$599.55$456.28$143.27$91,112.12$35,478.86
84
75$91,112.12$599.55$455.56$143.99$90,968.13$35,934.42
85
76$90,968.13$599.55$454.84$144.71$90,823.42$36,389.26
86
77$90,823.42$599.55$454.12$145.43$90,677.99$36,843.38
87
78$90,677.99$599.55$453.39$146.16$90,531.82$37,296.77
88
79$90,531.82$599.55$452.66$146.89$90,384.93$37,749.42
89
80$90,384.93$599.55$451.92$147.63$90,237.31$38,201.35
90
81$90,237.31$599.55$451.19$148.36$90,088.94$38,652.54
91
82$90,088.94$599.55$450.44$149.11$89,939.84$39,102.98
92
83$89,939.84$599.55$449.70$149.85$89,789.99$39,552.68
93
84$89,789.99$599.55$448.95$150.60$89,639.39$40,001.63
94
85$89,639.39$599.55$448.20$151.35$89,488.03$40,449.83
95
86$89,488.03$599.55$447.44$152.11$89,335.92$40,897.27
96
87$89,335.92$599.55$446.68$152.87$89,183.05$41,343.95
97
88$89,183.05$599.55$445.92$153.64$89,029.42$41,789.86
98
89$89,029.42$599.55$445.15$154.40$88,875.01$42,235.01
99
90$88,875.01$599.55$444.38$155.18$88,719.84$42,679.38
100
91$88,719.84$599.55$443.60$155.95$88,563.89$43,122.98