Simple Interest Loan Calculator
Simple Interest Loan Calculator
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
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.
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
       Please review the following license agreement to learn how you may or may not
       use this template. Thank you.