0% found this document useful (0 votes)
171 views28 pages

Simple Interest Loan Calculator

Uploaded by

Si Thu Win
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
171 views28 pages

Simple Interest Loan Calculator

Uploaded by

Si Thu Win
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 28

Simple Interest Loan Calculator Using This Worksheet

http://www.vertex42.com/Calculators/simple-interest-loan.html © 2008-2023 Vertex42 LLC This calculator can be used to estimate an


amortization schedule for a Simple Interest Loan or
Loan Information [42] Summary Simple Interest Mortgage, in which the interest 3% 4,500,000.00
accrues daily in a separate interest accrual account.
Loan Amount 150,000,000.00 Daily Interest Rate 0.0250000% The main reason this calculator only provides an
Annual Interest Rate 9.00% Number of Payments 180 estimate is because it assumes that the payments
Term of Loan in Years 15 Total Payments 275,613,473.06 are posted to your account exactly on the days
listed. In reality, that may not be the case, which is
First Day Interest Accrues 4/1/2016 Total Interest 125,613,473.06 why the Payment worksheet is set up for you to track
First Payment Date 5/1/2016 Balloon Payment - your actual payments. You can experiment with
Payment Frequency Monthly . choosing different extra payments to see how that
affects the total interest paid.
Days in Year 360
Balloon Payment #
Rounding On 1

Est. Monthly Payment $ 1,535,587.49 (estimate)


Actual Monthly Payment 0

