Mortgage-Blog-Option1
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKL
1
LOAN INFORMATIONSCHEDULED PAYMENTS WITH EXTRA PAYMENTSSAVINGS
2
Loan Amount:$150,000.00Monthly Payment:$1,093.81Total Extra Paid:$47,200.00Interest Savings:$15,182.28
3
Interest Rate:3.790%Scheduled Payments:180Payments Required:123
4
Loan Term (years):15Total Interest:$46,886.29Total Interest:$31,704.01Last Payment Date:October 1, 2028www.debtconsolidationloan.com
5
First Payment Date:08/01/18Total Payments:$196,886.29Total Payments:$181,704.01Payments Eliminated:57
6
Mortgage Interest Savings Calculator - THIS SPREADSHEET IS TO BE USED AS AN INFORMATIVE GUIDE ONLY! - (For instructions on its use, see the 'READ ME FIRST' sheet.)
7
Like this calculator? Please tell others.
8
This version is optimized for Google Spreadsheet. © 2012 - DebtConsolidationLoan.com
9
Payment #Payment DateBalance After PaymentMonthly InterestPayment DuePrincipal ReductionExtra PaymentPayoff AmountTotal Interest PaidTotal Payments
10
1August 1, 2018$149,379.94$473.75$1,093.81$620.06$150,473.75$473.75$1,093.81
11
2September 1, 2018$148,757.92$471.79$1,093.81$622.02$149,851.73$945.54$2,187.63
12
3October 1, 2018$148,133.93$469.83$1,093.81$623.99$149,227.74$1,415.37$3,281.44
13
4November 1, 2018$147,507.97$467.86$1,093.81$625.96$148,601.79$1,883.23$4,375.25
14
5December 1, 2018$146,880.04$465.88$1,093.81$627.93$147,973.85$2,349.10$5,469.06
15
6January 1, 2019$145,850.12$463.90$1,093.81$1,029.92$400.00$147,343.94$2,813.00$6,962.88
16
7February 1, 2019$144,816.95$460.64$1,093.81$1,033.17$400.00$146,310.77$3,273.64$8,456.69
17
8March 1, 2019$143,780.52$457.38$1,093.81$1,036.43$400.00$145,274.33$3,731.02$9,950.50
18
9April 1, 2019$142,740.82$454.11$1,093.81$1,039.71$400.00$144,234.63$4,185.13$11,444.31
19
10May 1, 2019$142,097.83$450.82$1,093.81$642.99$143,191.64$4,635.95$12,538.13
20
11June 1, 2019$141,452.81$448.79$1,093.81$645.02$142,546.62$5,084.75$13,631.94
21
12July 1, 2019$140,805.75$446.76$1,093.81$647.06$141,899.56$5,531.50$14,725.75
22
13August 1, 2019$140,156.65$444.71$1,093.81$649.10$141,250.46$5,976.21$15,819.57
23
14September 1, 2019$139,505.50$442.66$1,093.81$651.15$140,599.31$6,418.87$16,913.38
24
15October 1, 2019$138,852.29$440.60$1,093.81$653.21$139,946.10$6,859.48$18,007.19
25
16November 1, 2019$138,197.02$438.54$1,093.81$655.27$139,290.83$7,298.02$19,101.00
26
17December 1, 2019$137,539.68$436.47$1,093.81$657.34$138,633.49$7,734.49$20,194.82
27
18January 1, 2020$136,880.26$434.40$1,093.81$659.42$137,974.07$8,168.89$21,288.63
28
19February 1, 2020$132,218.76$432.31$1,093.81$4,661.50$4,000.00$137,312.57$8,601.20$26,382.44
29
20March 1, 2020$131,142.54$417.59$1,093.81$1,076.22$400.00$132,636.35$9,018.79$27,876.25
30
21April 1, 2020$130,062.92$414.19$1,093.81$1,079.62$400.00$131,556.73$9,432.99$29,370.07
31
22May 1, 2020$128,979.89$410.78$1,093.81$1,083.03$400.00$130,473.70$9,843.77$30,863.88
32
23June 1, 2020$127,893.44$407.36$1,093.81$1,086.45$400.00$129,387.25$10,251.13$32,357.69
33
24July 1, 2020$126,803.55$403.93$1,093.81$1,089.88$400.00$128,297.37$10,655.06$33,851.51
34
25August 1, 2020$125,710.23$400.49$1,093.81$1,093.32$400.00$127,204.04$11,055.55$35,345.32
35
26September 1, 2020$124,613.45$397.03$1,093.81$1,096.78$400.00$126,107.26$11,452.58$36,839.13
36
27October 1, 2020$123,513.21$393.57$1,093.81$1,100.24$400.00$125,007.02$11,846.15$38,332.94
37
28November 1, 2020$122,409.49$390.10$1,093.81$1,103.72$400.00$123,903.30$12,236.25$39,826.76
38
29December 1, 2020$121,302.29$386.61$1,093.81$1,107.20$400.00$122,796.10$12,622.86$41,320.57
39
30January 1, 2021$120,191.59$383.11$1,093.81$1,110.70$400.00$121,685.40$13,005.97$42,814.38
40
31February 1, 2021$119,077.38$379.61$1,093.81$1,114.21$400.00$120,571.19$13,385.58$44,308.20
41
32March 1, 2021$117,959.66$376.09$1,093.81$1,117.73$400.00$119,453.47$13,761.66$45,802.01
42
33April 1, 2021$116,838.40$372.56$1,093.81$1,121.26$400.00$118,332.21$14,134.22$47,295.82
43
34May 1, 2021$115,713.60$369.01$1,093.81$1,124.80$400.00$117,207.41$14,503.23$48,789.63
44
35June 1, 2021$114,585.25$365.46$1,093.81$1,128.35$400.00$116,079.06$14,868.70$50,283.45
45
36July 1, 2021$113,453.34$361.90$1,093.81$1,131.91$400.00$114,947.15$15,230.59$51,777.26
46
37August 1, 2021$112,317.85$358.32$1,093.81$1,135.49$400.00$113,811.66$15,588.92$53,271.07
47
38September 1, 2021$111,178.77$354.74$1,093.81$1,139.08$400.00$112,672.58$15,943.65$54,764.88
48
39October 1, 2021$110,036.10$351.14$1,093.81$1,142.67$400.00$111,529.91$16,294.79$56,258.70
49
40November 1, 2021$108,889.82$347.53$1,093.81$1,146.28$400.00$110,383.63$16,642.32$57,752.51
50
41December 1, 2021$107,739.91$343.91$1,093.81$1,149.90$400.00$109,233.73$16,986.24$59,246.32
51
42January 1, 2022$106,586.38$340.28$1,093.81$1,153.53$400.00$108,080.19$17,326.51$60,740.14
52
43February 1, 2022$105,429.20$336.64$1,093.81$1,157.18$400.00$106,923.01$17,663.15$62,233.95
53
44March 1, 2022$104,268.37$332.98$1,093.81$1,160.83$400.00$105,762.18$17,996.13$63,727.76
54
45April 1, 2022$103,103.87$329.31$1,093.81$1,164.50$400.00$104,597.68$18,325.44$65,221.57
55
46May 1, 2022$101,935.69$325.64$1,093.81$1,168.18$400.00$103,429.51$18,651.08$66,715.39
56
47June 1, 2022$100,763.83$321.95$1,093.81$1,171.87$400.00$102,257.64$18,973.03$68,209.20
57
48July 1, 2022$99,588.26$318.25$1,093.81$1,175.57$400.00$101,082.07$19,291.27$69,703.01
58
49August 1, 2022$98,408.98$314.53$1,093.81$1,179.28$400.00$99,902.79$19,605.81$71,196.82
59
50September 1, 2022$97,225.98$310.81$1,093.81$1,183.00$400.00$98,719.79$19,916.61$72,690.64
60
51October 1, 2022$96,039.24$307.07$1,093.81$1,186.74$400.00$97,533.05$20,223.69$74,184.45
61
52November 1, 2022$94,848.75$303.32$1,093.81$1,190.49$400.00$96,342.56$20,527.01$75,678.26
62
53December 1, 2022$93,654.50$299.56$1,093.81$1,194.25$400.00$95,148.31$20,826.57$77,172.08
63
54January 1, 2023$92,456.48$295.79$1,093.81$1,198.02$400.00$93,950.29$21,122.37$78,665.89
64
55February 1, 2023$91,254.67$292.01$1,093.81$1,201.80$400.00$92,748.49$21,414.37$80,159.70
65
56March 1, 2023$90,049.07$288.21$1,093.81$1,205.60$400.00$91,542.89$21,702.59$81,653.51
66
57April 1, 2023$88,839.67$284.40$1,093.81$1,209.41$400.00$90,333.48$21,986.99$83,147.33
67
58May 1, 2023$87,626.44$280.59$1,093.81$1,213.23$400.00$89,120.25$22,267.58$84,641.14
68
59June 1, 2023$86,409.38$276.75$1,093.81$1,217.06$400.00$87,903.19$22,544.33$86,134.95
69
60July 1, 2023$85,188.48$272.91$1,093.81$1,220.90$400.00$86,682.29$22,817.24$87,628.76
70
61August 1, 2023$83,963.72$269.05$1,093.81$1,224.76$400.00$85,457.53$23,086.29$89,122.58
71
62September 1, 2023$82,735.09$265.19$1,093.81$1,228.63$400.00$84,228.90$23,351.48$90,616.39
72
63October 1, 2023$81,502.58$261.30$1,093.81$1,232.51$400.00$82,996.39$23,612.78$92,110.20
73
64November 1, 2023$80,266.18$257.41$1,093.81$1,236.40$400.00$81,759.99$23,870.20$93,604.02
74
65December 1, 2023$79,025.88$253.51$1,093.81$1,240.31$400.00$80,519.69$24,123.70$95,097.83
75
66January 1, 2024$77,781.65$249.59$1,093.81$1,244.22$400.00$79,275.47$24,373.29$96,591.64
76
67February 1, 2024$76,533.50$245.66$1,093.81$1,248.15$400.00$78,027.31$24,618.95$98,085.45
77
68March 1, 2024$75,281.41$241.72$1,093.81$1,252.09$400.00$76,775.22$24,860.67$99,579.27
78
69April 1, 2024$74,025.36$237.76$1,093.81$1,256.05$400.00$75,519.17$25,098.44$101,073.08
79
70May 1, 2024$72,765.34$233.80$1,093.81$1,260.02$400.00$74,259.15$25,332.23$102,566.89
80
71June 1, 2024$71,501.35$229.82$1,093.81$1,264.00$400.00$72,995.16$25,562.05$104,060.70
81
72July 1, 2024$70,233.36$225.83$1,093.81$1,267.99$400.00$71,727.17$25,787.88$105,554.52
82
73August 1, 2024$68,961.37$221.82$1,093.81$1,271.99$400.00$70,455.18$26,009.70$107,048.33
83
74September 1, 2024$67,685.36$217.80$1,093.81$1,276.01$400.00$69,179.17$26,227.50$108,542.14
84
75October 1, 2024$66,405.32$213.77$1,093.81$1,280.04$400.00$67,899.13$26,441.27$110,035.96
85
76November 1, 2024$65,121.23$209.73$1,093.81$1,284.08$400.00$66,615.05$26,651.00$111,529.77
86
77December 1, 2024$63,833.10$205.67$1,093.81$1,288.14$400.00$65,326.91$26,856.68$113,023.58
87
78January 1, 2025$62,540.89$201.61$1,093.81$1,292.21$400.00$64,034.70$27,058.28$114,517.39
88
79February 1, 2025$61,244.60$197.52$1,093.81$1,296.29$400.00$62,738.41$27,255.81$116,011.21
89
80March 1, 2025$59,944.22$193.43$1,093.81$1,300.38$400.00$61,438.03$27,449.24$117,505.02
90
81April 1, 2025$58,639.73$189.32$1,093.81$1,304.49$400.00$60,133.54$27,638.56$118,998.83
91
82May 1, 2025$57,331.12$185.20$1,093.81$1,308.61$400.00$58,824.93$27,823.77$120,492.64
92
83June 1, 2025$56,018.38$181.07$1,093.81$1,312.74$400.00$57,512.19$28,004.84$121,986.46
93
84July 1, 2025$54,701.49$176.92$1,093.81$1,316.89$400.00$56,195.30$28,181.76$123,480.27
94
85August 1, 2025$53,380.44$172.77$1,093.81$1,321.05$400.00$54,874.26$28,354.53$124,974.08
95
86September 1, 2025$52,055.22$168.59$1,093.81$1,325.22$400.00$53,549.04$28,523.12$126,467.90
96
87October 1, 2025$50,725.82$164.41$1,093.81$1,329.40$400.00$52,219.63$28,687.53$127,961.71
97
88November 1, 2025$49,392.22$160.21$1,093.81$1,333.60$400.00$50,886.03$28,847.74$129,455.52
98
89December 1, 2025$48,054.40$156.00$1,093.81$1,337.82$400.00$49,548.21$29,003.73$130,949.33
99
90January 1, 2026$46,712.36$151.77$1,093.81$1,342.04$400.00$48,206.17$29,155.51$132,443.15
100
91February 1, 2026$45,366.08$147.53$1,093.81$1,346.28$400.00$46,859.89$29,303.04$133,936.96
Loading...
Main menu