Loan EMI Calculator

Document Sample
Loan EMI Calculator Powered By Docstoc
					                                               Enter Values
              Loan Amount                        100,000.00
              Annual Interest Rate                   12.00%
              Loan Period in Years                        15
              Start Date of Loan                   1-Jan-07



              Monthly Payment                       1,200.17
              Number of Payments                         180
              Total Interest                      116,030.25
              Total Cost of Loan                  216,030.25


                                  Beginning                                       Ending
          No. Payment Date        Balance       Payment      Principal Interest   Balance
            1          1-Feb-07      100,000.00     1,200.17    200.17   1,000.00     99,799.83
            2          1-Mar-07       99,799.83     1,200.17    202.17     998.00     99,597.66
            3           1-Apr-07      99,597.66     1,200.17    204.19     995.98     99,393.47
            4          1-May-07       99,393.47     1,200.17    206.23     993.93     99,187.24
            5           1-Jun-07      99,187.24     1,200.17    208.30     991.87     98,978.94
            6            1-Jul-07     98,978.94     1,200.17    210.38     989.79     98,768.56
            7          1-Aug-07       98,768.56     1,200.17    212.48     987.69     98,556.08
            8          1-Sep-07       98,556.08     1,200.17    214.61     985.56     98,341.47
            9           1-Oct-07      98,341.47     1,200.17    216.75     983.41     98,124.72
           10          1-Nov-07       98,124.72     1,200.17    218.92     981.25     97,905.80
           11          1-Dec-07       97,905.80     1,200.17    221.11     979.06     97,684.69
           12           1-Jan-08      97,684.69     1,200.17    223.32     976.85     97,461.37
           13          1-Feb-08       97,461.37     1,200.17    225.55     974.61     97,235.81
           14          1-Mar-08       97,235.81     1,200.17    227.81     972.36     97,008.00
           15           1-Apr-08      97,008.00     1,200.17    230.09     970.08     96,777.92
           16          1-May-08       96,777.92     1,200.17    232.39     967.78     96,545.53
           17           1-Jun-08      96,545.53     1,200.17    234.71     965.46     96,310.81
           18            1-Jul-08     96,310.81     1,200.17    237.06     963.11     96,073.75
           19          1-Aug-08       96,073.75     1,200.17    239.43     960.74     95,834.32
           20          1-Sep-08       95,834.32     1,200.17    241.82     958.34     95,592.50
           21           1-Oct-08      95,592.50     1,200.17    244.24     955.92     95,348.26
           22          1-Nov-08       95,348.26     1,200.17    246.69     953.48     95,101.57
           23          1-Dec-08       95,101.57     1,200.17    249.15     951.02     94,852.42
           24           1-Jan-09      94,852.42     1,200.17    251.64     948.52     94,600.77
           25          1-Feb-09       94,600.77     1,200.17    254.16     946.01     94,346.61
           26          1-Mar-09       94,346.61     1,200.17    256.70     943.47     94,089.91
           27           1-Apr-09      94,089.91     1,200.17    259.27     940.90     93,830.64
           28          1-May-09       93,830.64     1,200.17    261.86     938.31     93,568.78
           29           1-Jun-09      93,568.78     1,200.17    264.48     935.69     93,304.30
           30            1-Jul-09     93,304.30     1,200.17    267.13     933.04     93,037.18
           31          1-Aug-09       93,037.18     1,200.17    269.80     930.37     92,767.38
           32          1-Sep-09       92,767.38     1,200.17    272.49     927.67     92,494.89
           33           1-Oct-09      92,494.89     1,200.17    275.22     924.95     92,219.67
           34          1-Nov-09       92,219.67     1,200.17    277.97     922.20     91,941.69
           35          1-Dec-09       91,941.69     1,200.17    280.75     919.42     91,660.94
           36           1-Jan-10      91,660.94     1,200.17    283.56     916.61     91,377.38
           37          1-Feb-10       91,377.38     1,200.17    286.39     913.77     91,090.99
           38          1-Mar-10       91,090.99     1,200.17    289.26     910.91     90,801.73
           39           1-Apr-10      90,801.73     1,200.17    292.15     908.02     90,509.58
           40          1-May-10       90,509.58     1,200.17    295.07     905.10     90,214.51