Amortization Schedule
Pmt Interest Interest Principal Total
No. Date Payment Accrued Balance Balance Owed
3/31/16 $ 150,000,000 $ 150,000,000
1 5/1/16 1,535,587.49 1,162,500.00 0.00 149,626,912.51 149,626,912.51
2 6/1/16 1,535,587.49 1,159,608.57 0.00 149,250,933.59 149,250,933.59
3 7/1/16 1,535,587.49 1,119,382.00 0.00 148,834,728.10 148,834,728.10
4 8/1/16 1,535,587.49 1,153,469.14 0.00 148,452,609.75 148,452,609.75
5 9/1/16 1,535,587.49 1,150,507.73 0.00 148,067,529.99 148,067,529.99
6 10/1/16 1,535,587.49 1,110,506.47 0.00 147,642,448.97 147,642,448.97
7 11/1/16 1,535,587.49 1,144,228.98 0.00 147,251,090.46 147,251,090.46
8 12/1/16 1,535,587.49 1,104,383.18 0.00 146,819,886.15 146,819,886.15
9 1/1/17 1,535,587.49 1,137,854.12 0.00 146,422,152.78 146,422,152.78
10 2/1/17 1,535,587.49 1,134,771.68 0.00 146,021,336.97 146,021,336.97
11 3/1/17 1,535,587.49 1,022,149.36 0.00 145,507,898.84 145,507,898.84
12 4/1/17 1,535,587.49 1,127,686.22 0.00 145,099,997.57 145,099,997.57
13 5/1/17 1,535,587.49 1,088,249.98 0.00 144,652,660.06 144,652,660.06
14 6/1/17 1,535,587.49 1,121,058.12 0.00 144,238,130.69 144,238,130.69
15 7/1/17 1,535,587.49 1,081,785.98 0.00 143,784,329.18 143,784,329.18
16 8/1/17 1,535,587.49 1,114,328.55 0.00 143,363,070.24 143,363,070.24
17 9/1/17 1,535,587.49 1,111,063.79 0.00 142,938,546.54 142,938,546.54
18 10/1/17 1,535,587.49 1,072,039.10 0.00 142,474,998.15 142,474,998.15
19 11/1/17 1,535,587.49 1,104,181.24 0.00 142,043,591.90 142,043,591.90
20 12/1/17 1,535,587.49 1,065,326.94 0.00 141,573,331.35 141,573,331.35
21 1/1/18 1,535,587.49 1,097,193.32 0.00 141,134,937.18 141,134,937.18
22 2/1/18 1,535,587.49 1,093,795.76 0.00 140,693,145.45 140,693,145.45
23 3/1/18 1,535,587.49 984,852.02 0.00 140,142,409.98 140,142,409.98
24 4/1/18 1,535,587.49 1,086,103.68 0.00 139,692,926.17 139,692,926.17
25 5/1/18 1,535,587.49 1,047,696.95 0.00 139,205,035.63 139,205,035.63
26 6/1/18 1,535,587.49 1,078,839.03 0.00 138,748,287.17 138,748,287.17
27 7/1/18 1,535,587.49 1,040,612.15 0.00 138,253,311.83 138,253,311.83
28 8/1/18 1,535,587.49 1,071,463.17 0.00 137,789,187.51 137,789,187.51
29 9/1/18 1,535,587.49 1,067,866.20 0.00 137,321,466.22 137,321,466.22
30 10/1/18 1,535,587.49 1,029,911.00 0.00 136,815,789.73 136,815,789.73
31 11/1/18 1,535,587.49 1,060,322.37 0.00 136,340,524.61 136,340,524.61
32 12/1/18 1,535,587.49 1,022,553.93 0.00 135,827,491.05 135,827,491.05
33 1/1/19 1,535,587.49 1,052,663.06 0.00 135,344,566.62 135,344,566.62
34 2/1/19 1,535,587.49 1,048,920.39 0.00 134,857,899.52 134,857,899.52
35 3/1/19 1,535,587.49 944,005.30 0.00 134,266,317.33 134,266,317.33
36 4/1/19 1,535,587.49 1,040,563.96 0.00 133,771,293.80 133,771,293.80
37 5/1/19 1,535,587.49 1,003,284.70 0.00 133,238,991.01 133,238,991.01
38 6/1/19 1,535,587.49 1,032,602.18 0.00 132,736,005.70 132,736,005.70
39 7/1/19 1,535,587.49 995,520.04 0.00 132,195,938.25 132,195,938.25
40 8/1/19 1,535,587.49 1,024,518.52 0.00 131,684,869.28 131,684,869.28
41 9/1/19 1,535,587.49 1,020,557.74 0.00 131,169,839.53 131,169,839.53
42 10/1/19 1,535,587.49 983,773.80 0.00 130,618,025.84 130,618,025.84
43 11/1/19 1,535,587.49 1,012,289.70 0.00 130,094,728.05 130,094,728.05
44 12/1/19 1,535,587.49 975,710.46 0.00 129,534,851.02 129,534,851.02
45 1/1/20 1,535,587.49 1,003,895.10 0.00 129,003,158.63 129,003,158.63
46 2/1/20 1,535,587.49 999,774.48 0.00 128,467,345.62 128,467,345.62
47 3/1/20 1,535,587.49 931,388.26 0.00 127,863,146.39 127,863,146.39
48 4/1/20 1,535,587.49 990,939.38 0.00 127,318,498.28 127,318,498.28
49 5/1/20 1,535,587.49 954,888.74 0.00 126,737,799.53 126,737,799.53
50 6/1/20 1,535,587.49 982,217.95 0.00 126,184,429.99 126,184,429.99
51 7/1/20 1,535,587.49 946,383.22 0.00 125,595,225.72 125,595,225.72
52 8/1/20 1,535,587.49 973,363.00 0.00 125,033,001.23 125,033,001.23
53 9/1/20 1,535,587.49 969,005.76 0.00 124,466,419.50 124,466,419.50
54 10/1/20 1,535,587.49 933,498.15 0.00 123,864,330.16 123,864,330.16
55 11/1/20 1,535,587.49 959,948.56 0.00 123,288,691.23 123,288,691.23
56 12/1/20 1,535,587.49 924,665.18 0.00 122,677,768.92 122,677,768.92
57 1/1/21 1,535,587.49 950,752.71 0.00 122,092,934.14 122,092,934.14
58 2/1/21 1,535,587.49 946,220.24 0.00 121,503,566.89 121,503,566.89
59 3/1/21 1,535,587.49 850,524.97 0.00 120,818,504.37 120,818,504.37
60 4/1/21 1,535,587.49 936,343.41 0.00 120,219,260.29 120,219,260.29
61 5/1/21 1,535,587.49 901,644.45 0.00 119,585,317.25 119,585,317.25
62 6/1/21 1,535,587.49 926,786.21 0.00 118,976,515.97 118,976,515.97
63 7/1/21 1,535,587.49 892,323.87 0.00 118,333,252.35 118,333,252.35
64 8/1/21 1,535,587.49 917,082.71 0.00 117,714,747.57 117,714,747.57
65 9/1/21 1,535,587.49 912,289.29 0.00 117,091,449.37 117,091,449.37
66 10/1/21 1,535,587.49 878,185.87 0.00 116,434,047.75 116,434,047.75
67 11/1/21 1,535,587.49 902,363.87 0.00 115,800,824.13 115,800,824.13
68 12/1/21 1,535,587.49 868,506.18 0.00 115,133,742.82 115,133,742.82
69 1/1/22 1,535,587.49 892,286.51 0.00 114,490,441.84 114,490,441.84
70 2/1/22 1,535,587.49 887,300.92 0.00 113,842,155.27 113,842,155.27
71 3/1/22 1,535,587.49 796,895.09 0.00 113,103,462.87 113,103,462.87
72 4/1/22 1,535,587.49 876,551.84 0.00 112,444,427.22 112,444,427.22
73 5/1/22 1,535,587.49 843,333.20 0.00 111,752,172.93 111,752,172.93
74 6/1/22 1,535,587.49 866,079.34 0.00 111,082,664.78 111,082,664.78
75 7/1/22 1,535,587.49 833,119.99 0.00 110,380,197.28 110,380,197.28
76 8/1/22 1,535,587.49 855,446.53 0.00 109,700,056.32 109,700,056.32
77 9/1/22 1,535,587.49 850,175.44 0.00 109,014,644.27 109,014,644.27
78 10/1/22 1,535,587.49 817,609.83 0.00 108,296,666.61 108,296,666.61
79 11/1/22 1,535,587.49 839,299.17 0.00 107,600,378.29 107,600,378.29
80 12/1/22 1,535,587.49 807,002.84 0.00 106,871,793.64 106,871,793.64
81 1/1/23 1,535,587.49 828,256.40 0.00 106,164,462.55 106,164,462.55
82 2/1/23 1,535,587.49 822,774.58 0.00 105,451,649.64 105,451,649.64

