Simple Loan Calculator: Loan Values Loan Summary

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 11

Simple Loan Calculator

Loan Values Loan Summary


Loan amount $10,000.00 Monthly payment $108.53

Annual interest rate 5.50% Number of payments 120

Loan period in years 10 Total interest $3,023.15

Start date of loan 4/19/2021 Total cost of loan $13,023.15

Pmt Beginning
Payment Date Payment Principal Interest Ending Balance
No. Balance
1 5/19/2021 $10,000.00 $108.53 $62.69 $45.83 $9,937.31
2 6/19/2021 $9,937.31 $108.53 $62.98 $45.55 $9,874.33
3 7/19/2021 $9,874.33 $108.53 $63.27 $45.26 $9,811.06
4 8/19/2021 $9,811.06 $108.53 $63.56 $44.97 $9,747.50
5 9/19/2021 $9,747.50 $108.53 $63.85 $44.68 $9,683.65
6 10/19/2021 $9,683.65 $108.53 $64.14 $44.38 $9,619.51
7 11/19/2021 $9,619.51 $108.53 $64.44 $44.09 $9,555.07
8 12/19/2021 $9,555.07 $108.53 $64.73 $43.79 $9,490.34
9 1/19/2022 $9,490.34 $108.53 $65.03 $43.50 $9,425.31
10 2/19/2022 $9,425.31 $108.53 $65.33 $43.20 $9,359.98
11 3/19/2022 $9,359.98 $108.53 $65.63 $42.90 $9,294.35
12 4/19/2022 $9,294.35 $108.53 $65.93 $42.60 $9,228.43
13 5/19/2022 $9,228.43 $108.53 $66.23 $42.30 $9,162.20
14 6/19/2022 $9,162.20 $108.53 $66.53 $41.99 $9,095.67
15 7/19/2022 $9,095.67 $108.53 $66.84 $41.69 $9,028.83
16 8/19/2022 $9,028.83 $108.53 $67.14 $41.38 $8,961.68
17 9/19/2022 $8,961.68 $108.53 $67.45 $41.07 $8,894.23
18 10/19/2022 $8,894.23 $108.53 $67.76 $40.77 $8,826.47
19 11/19/2022 $8,826.47 $108.53 $68.07 $40.45 $8,758.40
20 12/19/2022 $8,758.40 $108.53 $68.38 $40.14 $8,690.01
21 1/19/2023 $8,690.01 $108.53 $68.70 $39.83 $8,621.32
22 2/19/2023 $8,621.32 $108.53 $69.01 $39.51 $8,552.31
23 3/19/2023 $8,552.31 $108.53 $69.33 $39.20 $8,482.98
24 4/19/2023 $8,482.98 $108.53 $69.65 $38.88 $8,413.33
25 5/19/2023 $8,413.33 $108.53 $69.97 $38.56 $8,343.37
26 6/19/2023 $8,343.37 $108.53 $70.29 $38.24 $8,273.08