1b6f460a-143a-44a0-8bbd-e3d191d4d326.xls       Page 1 of 4                        www.HomePlanGuru.com
                                  Beginning                                       Ending
          No. Payment Date        Balance       Payment      Principal Interest   Balance
           41           1-Jun-10      90,214.51     1,200.17    298.02     902.15     89,916.49
           42            1-Jul-10     89,916.49     1,200.17    301.00     899.16     89,615.48
           43          1-Aug-10       89,615.48     1,200.17    304.01     896.15     89,311.47
           44          1-Sep-10       89,311.47     1,200.17    307.05     893.11     89,004.42
           45           1-Oct-10      89,004.42     1,200.17    310.12     890.04     88,694.29
           46          1-Nov-10       88,694.29     1,200.17    313.23     886.94     88,381.07
           47          1-Dec-10       88,381.07     1,200.17    316.36     883.81     88,064.71
           48           1-Jan-11      88,064.71     1,200.17    319.52     880.65     87,745.19
           49          1-Feb-11       87,745.19     1,200.17    322.72     877.45     87,422.47
           50          1-Mar-11       87,422.47     1,200.17    325.94     874.22     87,096.53
           51           1-Apr-11      87,096.53     1,200.17    329.20     870.97     86,767.33
           52          1-May-11       86,767.33     1,200.17    332.49     867.67     86,434.83
           53           1-Jun-11      86,434.83     1,200.17    335.82     864.35     86,099.01
           54            1-Jul-11     86,099.01     1,200.17    339.18     860.99     85,759.83
           55          1-Aug-11       85,759.83     1,200.17    342.57     857.60     85,417.26
           56          1-Sep-11       85,417.26     1,200.17    346.00     854.17     85,071.27
           57           1-Oct-11      85,071.27     1,200.17    349.46     850.71     84,721.81
           58          1-Nov-11       84,721.81     1,200.17    352.95     847.22     84,368.86
           59          1-Dec-11       84,368.86     1,200.17    356.48     843.69     84,012.38
           60           1-Jan-12      84,012.38     1,200.17    360.04     840.12     83,652.34
           61          1-Feb-12       83,652.34     1,200.17    363.64     836.52     83,288.70
           62          1-Mar-12       83,288.70     1,200.17    367.28     832.89     82,921.41
           63           1-Apr-12      82,921.41     1,200.17    370.95     829.21     82,550.46
           64          1-May-12       82,550.46     1,200.17    374.66     825.50     82,175.80
           65           1-Jun-12      82,175.80     1,200.17    378.41     821.76     81,797.39
           66            1-Jul-12     81,797.39     1,200.17    382.19     817.97     81,415.19
           67          1-Aug-12       81,415.19     1,200.17    386.02     814.15     81,029.18
           68          1-Sep-12       81,029.18     1,200.17    389.88     810.29     80,639.30
           69           1-Oct-12      80,639.30     1,200.17    393.78     806.39     80,245.53
           70          1-Nov-12       80,245.53     1,200.17    397.71     802.46     79,847.81
           71          1-Dec-12       79,847.81     1,200.17    401.69     798.48     79,446.12
           72           1-Jan-13      79,446.12     1,200.17    405.71     794.46     79,040.42
           73          1-Feb-13       79,040.42     1,200.17    409.76     790.40     78,630.65
           74          1-Mar-13       78,630.65     1,200.17    413.86     786.31     78,216.79
           75           1-Apr-13      78,216.79     1,200.17    418.00     782.17     77,798.79
           76          1-May-13       77,798.79     1,200.17    422.18     777.99     77,376.61
           77           1-Jun-13      77,376.61     1,200.17    426.40     773.77     76,950.21
           78            1-Jul-13     76,950.21     1,200.17    430.67     769.50     76,519.54
           79          1-Aug-13       76,519.54     1,200.17    434.97     765.20     76,084.57
           80          1-Sep-13       76,084.57     1,200.17    439.32     760.85     75,645.25
           81           1-Oct-13      75,645.25     1,200.17    443.72     756.45     75,201.53
           82          1-Nov-13       75,201.53     1,200.17    448.15     752.02     74,753.38
           83          1-Dec-13       74,753.38     1,200.17    452.63     747.53     74,300.74
           84           1-Jan-14      74,300.74     1,200.17    457.16     743.01     73,843.58
           85          1-Feb-14       73,843.58     1,200.17    461.73     738.44     73,381.85
           86          1-Mar-14       73,381.85     1,200.17    466.35     733.82     72,915.50
           87           1-Apr-14      72,915.50     1,200.17    471.01     729.16     72,444.49
           88          1-May-14       72,444.49     1,200.17    475.72     724.44     71,968.77
           89           1-Jun-14      71,968.77     1,200.17    480.48     719.69     71,488.29
           90            1-Jul-14     71,488.29     1,200.17    485.29     714.88     71,003.00
           91          1-Aug-14       71,003.00     1,200.17    490.14     710.03     70,512.86
           92          1-Sep-14       70,512.86     1,200.17    495.04     705.13     70,017.82
           93           1-Oct-14      70,017.82     1,200.17    499.99     700.18     69,517.83
           94          1-Nov-14       69,517.83     1,200.17    504.99     695.18     69,012.84