Page 1 of 28
Pmt Interest Interest Principal Total
No. Date Payment Accrued Balance Balance Owed
83 3/1/23 1,535,587.49 738,161.55 0.00 104,654,223.70 104,654,223.70
84 4/1/23 1,535,587.49 811,070.23 0.00 103,929,706.44 103,929,706.44
85 5/1/23 1,535,587.49 779,472.80 0.00 103,173,591.75 103,173,591.75
86 6/1/23 1,535,587.49 799,595.34 0.00 102,437,599.60 102,437,599.60
87 7/1/23 1,535,587.49 768,282.00 0.00 101,670,294.11 101,670,294.11
88 8/1/23 1,535,587.49 787,944.78 0.00 100,922,651.40 100,922,651.40
89 9/1/23 1,535,587.49 782,150.55 0.00 100,169,214.46 100,169,214.46
90 10/1/23 1,535,587.49 751,269.11 0.00 99,384,896.08 99,384,896.08
91 11/1/23 1,535,587.49 770,232.94 0.00 98,619,541.53 98,619,541.53
92 12/1/23 1,535,587.49 739,646.56 0.00 97,823,600.60 97,823,600.60
93 1/1/24 1,535,587.49 758,132.90 0.00 97,046,146.01 97,046,146.01
94 2/1/24 1,535,587.49 752,107.63 0.00 96,262,666.15 96,262,666.15
95 3/1/24 1,535,587.49 697,904.33 0.00 95,424,982.99 95,424,982.99
96 4/1/24 1,535,587.49 739,543.62 0.00 94,628,939.12 94,628,939.12
97 5/1/24 1,535,587.49 709,717.04 0.00 93,803,068.67 93,803,068.67
98 6/1/24 1,535,587.49 726,973.78 0.00 92,994,454.96 92,994,454.96
99 7/1/24 1,535,587.49 697,458.41 0.00 92,156,325.88 92,156,325.88
100 8/1/24 1,535,587.49 714,211.53 0.00 91,334,949.92 91,334,949.92
101 9/1/24 1,535,587.49 707,845.86 0.00 90,507,208.29 90,507,208.29
102 10/1/24 1,535,587.49 678,804.06 0.00 89,650,424.86 89,650,424.86
103 11/1/24 1,535,587.49 694,790.79 0.00 88,809,628.16 88,809,628.16
104 12/1/24 1,535,587.49 666,072.21 0.00 87,940,112.88 87,940,112.88
105 1/1/25 1,535,587.49 681,535.87 0.00 87,086,061.26 87,086,061.26
106 2/1/25 1,535,587.49 674,916.97 0.00 86,225,390.74 86,225,390.74
107 3/1/25 1,535,587.49 603,577.74 0.00 85,293,380.99 85,293,380.99
108 4/1/25 1,535,587.49 661,023.70 0.00 84,418,817.20 84,418,817.20
109 5/1/25 1,535,587.49 633,141.13 0.00 83,516,370.84 83,516,370.84
110 6/1/25 1,535,587.49 647,251.87 0.00 82,628,035.22 82,628,035.22
111 7/1/25 1,535,587.49 619,710.26 0.00 81,712,157.99 81,712,157.99
112 8/1/25 1,535,587.49 633,269.22 0.00 80,809,839.72 80,809,839.72
113 9/1/25 1,535,587.49 626,276.26 0.00 79,900,528.49 79,900,528.49
114 10/1/25 1,535,587.49 599,253.96 0.00 78,964,194.96 78,964,194.96
115 11/1/25 1,535,587.49 611,972.51 0.00 78,040,579.98 78,040,579.98
116 12/1/25 1,535,587.49 585,304.35 0.00 77,090,296.84 77,090,296.84
117 1/1/26 1,535,587.49 597,449.80 0.00 76,152,159.15 76,152,159.15
118 2/1/26 1,535,587.49 590,179.23 0.00 75,206,750.89 75,206,750.89
119 3/1/26 1,535,587.49 526,447.26 0.00 74,197,610.66 74,197,610.66
120 4/1/26 1,535,587.49 575,031.48 0.00 73,237,054.65 73,237,054.65
121 5/1/26 1,535,587.49 549,277.91 0.00 72,250,745.07 72,250,745.07
122 6/1/26 1,535,587.49 559,943.27 0.00 71,275,100.85 71,275,100.85
123 7/1/26 1,535,587.49 534,563.26 0.00 70,274,076.62 70,274,076.62
124 8/1/26 1,535,587.49 544,624.09 0.00 69,283,113.22 69,283,113.22
125 9/1/26 1,535,587.49 536,944.13 0.00 68,284,469.86 68,284,469.86
126 10/1/26 1,535,587.49 512,133.52 0.00 67,261,015.89 67,261,015.89
127 11/1/26 1,535,587.49 521,272.87 0.00 66,246,701.27 66,246,701.27
128 12/1/26 1,535,587.49 496,850.26 0.00 65,207,964.04 65,207,964.04
129 1/1/27 1,535,587.49 505,361.72 0.00 64,177,738.27 64,177,738.27
130 2/1/27 1,535,587.49 497,377.47 0.00 63,139,528.25 63,139,528.25
131 3/1/27 1,535,587.49 441,976.70 0.00 62,045,917.46 62,045,917.46
132 4/1/27 1,535,587.49 480,855.86 0.00 60,991,185.83 60,991,185.83
133 5/1/27 1,535,587.49 457,433.89 0.00 59,913,032.23 59,913,032.23
134 6/1/27 1,535,587.49 464,326.00 0.00 58,841,770.74 58,841,770.74
135 7/1/27 1,535,587.49 441,313.28 0.00 57,747,496.53 57,747,496.53
136 8/1/27 1,535,587.49 447,543.10 0.00 56,659,452.14 56,659,452.14
137 9/1/27 1,535,587.49 439,110.75 0.00 55,562,975.40 55,562,975.40
138 10/1/27 1,535,587.49 416,722.32 0.00 54,444,110.23 54,444,110.23
139 11/1/27 1,535,587.49 421,941.85 0.00 53,330,464.59 53,330,464.59
140 12/1/27 1,535,587.49 399,978.48 0.00 52,194,855.58 52,194,855.58
141 1/1/28 1,535,587.49 404,510.13 0.00 51,063,778.22 51,063,778.22
142 2/1/28 1,535,587.49 395,744.28 0.00 49,923,935.01 49,923,935.01
143 3/1/28 1,535,587.49 361,948.53 0.00 48,750,296.05 48,750,296.05
144 4/1/28 1,535,587.49 377,814.79 0.00 47,592,523.35 47,592,523.35
145 5/1/28 1,535,587.49 356,943.93 0.00 46,413,879.79 46,413,879.79
146 6/1/28 1,535,587.49 359,707.57 0.00 45,237,999.87 45,237,999.87
147 7/1/28 1,535,587.49 339,285.00 0.00 44,041,697.38 44,041,697.38
148 8/1/28 1,535,587.49 341,323.15 0.00 42,847,433.04 42,847,433.04
149 9/1/28 1,535,587.49 332,067.61 0.00 41,643,913.16 41,643,913.16
150 10/1/28 1,535,587.49 312,329.35 0.00 40,420,655.02 40,420,655.02
151 11/1/28 1,535,587.49 313,260.08 0.00 39,198,327.61 39,198,327.61
152 12/1/28 1,535,587.49 293,987.46 0.00 37,956,727.58 37,956,727.58
153 1/1/29 1,535,587.49 294,164.64 0.00 36,715,304.73 36,715,304.73
154 2/1/29 1,535,587.49 284,543.61 0.00 35,464,260.85 35,464,260.85
155 3/1/29 1,535,587.49 248,249.83 0.00 34,176,923.19 34,176,923.19
156 4/1/29 1,535,587.49 264,871.15 0.00 32,906,206.85 32,906,206.85
157 5/1/29 1,535,587.49 246,796.55 0.00 31,617,415.91 31,617,415.91
158 6/1/29 1,535,587.49 245,034.97 0.00 30,326,863.39 30,326,863.39
159 7/1/29 1,535,587.49 227,451.48 0.00 29,018,727.38 29,018,727.38
160 8/1/29 1,535,587.49 224,895.14 0.00 27,708,035.03 27,708,035.03
161 9/1/29 1,535,587.49 214,737.27 0.00 26,387,184.81 26,387,184.81
162 10/1/29 1,535,587.49 197,903.89 0.00 25,049,501.21 25,049,501.21
163 11/1/29 1,535,587.49 194,133.63 0.00 23,708,047.35 23,708,047.35
164 12/1/29 1,535,587.49 177,810.36 0.00 22,350,270.22 22,350,270.22
165 1/1/30 1,535,587.49 173,214.59 0.00 20,987,897.32 20,987,897.32
166 2/1/30 1,535,587.49 162,656.20 0.00 19,614,966.03 19,614,966.03
167 3/1/30 1,535,587.49 137,304.76 0.00 18,216,683.30 18,216,683.30
168 4/1/30 1,535,587.49 141,179.30 0.00 16,822,275.11 16,822,275.11
169 5/1/30 1,535,587.49 126,167.06 0.00 15,412,854.68 15,412,854.68
170 6/1/30 1,535,587.49 119,449.62 0.00 13,996,716.81 13,996,716.81
171 7/1/30 1,535,587.49 104,975.38 0.00 12,566,104.70 12,566,104.70
172 8/1/30 1,535,587.49 97,387.31 0.00 11,127,904.52 11,127,904.52
173 9/1/30 1,535,587.49 86,241.26 0.00 9,678,558.29 9,678,558.29
174 10/1/30 1,535,587.49 72,589.19 0.00 8,215,559.99 8,215,559.99
175 11/1/30 1,535,587.49 63,670.59 0.00 6,743,643.09 6,743,643.09
176 12/1/30 1,535,587.49 50,577.32 0.00 5,258,632.92 5,258,632.92
177 1/1/31 1,535,587.49 40,754.41 0.00 3,763,799.84 3,763,799.84
178 2/1/31 1,535,587.49 29,169.45 0.00 2,257,381.80 2,257,381.80
179 3/1/31 1,535,587.49 15,801.67 0.00 737,595.98 737,595.98
180 4/1/31 743,312.35 5,716.37 0.00 0.00 0.00

