Docstoc

simple-interest-loan-calculator

Document Sample
simple-interest-loan-calculator Powered By Docstoc
					                                                                                                                                                                         Page 1 of 24


Simple Interest Loan Calculator
                                                                                                                                         Payment Frequency Options
  Loan Information                                                      [42]       Summary                                                     Frequency        Payments/yr        Months
                Loan Amount                   $      100,000.00                      Daily Interest Rate                0.0166667%                 Annual                 1            12
         Annual Interest Rate                             6.00%                    Number of Payments                         120            Semi-Annual                  2             6
       Term of Loan in Years                                  10                       Total Payments               $    133,740.63             Quarterly                 4             3
   First Day Interest Accrues                           1/1/2011                           Total Interest           $     33,740.63            Bi-Monthly                 6             2
         Payment Frequency                               Monthly                      Balloon Payment               $           -                 Monthly               12              1
                 Days in Year                                360                                                                    .        Semi-Monthly               24            0.5
          Balloon Payment #                                                                                                                     Bi-Weekly               26                n/a
                                                                                                                                                   Weekly               52                n/a
          Est. Monthly Payment                $         1,115.15        (estimate)                                                                Chosen:               12                  1
        Actual Monthly Payment                                              Use
                                                                        FALSE     Actual Payment


Amortization Schedule                                                                                                    Rounding On
                                                                                                                                  TRUE

Pmt                                                        Interest                  Interest          Principal                Total
No.                Date         Payment                    Accrued                   Balance           Balance                 Owed
                 12/31/10                                                                          $     100,000    $         100,000
  1                2/1/11          1,115.15                    533.33                     0.00          99,418.18            99,418.18
  2                3/1/11          1,115.15                    463.95                     0.00          98,766.98            98,766.98
  3                4/1/11          1,115.15                    510.30                     0.00          98,162.13            98,162.13
  4                5/1/11          1,115.15                    490.81                     0.00          97,537.79            97,537.79
  5                6/1/11          1,115.15                    503.95                     0.00          96,926.59            96,926.59
  6                7/1/11          1,115.15                    484.63                     0.00          96,296.07            96,296.07
  7                8/1/11          1,115.15                    497.53                     0.00          95,678.45            95,678.45
  8                9/1/11          1,115.15                    494.34                     0.00          95,057.64            95,057.64
  9               10/1/11          1,115.15                    475.29                     0.00          94,417.78            94,417.78
 10               11/1/11          1,115.15                    487.83                     0.00          93,790.46            93,790.46
 11               12/1/11          1,115.15                    468.95                     0.00          93,144.26            93,144.26
 12                1/1/12          1,115.15                    481.25                     0.00          92,510.36            92,510.36
 13                2/1/12          1,115.15                    477.97                     0.00          91,873.18            91,873.18
 14                3/1/12          1,115.15                    444.05                     0.00          91,202.08            91,202.08
 15                4/1/12          1,115.15                    471.21                     0.00          90,558.14            90,558.14
 16                5/1/12          1,115.15                    452.79                     0.00          89,895.78            89,895.78
 17                6/1/12          1,115.15                    464.46                     0.00          89,245.09            89,245.09
 18                7/1/12          1,115.15                    446.23                     0.00          88,576.17            88,576.17
 19                8/1/12          1,115.15                    457.64                     0.00          87,918.66            87,918.66
 20                9/1/12          1,115.15                    454.25                     0.00          87,257.76            87,257.76
 21               10/1/12          1,115.15                    436.29                     0.00          86,578.90            86,578.90
 22               11/1/12          1,115.15                    447.32                     0.00          85,911.07            85,911.07
 23               12/1/12          1,115.15                    429.56                     0.00          85,225.48            85,225.48
 24                1/1/13          1,115.15                    440.33                     0.00          84,550.66            84,550.66
 25                2/1/13          1,115.15                    436.85                     0.00          83,872.36            83,872.36
 26                3/1/13          1,115.15                    391.40                     0.00          83,148.61            83,148.61
 27                4/1/13          1,115.15                    429.60                     0.00          82,463.06            82,463.06
 28                5/1/13          1,115.15                    412.32                     0.00          81,760.23            81,760.23
 29                6/1/13          1,115.15                    422.43                     0.00          81,067.51            81,067.51
 30                7/1/13          1,115.15                    405.34                     0.00          80,357.70            80,357.70
 31                8/1/13          1,115.15                    415.18                     0.00          79,657.73            79,657.73
 32                9/1/13          1,115.15                    411.56                     0.00          78,954.14            78,954.14
 33               10/1/13          1,115.15                    394.77                     0.00          78,233.76            78,233.76
 34               11/1/13          1,115.15                    404.21                     0.00          77,522.82            77,522.82
 35               12/1/13          1,115.15                    387.61                     0.00          76,795.28            76,795.28
 36                1/1/14          1,115.15                    396.78                     0.00          76,076.91            76,076.91
 37                2/1/14          1,115.15                    393.06                     0.00          75,354.82            75,354.82
 38                3/1/14          1,115.15                    351.66                     0.00          74,591.33            74,591.33
 39                4/1/14          1,115.15                    385.39                     0.00          73,861.57            73,861.57
 40                5/1/14          1,115.15                    369.31                     0.00          73,115.73            73,115.73
 41                6/1/14          1,115.15                    377.76                     0.00          72,378.34            72,378.34
 42                7/1/14          1,115.15                    361.89                     0.00          71,625.08            71,625.08
 43                8/1/14          1,115.15                    370.06                     0.00          70,879.99            70,879.99
 44                9/1/14          1,115.15                    366.21                     0.00          70,131.05            70,131.05
 45               10/1/14          1,115.15                    350.66                     0.00          69,366.56            69,366.56
 46               11/1/14          1,115.15                    358.39                     0.00          68,609.80            68,609.80
 47               12/1/14          1,115.15                    343.05                     0.00          67,837.70            67,837.70
 48                1/1/15          1,115.15                    350.49                     0.00          67,073.04            67,073.04
 49                2/1/15          1,115.15                    346.54                     0.00          66,304.43            66,304.43
 50                3/1/15          1,115.15                    309.42                     0.00          65,498.70            65,498.70
 51                4/1/15          1,115.15                    338.41                     0.00          64,721.96            64,721.96
 52                5/1/15          1,115.15                    323.61                     0.00          63,930.42            63,930.42
 53                6/1/15          1,115.15                    330.31                     0.00          63,145.58            63,145.58
 54                7/1/15          1,115.15                    315.73                     0.00          62,346.16            62,346.16
 55                8/1/15          1,115.15                    322.12                     0.00          61,553.13            61,553.13
 56                9/1/15          1,115.15                    318.02                     0.00          60,756.00            60,756.00
 57               10/1/15          1,115.15                    303.78                     0.00          59,944.63            59,944.63
 58               11/1/15          1,115.15                    309.71                     0.00          59,139.19            59,139.19
 59               12/1/15          1,115.15                    295.70                     0.00          58,319.74            58,319.74
 60                1/1/16          1,115.15                    301.32                     0.00          57,505.91            57,505.91
 61                2/1/16          1,115.15                    297.11                     0.00          56,687.87            56,687.87



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

