Docstoc

Loan calculator with extra payments

Document Sample
Loan calculator with extra payments Powered By Docstoc
					Loan Calculator with Extra Payments
                                          Enter values Instructions
Loan amount                             $  160,000.00
Annual interest rate                           6.000%
Loan period in years                                30 Must be between 1 and 30 years.
Start date of loan                           1/1/2005
Optional extra payments                 $      400.00 If your extra payments vary, enter them in the table below.


Scheduled monthly payment               $       959.28   Note: This payment does NOT include taxes or insurance
Home Owners Insurance                   $        55.00
Property Taxes                          $       175.00
Total Actual Payment (No Extra)         $     1,189.28
Total Actual Payment (With Extra)       $     1,589.28
Scheduled number of payments                       360   Total Payments   $428,141.10   Total Interest $268,141.10
Actual number of payments                          179   Total Payments   $284,481.27   Total Interest $124,481.27
Total of early payments                 $    71,600.00   Savings           $143,659.83 # Years Cut Off     15.08
Total interest                          $    82,027.64


          Payment         Beginning         Scheduled        Extra            Total
No.       Date            Balance           Payment          Payment          Payment        Principal         Interest
   1       1/1/2005 $      160,000.00   $      959.28    $       400.00   $   1,359.28   $        559.28   $     800.00
   2       2/1/2005        159,440.72          959.28            400.00       1,359.28            562.08         797.20
   3       3/1/2005        158,878.64          959.28            400.00       1,359.28            564.89         794.39
   4       4/1/2005        158,313.75          959.28            400.00       1,359.28            567.71         791.57
   5       5/1/2005        157,746.04          959.28            400.00       1,359.28            570.55         788.73
   6       6/1/2005        157,175.49          959.28            400.00       1,359.28            573.40         785.88
   7       7/1/2005        156,602.09          959.28            400.00       1,359.28            576.27         783.01
   8       8/1/2005        156,025.82          959.28            400.00       1,359.28            579.15         780.13
   9       9/1/2005        155,446.67          959.28            400.00       1,359.28            582.05         777.23
  10      10/1/2005        154,864.62          959.28            400.00       1,359.28            584.96         774.32
  11      11/1/2005        154,279.66          959.28            400.00       1,359.28            587.88         771.40
  12      12/1/2005        153,691.78          959.28            400.00       1,359.28            590.82         768.46
  13       1/1/2006        153,100.96          959.28            400.00       1,359.28            593.78         765.50
  14       2/1/2006        152,507.18          959.28            400.00       1,359.28            596.74         762.54
  15       3/1/2006        151,910.44          959.28            400.00       1,359.28            599.73         759.55
  16       4/1/2006        151,310.71          959.28            400.00       1,359.28            602.73         756.55
  17       5/1/2006        150,707.98          959.28            400.00       1,359.28            605.74         753.54
  18       6/1/2006        150,102.24          959.28            400.00       1,359.28            608.77         750.51
  19       7/1/2006        149,493.47          959.28            400.00       1,359.28            611.81         747.47
  20       8/1/2006        148,881.66          959.28            400.00       1,359.28            614.87         744.41
  21       9/1/2006        148,266.78          959.28            400.00       1,359.28            617.95         741.33
  22      10/1/2006        147,648.84          959.28            400.00       1,359.28            621.04         738.24
  23      11/1/2006        147,027.80          959.28            400.00       1,359.28            624.14         735.14
  24      12/1/2006        146,403.66          959.28            400.00       1,359.28            627.26         732.02
  25       1/1/2007        145,776.39          959.28            400.00       1,359.28            630.40         728.88
  26       2/1/2007        145,146.00          959.28            400.00       1,359.28            633.55         725.73
  27       3/1/2007        144,512.44          959.28            400.00       1,359.28            636.72         722.56
  28       4/1/2007        143,875.73          959.28            400.00       1,359.28            639.90         719.38
  29       5/1/2007        143,235.82          959.28            400.00       1,359.28            643.10         716.18
  30       6/1/2007        142,592.72          959.28            400.00       1,359.28            646.32         712.96
  31       7/1/2007        141,946.41          959.28            400.00       1,359.28            649.55         709.73
  32       8/1/2007        141,296.86          959.28            400.00       1,359.28            652.80         706.48
  33       9/1/2007        140,644.06          959.28            400.00       1,359.28            656.06         703.22
  34      10/1/2007        139,988.00          959.28            400.00       1,359.28            659.34         699.94
  35      11/1/2007        139,328.66          959.28            400.00       1,359.28            662.64         696.64
  36      12/1/2007        138,666.02          959.28            400.00       1,359.28            665.95         693.33
  37       1/1/2008        138,000.07          959.28            400.00       1,359.28            669.28         690.00
  38       2/1/2008        137,330.79          959.28            400.00       1,359.28            672.63         686.65
  39       3/1/2008        136,658.16          959.28            400.00       1,359.28            675.99         683.29
  40       4/1/2008        135,982.17          959.28            400.00       1,359.28            679.37         679.91
  41       5/1/2008        135,302.80          959.28            400.00       1,359.28            682.77         676.51
  42       6/1/2008        134,620.04          959.28            400.00       1,359.28            686.18         673.10
  43       7/1/2008        133,933.86          959.28            400.00       1,359.28            689.61         669.67
  44       8/1/2008        133,244.24          959.28            400.00       1,359.28            693.06         666.22
       Payment     Beginning     Scheduled   Extra       Total