http://www.vertex42.com/Calculators/simple-interest-loan.html Page 2 of 28
Pmt Interest Interest Principal Total
No. Date Payment Accrued Balance Balance Owed

http://www.vertex42.com/Calculators/simple-interest-loan.html Page 3 of 28
Pmt Interest Interest Principal Total
No. Date Payment Accrued Balance Balance Owed

http://www.vertex42.com/Calculators/simple-interest-loan.html Page 4 of 28
Pmt Interest Interest Principal Total
No. Date Payment Accrued Balance Balance Owed

http://www.vertex42.com/Calculators/simple-interest-loan.html Page 5 of 28
Pmt Interest Interest Principal Total
No. Date Payment Accrued Balance Balance Owed

http://www.vertex42.com/Calculators/simple-interest-loan.html Page 6 of 28
Pmt Interest Interest Principal Total
No. Date Payment Accrued Balance Balance Owed

http://www.vertex42.com/Calculators/simple-interest-loan.html Page 7 of 28
Pmt Interest Interest Principal Total
No. Date Payment Accrued Balance Balance Owed

http://www.vertex42.com/Calculators/simple-interest-loan.html Page 8 of 28
Simple Interest Loan Payment Schedule
http://www.vertex42.com/Calculators/simple-interest-loan.html © 2008-2023 Vertex42 LLC