62                3/1/16          1,115.15                    273.99    0.00   55,846.71   55,846.71
63                4/1/16          1,115.15                    288.54    0.00   55,020.10   55,020.10
64                5/1/16          1,115.15                    275.10    0.00   54,180.05   54,180.05
65                6/1/16          1,115.15                    279.93    0.00   53,344.83   53,344.83
66                7/1/16          1,115.15                    266.72    0.00   52,496.40   52,496.40
67                8/1/16          1,115.15                    271.23    0.00   51,652.48   51,652.48
68                9/1/16          1,115.15                    266.87    0.00   50,804.20   50,804.20
69               10/1/16          1,115.15                    254.02    0.00   49,943.07   49,943.07
70               11/1/16          1,115.15                    258.04    0.00   49,085.96   49,085.96
71               12/1/16          1,115.15                    245.43    0.00   48,216.24   48,216.24
72                1/1/17          1,115.15                    249.12    0.00   47,350.21   47,350.21
73                2/1/17          1,115.15                    244.64    0.00   46,479.70   46,479.70
74                3/1/17          1,115.15                    216.91    0.00   45,581.46   45,581.46
75                4/1/17          1,115.15                    235.50    0.00   44,701.81   44,701.81
76                5/1/17          1,115.15                    223.51    0.00   43,810.17   43,810.17
77                6/1/17          1,115.15                    226.35    0.00   42,921.37   42,921.37
78                7/1/17          1,115.15                    214.61    0.00   42,020.83   42,020.83
79                8/1/17          1,115.15                    217.11    0.00   41,122.79   41,122.79
80                9/1/17          1,115.15                    212.47    0.00   40,220.11   40,220.11
81               10/1/17          1,115.15                    201.10    0.00   39,306.06   39,306.06
82               11/1/17          1,115.15                    203.08    0.00   38,393.99   38,393.99
83               12/1/17          1,115.15                    191.97    0.00   37,470.81   37,470.81
84                1/1/18          1,115.15                    193.60    0.00   36,549.26   36,549.26
85                2/1/18          1,115.15                    188.84    0.00   35,622.95   35,622.95
86                3/1/18          1,115.15                    166.24    0.00   34,674.04   34,674.04
87                4/1/18          1,115.15                    179.15    0.00   33,738.04   33,738.04
88                5/1/18          1,115.15                    168.69    0.00   32,791.58   32,791.58
89                6/1/18          1,115.15                    169.42    0.00   31,845.85   31,845.85
90                7/1/18          1,115.15                    159.23    0.00   30,889.93   30,889.93
91                8/1/18          1,115.15                    159.60    0.00   29,934.38   29,934.38
92                9/1/18          1,115.15                    154.66    0.00   28,973.89   28,973.89
93               10/1/18          1,115.15                    144.87    0.00   28,003.61   28,003.61
94               11/1/18          1,115.15                    144.69    0.00   27,033.15   27,033.15
95               12/1/18          1,115.15                    135.17    0.00   26,053.17   26,053.17
96                1/1/19          1,115.15                    134.61    0.00   25,072.63   25,072.63
97                2/1/19          1,115.15                    129.54    0.00   24,087.02   24,087.02
98                3/1/19          1,115.15                    112.41    0.00   23,084.28   23,084.28
99                4/1/19          1,115.15                    119.27    0.00   22,088.40   22,088.40
100               5/1/19          1,115.15                    110.44    0.00   21,083.69   21,083.69
101               6/1/19          1,115.15                    108.93    0.00   20,077.47   20,077.47
102               7/1/19          1,115.15                    100.39    0.00   19,062.71   19,062.71
103               8/1/19          1,115.15                     98.49    0.00   18,046.05   18,046.05
104               9/1/19          1,115.15                     93.24    0.00   17,024.14   17,024.14
105              10/1/19          1,115.15                     85.12    0.00   15,994.11   15,994.11
106              11/1/19          1,115.15                     82.64    0.00   14,961.60   14,961.60
107              12/1/19          1,115.15                     74.81    0.00   13,921.26   13,921.26
108               1/1/20          1,115.15                     71.93    0.00   12,878.04   12,878.04
109               2/1/20          1,115.15                     66.54    0.00   11,829.43   11,829.43
110               3/1/20          1,115.15                     57.18    0.00   10,771.46   10,771.46
111               4/1/20          1,115.15                     55.65    0.00    9,711.96    9,711.96
112               5/1/20          1,115.15                     48.56    0.00    8,645.37    8,645.37
113               6/1/20          1,115.15                     44.67    0.00    7,574.89    7,574.89
114               7/1/20          1,115.15                     37.87    0.00    6,497.61    6,497.61
115               8/1/20          1,115.15                     33.57    0.00    5,416.03    5,416.03
116               9/1/20          1,115.15                     27.98    0.00    4,328.86    4,328.86
117              10/1/20          1,115.15                     21.64    0.00    3,235.35    3,235.35
118              11/1/20          1,115.15                     16.72    0.00    2,136.92    2,136.92
119              12/1/20          1,115.15                     10.68    0.00    1,032.45    1,032.45
120               1/1/21          1,037.78                       5.33   0.00        0.00        0.00




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




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




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




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




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




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




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




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




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