No.    Date        Balance       Payment     Payment     Payment    Principal     Interest
  45    9/1/2008    132,551.18      959.28      400.00   1,359.28        696.52     662.76
  46   10/1/2008    131,854.66      959.28      400.00   1,359.28        700.01     659.27
  47   11/1/2008    131,154.65      959.28      400.00   1,359.28        703.51     655.77
  48   12/1/2008    130,451.14      959.28      400.00   1,359.28        707.03     652.26
  49    1/1/2009    129,744.12      959.28      400.00   1,359.28        710.56     648.72
  50    2/1/2009    129,033.56      959.28      400.00   1,359.28        714.11     645.17
  51    3/1/2009    128,319.45      959.28      400.00   1,359.28        717.68     641.60
  52    4/1/2009    127,601.76      959.28      400.00   1,359.28        721.27     638.01
  53    5/1/2009    126,880.49      959.28      400.00   1,359.28        724.88     634.40
  54    6/1/2009    126,155.61      959.28      400.00   1,359.28        728.50     630.78
  55    7/1/2009    125,427.11      959.28      400.00   1,359.28        732.15     627.14
  56    8/1/2009    124,694.96      959.28      400.00   1,359.28        735.81     623.47
  57    9/1/2009    123,959.16      959.28      400.00   1,359.28        739.49     619.80
  58   10/1/2009    123,219.67      959.28      400.00   1,359.28        743.18     616.10
  59   11/1/2009    122,476.49      959.28      400.00   1,359.28        746.90     612.38
  60   12/1/2009    121,729.59      959.28      400.00   1,359.28        750.63     608.65
  61    1/1/2010    120,978.96      959.28      400.00   1,359.28        754.39     604.89
  62    2/1/2010    120,224.57      959.28      400.00   1,359.28        758.16     601.12
  63    3/1/2010    119,466.41      959.28      400.00   1,359.28        761.95     597.33
  64    4/1/2010    118,704.47      959.28      400.00   1,359.28        765.76     593.52
  65    5/1/2010    117,938.71      959.28      400.00   1,359.28        769.59     589.69
  66    6/1/2010    117,169.12      959.28      400.00   1,359.28        773.44     585.85
  67    7/1/2010    116,395.68      959.28      400.00   1,359.28        777.30     581.98
  68    8/1/2010    115,618.38      959.28      400.00   1,359.28        781.19     578.09
  69    9/1/2010    114,837.19      959.28      400.00   1,359.28        785.09     574.19
  70   10/1/2010    114,052.10      959.28      400.00   1,359.28        789.02     570.26
  71   11/1/2010    113,263.08      959.28      400.00   1,359.28        792.97     566.32
  72   12/1/2010    112,470.11      959.28      400.00   1,359.28        796.93     562.35
  73    1/1/2011    111,673.18      959.28      400.00   1,359.28        800.91     558.37
  74    2/1/2011    110,872.27      959.28      400.00   1,359.28        804.92     554.36
  75    3/1/2011    110,067.35      959.28      400.00   1,359.28        808.94     550.34
  76    4/1/2011    109,258.40      959.28      400.00   1,359.28        812.99     546.29
  77    5/1/2011    108,445.42      959.28      400.00   1,359.28        817.05     542.23
  78    6/1/2011    107,628.36      959.28      400.00   1,359.28        821.14     538.14
  79    7/1/2011    106,807.22      959.28      400.00   1,359.28        825.24     534.04
  80    8/1/2011    105,981.98      959.28      400.00   1,359.28        829.37     529.91
  81    9/1/2011    105,152.61      959.28      400.00   1,359.28        833.52     525.76
  82   10/1/2011    104,319.09      959.28      400.00   1,359.28        837.69     521.60
  83   11/1/2011    103,481.40      959.28      400.00   1,359.28        841.87     517.41
  84   12/1/2011    102,639.53      959.28      400.00   1,359.28        846.08     513.20
  85    1/1/2012    101,793.45      959.28      400.00   1,359.28        850.31     508.97
  86    2/1/2012    100,943.13      959.28      400.00   1,359.28        854.57     504.72
  87    3/1/2012    100,088.57      959.28      400.00   1,359.28        858.84     500.44
  88    4/1/2012     99,229.73      959.28      400.00   1,359.28        863.13     496.15
  89    5/1/2012     98,366.60      959.28      400.00   1,359.28        867.45     491.83
  90    6/1/2012     97,499.15      959.28      400.00   1,359.28        871.79     487.50
  91    7/1/2012     96,627.36      959.28      400.00   1,359.28        876.14     483.14
  92    8/1/2012     95,751.22      959.28      400.00   1,359.28        880.52     478.76
  93    9/1/2012     94,870.70      959.28      400.00   1,359.28        884.93     474.35
  94   10/1/2012     93,985.77      959.28      400.00   1,359.28        889.35     469.93
  95   11/1/2012     93,096.42      959.28      400.00   1,359.28        893.80     465.48
  96   12/1/2012     92,202.62      959.28      400.00   1,359.28        898.27     461.01
  97    1/1/2013     91,304.35      959.28      400.00   1,359.28        902.76     456.52
  98    2/1/2013     90,401.59      959.28      400.00   1,359.28        907.27     452.01
  99    3/1/2013     89,494.32      959.28      400.00   1,359.28        911.81     447.47
 100    4/1/2013     88,582.51      959.28      400.00   1,359.28        916.37     442.91
 101    5/1/2013     87,666.14      959.28      400.00   1,359.28        920.95     438.33
 102    6/1/2013     86,745.19      959.28      400.00   1,359.28        925.55     433.73
 103    7/1/2013     85,819.64      959.28      400.00   1,359.28        930.18     429.10
 104    8/1/2013     84,889.45      959.28      400.00   1,359.28        934.83     424.45
 105    9/1/2013     83,954.62      959.28      400.00   1,359.28        939.51     419.77
 106   10/1/2013     83,015.11      959.28      400.00   1,359.28        944.21     415.08
 107   11/1/2013     82,070.91      959.28      400.00   1,359.28        948.93     410.35
 108   12/1/2013     81,121.98      959.28      400.00   1,359.28        953.67     405.61
 109    1/1/2014     80,168.31      959.28      400.00   1,359.28        958.44     400.84
 110    2/1/2014     79,209.87      959.28      400.00   1,359.28        963.23     396.05
       Payment     Beginning     Scheduled   Extra       Total