Borrower: [Company Name]


[Address, City, ST ZIP] [Address, City, ST ZIP]
Phone: [Phone] Phone: [Phone]

Loan Information [42] Summary To Date


Loan Amount $ 100,000.00 Daily Interest Rate 0.0166667%
Annual Interest Rate 6.00% # Payments 1
First Day Interest Accrues 1/1/2011 Total Payments $ 3,387.67
Days in Year 360 Total Interest $ 533.33

Payment (for reference) $ 3,387.67

Payment Schedule The Interest Accrued is Rounded

Pmt Interest Interest Principal Total


No. Date Payment Accrued Balance Balance Owed
12/31/10 - - 0.00 100,000.00 100,000.00
1 2/1/11 3,387.67 533.33 0.00 97,145.66 97,145.66
2

http://www.vertex42.com/Calculators/simple-interest-loan.html Page 9 of 28
http://www.vertex42.com/Calculators/simple-interest-loan.html Page 10 of 28
http://www.vertex42.com/Calculators/simple-interest-loan.html Page 11 of 28
http://www.vertex42.com/Calculators/simple-interest-loan.html Page 12 of 28
http://www.vertex42.com/Calculators/simple-interest-loan.html Page 13 of 28
http://www.vertex42.com/Calculators/simple-interest-loan.html Page 14 of 28
http://www.vertex42.com/Calculators/simple-interest-loan.html Page 15 of 28
http://www.vertex42.com/Calculators/simple-interest-loan.html Page 16 of 28
http://www.vertex42.com/Calculators/simple-interest-loan.html Page 17 of 28
http://www.vertex42.com/Calculators/simple-interest-loan.html Page 18 of 28
http://www.vertex42.com/Calculators/simple-interest-loan.html Page 19 of 28
http://www.vertex42.com/Calculators/simple-interest-loan.html Page 20 of 28
http://www.vertex42.com/Calculators/simple-interest-loan.html Page 21 of 28
http://www.vertex42.com/Calculators/simple-interest-loan.html Page 22 of 28
End of Formulas