Simple Interest Loan Payment Schedule
 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          $    1,115.15
                  Days in Year                          360                         Total Interest      $      533.33

      Payment (for reference)

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         1,115.15                   533.33                 0.00       99,418.18             99,418.18
 2




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




  http://www.vertex42.com/ExcelTemplates/loan-amortization-schedule.html                                      © 2008 Vertex42 LLC
                                                                            Page 12 of 24




http://www.vertex42.com/ExcelTemplates/loan-amortization-schedule.html   © 2008 Vertex42 LLC
                                                                            Page 13 of 24




http://www.vertex42.com/ExcelTemplates/loan-amortization-schedule.html   © 2008 Vertex42 LLC
                                                                            Page 14 of 24




http://www.vertex42.com/ExcelTemplates/loan-amortization-schedule.html   © 2008 Vertex42 LLC
                                                                            Page 15 of 24




http://www.vertex42.com/ExcelTemplates/loan-amortization-schedule.html   © 2008 Vertex42 LLC
                                                                            Page 16 of 24




http://www.vertex42.com/ExcelTemplates/loan-amortization-schedule.html   © 2008 Vertex42 LLC
                                                                            Page 17 of 24




http://www.vertex42.com/ExcelTemplates/loan-amortization-schedule.html   © 2008 Vertex42 LLC
                                                                            Page 18 of 24




http://www.vertex42.com/ExcelTemplates/loan-amortization-schedule.html   © 2008 Vertex42 LLC
                                                                            Page 19 of 24




http://www.vertex42.com/ExcelTemplates/loan-amortization-schedule.html   © 2008 Vertex42 LLC
                                                                            Page 20 of 24




http://www.vertex42.com/ExcelTemplates/loan-amortization-schedule.html   © 2008 Vertex42 LLC
                                                                            Page 21 of 24




http://www.vertex42.com/ExcelTemplates/loan-amortization-schedule.html   © 2008 Vertex42 LLC
                                                                            Page 22 of 24




http://www.vertex42.com/ExcelTemplates/loan-amortization-schedule.html   © 2008 Vertex42 LLC
                                                                            Page 23 of 24




http://www.vertex42.com/ExcelTemplates/loan-amortization-schedule.html   © 2008 Vertex42 LLC
                                                                               Page 24 of 24




End of Formulas




   http://www.vertex42.com/ExcelTemplates/loan-amortization-schedule.html   © 2008 Vertex42 LLC

				
DOCUMENT INFO
Shared By:
Stats:
views:88
posted:3/11/2012
language:English
pages:24