No.    Date        Balance       Payment     Payment     Payment    Principal     Interest
 111    3/1/2014     78,246.64      959.28      400.00   1,359.28        968.05     391.23
 112    4/1/2014     77,278.59      959.28      400.00   1,359.28        972.89     386.39
 113    5/1/2014     76,305.70      959.28      400.00   1,359.28        977.75     381.53
 114    6/1/2014     75,327.95      959.28      400.00   1,359.28        982.64     376.64
 115    7/1/2014     74,345.31      959.28      400.00   1,359.28        987.55     371.73
 116    8/1/2014     73,357.75      959.28      400.00   1,359.28        992.49     366.79
 117    9/1/2014     72,365.26      959.28      400.00   1,359.28        997.45     361.83
 118   10/1/2014     71,367.81      959.28      400.00   1,359.28      1,002.44     356.84
 119   11/1/2014     70,365.37      959.28      400.00   1,359.28      1,007.45     351.83
 120   12/1/2014     69,357.91      959.28      400.00   1,359.28      1,012.49     346.79
 121    1/1/2015     68,345.42      959.28      400.00   1,359.28      1,017.55     341.73
 122    2/1/2015     67,327.87      959.28      400.00   1,359.28      1,022.64     336.64
 123    3/1/2015     66,305.23      959.28      400.00   1,359.28      1,027.75     331.53
 124    4/1/2015     65,277.47      959.28      400.00   1,359.28      1,032.89     326.39
 125    5/1/2015     64,244.58      959.28      400.00   1,359.28      1,038.06     321.22
 126    6/1/2015     63,206.52      959.28      400.00   1,359.28      1,043.25     316.03
 127    7/1/2015     62,163.27      959.28      400.00   1,359.28      1,048.46     310.82
 128    8/1/2015     61,114.81      959.28      400.00   1,359.28      1,053.71     305.57
 129    9/1/2015     60,061.10      959.28      400.00   1,359.28      1,058.98     300.31
 130   10/1/2015     59,002.12      959.28      400.00   1,359.28      1,064.27     295.01
 131   11/1/2015     57,937.85      959.28      400.00   1,359.28      1,069.59     289.69
 132   12/1/2015     56,868.26      959.28      400.00   1,359.28      1,074.94     284.34
 133    1/1/2016     55,793.32      959.28      400.00   1,359.28      1,080.31     278.97
 134    2/1/2016     54,713.01      959.28      400.00   1,359.28      1,085.72     273.57
 135    3/1/2016     53,627.29      959.28      400.00   1,359.28      1,091.14     268.14
 136    4/1/2016     52,536.15      959.28      400.00   1,359.28      1,096.60     262.68
 137    5/1/2016     51,439.55      959.28      400.00   1,359.28      1,102.08     257.20
 138    6/1/2016     50,337.47      959.28      400.00   1,359.28      1,107.59     251.69
 139    7/1/2016     49,229.87      959.28      400.00   1,359.28      1,113.13     246.15
 140    8/1/2016     48,116.74      959.28      400.00   1,359.28      1,118.70     240.58
 141    9/1/2016     46,998.04      959.28      400.00   1,359.28      1,124.29     234.99
 142   10/1/2016     45,873.75      959.28      400.00   1,359.28      1,129.91     229.37
 143   11/1/2016     44,743.84      959.28      400.00   1,359.28      1,135.56     223.72
 144   12/1/2016     43,608.28      959.28      400.00   1,359.28      1,141.24     218.04
 145    1/1/2017     42,467.04      959.28      400.00   1,359.28      1,146.95     212.34
 146    2/1/2017     41,320.09      959.28      400.00   1,359.28      1,152.68     206.60
 147    3/1/2017     40,167.41      959.28      400.00   1,359.28      1,158.44     200.84
 148    4/1/2017     39,008.97      959.28      400.00   1,359.28      1,164.24     195.04
 149    5/1/2017     37,844.73      959.28      400.00   1,359.28      1,170.06     189.22
 150    6/1/2017     36,674.68      959.28      400.00   1,359.28      1,175.91     183.37
 151    7/1/2017     35,498.77      959.28      400.00   1,359.28      1,181.79     177.49
 152    8/1/2017     34,316.98      959.28      400.00   1,359.28      1,187.70     171.58
 153    9/1/2017     33,129.29      959.28      400.00   1,359.28      1,193.63     165.65
 154   10/1/2017     31,935.65      959.28      400.00   1,359.28      1,199.60     159.68
 155   11/1/2017     30,736.05      959.28      400.00   1,359.28      1,205.60     153.68
 156   12/1/2017     29,530.45      959.28      400.00   1,359.28      1,211.63     147.65
 157    1/1/2018     28,318.82      959.28      400.00   1,359.28      1,217.69     141.59
 158    2/1/2018     27,101.13      959.28      400.00   1,359.28      1,223.78     135.51
 159    3/1/2018     25,877.36      959.28      400.00   1,359.28      1,229.89     129.39
 160    4/1/2018     24,647.46      959.28      400.00   1,359.28      1,236.04     123.24
 161    5/1/2018     23,411.42      959.28      400.00   1,359.28      1,242.22     117.06
 162    6/1/2018     22,169.20      959.28      400.00   1,359.28      1,248.43     110.85
 163    7/1/2018     20,920.76      959.28      400.00   1,359.28      1,254.68     104.60
 164    8/1/2018     19,666.09      959.28      400.00   1,359.28      1,260.95      98.33
 165    9/1/2018     18,405.14      959.28      400.00   1,359.28      1,267.26      92.03
 166   10/1/2018     17,137.88      959.28      400.00   1,359.28      1,273.59      85.69
 167   11/1/2018     15,864.29      959.28      400.00   1,359.28      1,279.96      79.32
 168   12/1/2018     14,584.33      959.28      400.00   1,359.28      1,286.36      72.92
 169    1/1/2019     13,297.97      959.28      400.00   1,359.28      1,292.79      66.49
 170    2/1/2019     12,005.18      959.28      400.00   1,359.28      1,299.25      60.03
 171    3/1/2019     10,705.92      959.28      400.00   1,359.28      1,305.75      53.53
 172    4/1/2019      9,400.17      959.28      400.00   1,359.28      1,312.28      47.00
 173    5/1/2019      8,087.89      959.28      400.00   1,359.28      1,318.84      40.44
 174    6/1/2019      6,769.05      959.28      400.00   1,359.28      1,325.44      33.85
 175    7/1/2019      5,443.62      959.28      400.00   1,359.28      1,332.06      27.22
 176    8/1/2019      4,111.55      959.28      400.00   1,359.28      1,338.72      20.56
       Payment     Beginning     Scheduled   Extra       Total