http://www.vertex42.com/Calculators/simple-interest-loan.html Page 23 of 28
Using This Worksheet
This spreadsheet provides a way to track your actual payments.

1. Look at your contract to fill in the Loan information. To start mid-


stream, enter the current day's Principal Balance in the Loan Amount
field, tomorrow's date in the First Day Interest Accrues field, and enter
your current Interest Balance in cell F14.
2. Enter the date of your payments in column B of the Payment
Schedule and the amount you paid in column C. The date should be
the day the payment is processed.
3. To fully pay off a loan, first enter the date it will be paid off. The
Payment should then be the previous Total Owed amount plus the
current Interest Accrued.

Note: This payment schedule assumes there are no extra penalties or


fees for late payments, missing payments, or prepayments. The
payment is first applied to the interest accrued, then the previous
interest balance. Anything left over is applied to the principal.

Enter the payment date and the payment amount in the yellow fields.

http://www.vertex42.com/Calculators/simple-interest-loan.html Page 24 of 28
HELP
http://www.vertex42.com/Calculators/simple-interest-loan.html © 2008-2023 Vertex42 LLC

Getting Started
General help information for how to use each calculator is provided on the right side of
each worksheet. Specific help information for cells is provided via cell comments.

Additional Help
The link at the top of this worksheet will take you to the web page on vertex42.com that
talks about this template.

REFERENCES

SEE ALSO Vertex42.com: Loan Amortization Schedule

SEE ALSO Vertex42.com: Personal Budget Spreadsheet

TIPS Vertex42.com: Spreadsheet Tips Workbook


08-2023 Vertex42 LLC
Simple Interest Loan Calculator
By Vertex42.com
http://www.vertex42.com/Calculators/simple-interest-loan.html

© 2008-2023 Vertex42 LLC

This spreadsheet, including all worksheets and associated content is a


copyrighted work under the United States and other copyright laws.

Do not submit copies or modifications of this template to any website or online


template gallery.

Please review the following license agreement to learn how you may or may not
use this template. Thank you.

See License Agreement


http://www.vertex42.com/licensing/EULA_personaluse.html

Do not delete this worksheet. If necessary, you may hide it by right-clicking on


the tab and selecting Hide.

You might also like