1b6f460a-143a-44a0-8bbd-e3d191d4d326.xls       Page 2 of 4                        www.HomePlanGuru.com
                                  Beginning                                       Ending
          No. Payment Date        Balance       Payment      Principal Interest   Balance
           95          1-Dec-14       69,012.84     1,200.17    510.04     690.13     68,502.80
           96           1-Jan-15      68,502.80     1,200.17    515.14     685.03     67,987.66
           97          1-Feb-15       67,987.66     1,200.17    520.29     679.88     67,467.37
           98          1-Mar-15       67,467.37     1,200.17    525.49     674.67     66,941.88
           99           1-Apr-15      66,941.88     1,200.17    530.75     669.42     66,411.13
          100          1-May-15       66,411.13     1,200.17    536.06     664.11     65,875.07
          101           1-Jun-15      65,875.07     1,200.17    541.42     658.75     65,333.65
          102            1-Jul-15     65,333.65     1,200.17    546.83     653.34     64,786.82
          103          1-Aug-15       64,786.82     1,200.17    552.30     647.87     64,234.52
          104          1-Sep-15       64,234.52     1,200.17    557.82     642.35     63,676.70
          105           1-Oct-15      63,676.70     1,200.17    563.40     636.77     63,113.30
          106          1-Nov-15       63,113.30     1,200.17    569.04     631.13     62,544.26
          107          1-Dec-15       62,544.26     1,200.17    574.73     625.44     61,969.54
          108           1-Jan-16      61,969.54     1,200.17    580.47     619.70     61,389.07
          109          1-Feb-16       61,389.07     1,200.17    586.28     613.89     60,802.79
          110          1-Mar-16       60,802.79     1,200.17    592.14     608.03     60,210.65
          111           1-Apr-16      60,210.65     1,200.17    598.06     602.11     59,612.59
          112          1-May-16       59,612.59     1,200.17    604.04     596.13     59,008.54
          113           1-Jun-16      59,008.54     1,200.17    610.08     590.09     58,398.46
          114            1-Jul-16     58,398.46     1,200.17    616.18     583.98     57,782.28
          115          1-Aug-16       57,782.28     1,200.17    622.35     577.82     57,159.93
          116          1-Sep-16       57,159.93     1,200.17    628.57     571.60     56,531.36
          117           1-Oct-16      56,531.36     1,200.17    634.85     565.31     55,896.51
          118          1-Nov-16       55,896.51     1,200.17    641.20     558.97     55,255.31
          119          1-Dec-16       55,255.31     1,200.17    647.61     552.55     54,607.69
          120           1-Jan-17      54,607.69     1,200.17    654.09     546.08     53,953.60
          121          1-Feb-17       53,953.60     1,200.17    660.63     539.54     53,292.97
          122          1-Mar-17       53,292.97     1,200.17    667.24     532.93     52,625.73
          123           1-Apr-17      52,625.73     1,200.17    673.91     526.26     51,951.82
          124          1-May-17       51,951.82     1,200.17    680.65     519.52     51,271.17
          125           1-Jun-17      51,271.17     1,200.17    687.46     512.71     50,583.71
          126            1-Jul-17     50,583.71     1,200.17    694.33     505.84     49,889.38
          127          1-Aug-17       49,889.38     1,200.17    701.27     498.89     49,188.11
          128          1-Sep-17       49,188.11     1,200.17    708.29     491.88     48,479.82
          129           1-Oct-17      48,479.82     1,200.17    715.37     484.80     47,764.45
          130          1-Nov-17       47,764.45     1,200.17    722.52     477.64     47,041.93
          131          1-Dec-17       47,041.93     1,200.17    729.75     470.42     46,312.18
          132           1-Jan-18      46,312.18     1,200.17    737.05     463.12     45,575.13
          133          1-Feb-18       45,575.13     1,200.17    744.42     455.75     44,830.72
          134          1-Mar-18       44,830.72     1,200.17    751.86     448.31     44,078.86
          135           1-Apr-18      44,078.86     1,200.17    759.38     440.79     43,319.48
          136          1-May-18       43,319.48     1,200.17    766.97     433.19     42,552.50
          137           1-Jun-18      42,552.50     1,200.17    774.64     425.53     41,777.86
          138            1-Jul-18     41,777.86     1,200.17    782.39     417.78     40,995.47
          139          1-Aug-18       40,995.47     1,200.17    790.21     409.95     40,205.26
          140          1-Sep-18       40,205.26     1,200.17    798.12     402.05     39,407.14
          141           1-Oct-18      39,407.14     1,200.17    806.10     394.07     38,601.04
          142          1-Nov-18       38,601.04     1,200.17    814.16     386.01     37,786.89
          143          1-Dec-18       37,786.89     1,200.17    822.30     377.87     36,964.59
          144           1-Jan-19      36,964.59     1,200.17    830.52     369.65     36,134.07
          145          1-Feb-19       36,134.07     1,200.17    838.83     361.34     35,295.24
          146          1-Mar-19       35,295.24     1,200.17    847.22     352.95     34,448.02
          147           1-Apr-19      34,448.02     1,200.17    855.69     344.48     33,592.34
          148          1-May-19       33,592.34     1,200.17    864.24     335.92     32,728.09