Page 1 of 11
Pmt Beginning
Payment Date Payment Principal Interest Ending Balance
No. Balance
27 7/19/2023 $8,273.08 $108.53 $70.61 $37.92 $8,202.47
28 8/19/2023 $8,202.47 $108.53 $70.93 $37.59 $8,131.54
29 9/19/2023 $8,131.54 $108.53 $71.26 $37.27 $8,060.28
30 10/19/2023 $8,060.28 $108.53 $71.58 $36.94 $7,988.70
31 11/19/2023 $7,988.70 $108.53 $71.91 $36.61 $7,916.79
32 12/19/2023 $7,916.79 $108.53 $72.24 $36.29 $7,844.55
33 1/19/2024 $7,844.55 $108.53 $72.57 $35.95 $7,771.98
34 2/19/2024 $7,771.98 $108.53 $72.90 $35.62 $7,699.07
35 3/19/2024 $7,699.07 $108.53 $73.24 $35.29 $7,625.83
36 4/19/2024 $7,625.83 $108.53 $73.57 $34.95 $7,552.26
37 5/19/2024 $7,552.26 $108.53 $73.91 $34.61 $7,478.35
38 6/19/2024 $7,478.35 $108.53 $74.25 $34.28 $7,404.10
39 7/19/2024 $7,404.10 $108.53 $74.59 $33.94 $7,329.51
40 8/19/2024 $7,329.51 $108.53 $74.93 $33.59 $7,254.57
41 9/19/2024 $7,254.57 $108.53 $75.28 $33.25 $7,179.30
42 10/19/2024 $7,179.30 $108.53 $75.62 $32.91 $7,103.68
43 11/19/2024 $7,103.68 $108.53 $75.97 $32.56 $7,027.71
44 12/19/2024 $7,027.71 $108.53 $76.32 $32.21 $6,951.39
45 1/19/2025 $6,951.39 $108.53 $76.67 $31.86 $6,874.73
46 2/19/2025 $6,874.73 $108.53 $77.02 $31.51 $6,797.71
47 3/19/2025 $6,797.71 $108.53 $77.37 $31.16 $6,720.34
48 4/19/2025 $6,720.34 $108.53 $77.72 $30.80 $6,642.61
49 5/19/2025 $6,642.61 $108.53 $78.08 $30.45 $6,564.53
50 6/19/2025 $6,564.53 $108.53 $78.44 $30.09 $6,486.09
51 7/19/2025 $6,486.09 $108.53 $78.80 $29.73 $6,407.30
52 8/19/2025 $6,407.30 $108.53 $79.16 $29.37 $6,328.14
53 9/19/2025 $6,328.14 $108.53 $79.52 $29.00 $6,248.61
54 10/19/2025 $6,248.61 $108.53 $79.89 $28.64 $6,168.73
55 11/19/2025 $6,168.73 $108.53 $80.25 $28.27 $6,088.47
56 12/19/2025 $6,088.47 $108.53 $80.62 $27.91 $6,007.85
57 1/19/2026 $6,007.85 $108.53 $80.99 $27.54 $5,926.86
58 2/19/2026 $5,926.86 $108.53 $81.36 $27.16 $5,845.50
59 3/19/2026 $5,845.50 $108.53 $81.73 $26.79 $5,763.77
60 4/19/2026 $5,763.77 $108.53 $82.11 $26.42 $5,681.66
61 5/19/2026 $5,681.66 $108.53 $82.49 $26.04 $5,599.17

Page 2 of 11
Pmt Beginning
Payment Date Payment Principal Interest Ending Balance
No. Balance
62 6/19/2026 $5,599.17 $108.53 $82.86 $25.66 $5,516.31
63 7/19/2026 $5,516.31 $108.53 $83.24 $25.28 $5,433.07
64 8/19/2026 $5,433.07 $108.53 $83.62 $24.90 $5,349.44
65 9/19/2026 $5,349.44 $108.53 $84.01 $24.52 $5,265.43
66 10/19/2026 $5,265.43 $108.53 $84.39 $24.13 $5,181.04
67 11/19/2026 $5,181.04 $108.53 $84.78 $23.75 $5,096.26
68 12/19/2026 $5,096.26 $108.53 $85.17 $23.36 $5,011.09
69 1/19/2027 $5,011.09 $108.53 $85.56 $22.97 $4,925.53
70 2/19/2027 $4,925.53 $108.53 $85.95 $22.58 $4,839.58
71 3/19/2027 $4,839.58 $108.53 $86.34 $22.18 $4,753.24
72 4/19/2027 $4,753.24 $108.53 $86.74 $21.79 $4,666.50
73 5/19/2027 $4,666.50 $108.53 $87.14 $21.39 $4,579.36
74 6/19/2027 $4,579.36 $108.53 $87.54 $20.99 $4,491.82
75 7/19/2027 $4,491.82 $108.53 $87.94 $20.59 $4,403.88
76 8/19/2027 $4,403.88 $108.53 $88.34 $20.18 $4,315.54
77 9/19/2027 $4,315.54 $108.53 $88.75 $19.78 $4,226.79
78 10/19/2027 $4,226.79 $108.53 $89.15 $19.37 $4,137.64
79 11/19/2027 $4,137.64 $108.53 $89.56 $18.96 $4,048.08
80 12/19/2027 $4,048.08 $108.53 $89.97 $18.55 $3,958.11
81 1/19/2028 $3,958.11 $108.53 $90.38 $18.14 $3,867.72
82 2/19/2028 $3,867.72 $108.53 $90.80 $17.73 $3,776.92
83 3/19/2028 $3,776.92 $108.53 $91.22 $17.31 $3,685.71
84 4/19/2028 $3,685.71 $108.53 $91.63 $16.89 $3,594.07
85 5/19/2028 $3,594.07 $108.53 $92.05 $16.47 $3,502.02
86 6/19/2028 $3,502.02 $108.53 $92.48 $16.05 $3,409.54
87 7/19/2028 $3,409.54 $108.53 $92.90 $15.63 $3,316.65
88 8/19/2028 $3,316.65 $108.53 $93.32 $15.20 $3,223.32
89 9/19/2028 $3,223.32 $108.53 $93.75 $14.77 $3,129.57
90 10/19/2028 $3,129.57 $108.53 $94.18 $14.34 $3,035.38
91 11/19/2028 $3,035.38 $108.53 $94.61 $13.91 $2,940.77
92 12/19/2028 $2,940.77 $108.53 $95.05 $13.48 $2,845.72
93 1/19/2029 $2,845.72 $108.53 $95.48 $13.04 $2,750.24
94 2/19/2029 $2,750.24 $108.53 $95.92 $12.61 $2,654.32
95 3/19/2029 $2,654.32 $108.53 $96.36 $12.17 $2,557.96
96 4/19/2029 $2,557.96 $108.53 $96.80 $11.72 $2,461.16