No.    Date        Balance       Payment     Payment     Payment    Principal     Interest
 177    9/1/2019      2,772.83      959.28      400.00   1,359.28      1,345.42       13.86
 178   10/1/2019      1,427.41      959.28      400.00   1,359.28      1,352.14        7.14
 179   11/1/2019         75.27      959.28      400.00   1,359.28      1,358.90        0.38
    Ending
    Balance
$   159,440.72
    158,878.64
    158,313.75
    157,746.04
    157,175.49
    156,602.09
    156,025.82
    155,446.67
    154,864.62
    154,279.66
    153,691.78
    153,100.96
    152,507.18
    151,910.44
    151,310.71
    150,707.98
    150,102.24
    149,493.47
    148,881.66
    148,266.78
    147,648.84
    147,027.80
    146,403.66
    145,776.39
    145,146.00
    144,512.44
    143,875.73
    143,235.82
    142,592.72
    141,946.41
    141,296.86
    140,644.06
    139,988.00
    139,328.66
    138,666.02
    138,000.07
    137,330.79
    136,658.16
    135,982.17
    135,302.80
    134,620.04
    133,933.86
    133,244.24
    132,551.18
Ending
Balance
131,854.66
131,154.65
130,451.14
129,744.12
129,033.56
128,319.45
127,601.76
126,880.49
126,155.61
125,427.11
124,694.96
123,959.16
123,219.67
122,476.49
121,729.59
120,978.96
120,224.57
119,466.41
118,704.47
117,938.71
117,169.12
116,395.68
115,618.38
114,837.19
114,052.10
113,263.08
112,470.11
111,673.18
110,872.27
110,067.35
109,258.40
108,445.42
107,628.36
106,807.22
105,981.98
105,152.61
104,319.09
103,481.40
102,639.53
101,793.45
100,943.13
100,088.57
 99,229.73
 98,366.60
 97,499.15
 96,627.36
 95,751.22
 94,870.70
 93,985.77
 93,096.42
 92,202.62
 91,304.35
 90,401.59
 89,494.32
 88,582.51
 87,666.14
 86,745.19
 85,819.64
 84,889.45
 83,954.62
 83,015.11
 82,070.91
 81,121.98
 80,168.31
 79,209.87
 78,246.64