1b6f460a-143a-44a0-8bbd-e3d191d4d326.xls       Page 3 of 4                        www.HomePlanGuru.com
                                  Beginning                                       Ending
          No. Payment Date        Balance       Payment      Principal Interest   Balance
          149           1-Jun-19      32,728.09     1,200.17    872.89     327.28     31,855.20
          150            1-Jul-19     31,855.20     1,200.17    881.62     318.55     30,973.59
          151          1-Aug-19       30,973.59     1,200.17    890.43     309.74     30,083.15
          152          1-Sep-19       30,083.15     1,200.17    899.34     300.83     29,183.82
          153           1-Oct-19      29,183.82     1,200.17    908.33     291.84     28,275.49
          154          1-Nov-19       28,275.49     1,200.17    917.41     282.75     27,358.08
          155          1-Dec-19       27,358.08     1,200.17    926.59     273.58     26,431.49
          156           1-Jan-20      26,431.49     1,200.17    935.85     264.31     25,495.63
          157          1-Feb-20       25,495.63     1,200.17    945.21     254.96     24,550.42
          158          1-Mar-20       24,550.42     1,200.17    954.66     245.50     23,595.76
          159           1-Apr-20      23,595.76     1,200.17    964.21     235.96     22,631.55
          160          1-May-20       22,631.55     1,200.17    973.85     226.32     21,657.70
          161           1-Jun-20      21,657.70     1,200.17    983.59     216.58     20,674.11
          162            1-Jul-20     20,674.11     1,200.17    993.43     206.74     19,680.68
          163          1-Aug-20       19,680.68     1,200.17  1,003.36     196.81     18,677.32
          164          1-Sep-20       18,677.32     1,200.17  1,013.39     186.77     17,663.92
          165           1-Oct-20      17,663.92     1,200.17  1,023.53     176.64     16,640.39
          166          1-Nov-20       16,640.39     1,200.17  1,033.76     166.40     15,606.63
          167          1-Dec-20       15,606.63     1,200.17  1,044.10     156.07     14,562.53
          168           1-Jan-21      14,562.53     1,200.17  1,054.54     145.63     13,507.98
          169          1-Feb-21       13,507.98     1,200.17  1,065.09     135.08     12,442.90
          170          1-Mar-21       12,442.90     1,200.17  1,075.74     124.43     11,367.16
          171           1-Apr-21      11,367.16     1,200.17  1,086.50     113.67     10,280.66
          172          1-May-21       10,280.66     1,200.17  1,097.36     102.81      9,183.30
          173           1-Jun-21       9,183.30     1,200.17  1,108.34      91.83      8,074.96
          174            1-Jul-21      8,074.96     1,200.17  1,119.42      80.75      6,955.55
          175          1-Aug-21        6,955.55     1,200.17  1,130.61      69.56      5,824.93
          176          1-Sep-21        5,824.93     1,200.17  1,141.92      58.25      4,683.01
          177           1-Oct-21       4,683.01     1,200.17  1,153.34      46.83      3,529.68
          178          1-Nov-21        3,529.68     1,200.17  1,164.87      35.30      2,364.81
          179          1-Dec-21        2,364.81     1,200.17  1,176.52      23.65      1,188.29
          180           1-Jan-22       1,188.29     1,200.17  1,188.29      11.88          0.00




1b6f460a-143a-44a0-8bbd-e3d191d4d326.xls       Page 4 of 4                        www.HomePlanGuru.com

				
DOCUMENT INFO