Page 3 of 11
Pmt Beginning
Payment Date Payment Principal Interest Ending Balance
No. Balance
97 5/19/2029 $2,461.16 $108.53 $97.25 $11.28 $2,363.91
98 6/19/2029 $2,363.91 $108.53 $97.69 $10.83 $2,266.22
99 7/19/2029 $2,266.22 $108.53 $98.14 $10.39 $2,168.08
100 8/19/2029 $2,168.08 $108.53 $98.59 $9.94 $2,069.49
101 9/19/2029 $2,069.49 $108.53 $99.04 $9.49 $1,970.45
102 10/19/2029 $1,970.45 $108.53 $99.50 $9.03 $1,870.95
103 11/19/2029 $1,870.95 $108.53 $99.95 $8.58 $1,771.00
104 12/19/2029 $1,771.00 $108.53 $100.41 $8.12 $1,670.59
105 1/19/2030 $1,670.59 $108.53 $100.87 $7.66 $1,569.72
106 2/19/2030 $1,569.72 $108.53 $101.33 $7.19 $1,468.39
107 3/19/2030 $1,468.39 $108.53 $101.80 $6.73 $1,366.60
108 4/19/2030 $1,366.60 $108.53 $102.26 $6.26 $1,264.33
109 5/19/2030 $1,264.33 $108.53 $102.73 $5.79 $1,161.60
110 6/19/2030 $1,161.60 $108.53 $103.20 $5.32 $1,058.40
111 7/19/2030 $1,058.40 $108.53 $103.68 $4.85 $954.72
112 8/19/2030 $954.72 $108.53 $104.15 $4.38 $850.57
113 9/19/2030 $850.57 $108.53 $104.63 $3.90 $745.95
114 10/19/2030 $745.95 $108.53 $105.11 $3.42 $640.84
115 11/19/2030 $640.84 $108.53 $105.59 $2.94 $535.25
116 12/19/2030 $535.25 $108.53 $106.07 $2.45 $429.18
117 1/19/2031 $429.18 $108.53 $106.56 $1.97 $322.62
118 2/19/2031 $322.62 $108.53 $107.05 $1.48 $215.57
119 3/19/2031 $215.57 $108.53 $107.54 $0.99 $108.03
120 4/19/2031 $108.03 $108.53 $108.03 $0.50 $0.00

Page 4 of 11
Pmt Beginning
Payment Date Payment Principal Interest Ending Balance
No. Balance

Page 5 of 11
Pmt Beginning
Payment Date Payment Principal Interest Ending Balance
No. Balance

Page 6 of 11
Pmt Beginning
Payment Date Payment Principal Interest Ending Balance
No. Balance

Page 7 of 11
Pmt Beginning
Payment Date Payment Principal Interest Ending Balance
No. Balance

Page 8 of 11
Pmt Beginning
Payment Date Payment Principal Interest Ending Balance
No. Balance

Page 9 of 11
Pmt Beginning
Payment Date Payment Principal Interest Ending Balance
No. Balance

Page 10 of 11
Pmt Beginning
Payment Date Payment Principal Interest Ending Balance
No. Balance

Page 11 of 11

You might also like