Ending
Balance
77,278.59
76,305.70
75,327.95
74,345.31
73,357.75
72,365.26
71,367.81
70,365.37
69,357.91
68,345.42
67,327.87
66,305.23
65,277.47
64,244.58
63,206.52
62,163.27
61,114.81
60,061.10
59,002.12
57,937.85
56,868.26
55,793.32
54,713.01
53,627.29
52,536.15
51,439.55
50,337.47
49,229.87
48,116.74
46,998.04
45,873.75
44,743.84
43,608.28
42,467.04
41,320.09
40,167.41
39,008.97
37,844.73
36,674.68
35,498.77
34,316.98
33,129.29
31,935.65
30,736.05
29,530.45
28,318.82
27,101.13
25,877.36
24,647.46
23,411.42
22,169.20
20,920.76
19,666.09
18,405.14
17,137.88
15,864.29
14,584.33
13,297.97
12,005.18
10,705.92
 9,400.17
 8,087.89
 6,769.05
 5,443.62
 4,111.55
 2,772.83
Ending
Balance
 1,427.41
    75.27
(1,283.63)
  FUTURE VALUE OF AN INVESTMENT BASED ON CONSTANT
    INTEREST RATE AND CONSTANT PERIODIC PAYMENTS



Invested Each Year
Interest Rate
Number of Years
Present Value
Type

Total Value
N INVESTMENT BASED ON CONSTANT
ND CONSTANT PERIODIC PAYMENTS



                $4,800.00
                 10.00%
                   22
                  $0.00
                    1

              $377,006.52



                            $105,600.00

				
DOCUMENT INFO