Loan or Mortgage Calculator by ltedprosser

VIEWS: 118 PAGES: 3

More Info
									                                         Loan or Mortgage Calculator




                       Enter Values                                                     Loan Summary

                         Loan Amount $       260,000.00                                 Scheduled Payment $          2,537.21

                 Annual Interest Rate           6.00 %                       Scheduled Number of Payments                 144

                Loan Period in Years                12                           Actual Number of Payments                144

        Number of Payments Per Year                 12                                 Total Early Payments $             -

                       Loan Start Date        11/1/2010                                           Total Interest $ 105,358.32

             Optional Extra Payments                                                   Total Amount To Pay $ 365,358.32

                                                                                              Saved Interest $          (0.00)

      Lender Name: MY BANK                                                             Total Saved Amount $             (0.00)



Pmt      Payment         Beginning           Scheduled        Extra                                                                   Ending
No.      Date            Balance             Payment          Payment       Total Payment           Principal       Interest          Balance
  1 $    40,513.00 $      260,000.00     $     2,537.21   $        -    $          2,537.21   $      1,237.21   $    1,300.00    $   258,762.79
  2        1/1/2011       258,762.79           2,537.21            -               2,537.21          1,243.40        1,293.81        257,519.39
  3        2/1/2011       257,519.39           2,537.21            -               2,537.21          1,249.61        1,287.60        256,269.78
  4        3/1/2011       256,269.78           2,537.21            -               2,537.21          1,255.86        1,281.35        255,013.92
  5        4/1/2011       255,013.92           2,537.21            -               2,537.21          1,262.14        1,275.07        253,751.78
  6        5/1/2011       253,751.78           2,537.21            -               2,537.21          1,268.45        1,268.76        252,483.32
  7        6/1/2011       252,483.32           2,537.21            -               2,537.21          1,274.79        1,262.42        251,208.53
  8        7/1/2011       251,208.53           2,537.21            -               2,537.21          1,281.17        1,256.04        249,927.36
  9        8/1/2011       249,927.36           2,537.21            -               2,537.21          1,287.57        1,249.64        248,639.79
 10        9/1/2011       248,639.79           2,537.21            -               2,537.21          1,294.01        1,243.20        247,345.78
 11       10/1/2011       247,345.78           2,537.21            -               2,537.21          1,300.48        1,236.73        246,045.30
 12       11/1/2011       246,045.30           2,537.21            -               2,537.21          1,306.98        1,230.23        244,738.31
 13       12/1/2011       244,738.31           2,537.21            -               2,537.21          1,313.52        1,223.69        243,424.79
 14        1/1/2012       243,424.79           2,537.21            -               2,537.21          1,320.09        1,217.12        242,104.71
 15        2/1/2012       242,104.71           2,537.21            -               2,537.21          1,326.69        1,210.52        240,778.02
 16        3/1/2012       240,778.02           2,537.21            -               2,537.21          1,333.32        1,203.89        239,444.70
 17        4/1/2012       239,444.70           2,537.21            -               2,537.21          1,339.99        1,197.22        238,104.71
 18        5/1/2012       238,104.71           2,537.21            -               2,537.21          1,346.69        1,190.52        236,758.02
 19        6/1/2012       236,758.02           2,537.21            -               2,537.21          1,353.42        1,183.79        235,404.60
 20        7/1/2012       235,404.60           2,537.21            -               2,537.21          1,360.19        1,177.02        234,044.42
 21        8/1/2012       234,044.42           2,537.21            -               2,537.21          1,366.99        1,170.22        232,677.43
 22        9/1/2012       232,677.43           2,537.21            -               2,537.21          1,373.82        1,163.39        231,303.61
 23       10/1/2012       231,303.61           2,537.21            -               2,537.21          1,380.69        1,156.52        229,922.91
 24       11/1/2012       229,922.91           2,537.21            -               2,537.21          1,387.60        1,149.61        228,535.32
 25       12/1/2012       228,535.32           2,537.21            -               2,537.21          1,394.53        1,142.68        227,140.78
 26        1/1/2013       227,140.78           2,537.21            -               2,537.21          1,401.51        1,135.70        225,739.28
 27        2/1/2013       225,739.28           2,537.21            -               2,537.21          1,408.51        1,128.70        224,330.76
 28        3/1/2013       224,330.76           2,537.21            -               2,537.21          1,415.56        1,121.65        222,915.20
 29        4/1/2013       222,915.20           2,537.21            -               2,537.21          1,422.63        1,114.58        221,492.57
 30        5/1/2013       221,492.57           2,537.21            -               2,537.21          1,429.75        1,107.46        220,062.82
 31        6/1/2013       220,062.82           2,537.21            -               2,537.21          1,436.90        1,100.31        218,625.93
 32        7/1/2013       218,625.93           2,537.21            -               2,537.21          1,444.08        1,093.13        217,181.85
 33        8/1/2013       217,181.85           2,537.21            -               2,537.21          1,451.30        1,085.91        215,730.54
 34        9/1/2013       215,730.54           2,537.21            -               2,537.21          1,458.56        1,078.65        214,271.99
 35       10/1/2013       214,271.99           2,537.21            -               2,537.21          1,465.85        1,071.36        212,806.14
 36       11/1/2013       212,806.14           2,537.21            -               2,537.21          1,473.18        1,064.03        211,332.96
 37       12/1/2013       211,332.96           2,537.21            -               2,537.21          1,480.55        1,056.66        209,852.41
 38        1/1/2014       209,852.41           2,537.21            -               2,537.21          1,487.95        1,049.26        208,364.46
 39        2/1/2014       208,364.46           2,537.21            -               2,537.21          1,495.39        1,041.82        206,869.07
 40        3/1/2014       206,869.07           2,537.21            -               2,537.21          1,502.87        1,034.35        205,366.21
 41        4/1/2014       205,366.21           2,537.21            -               2,537.21          1,510.38        1,026.83        203,855.83
 42        5/1/2014       203,855.83           2,537.21            -               2,537.21          1,517.93        1,019.28        202,337.90
 43        6/1/2014       202,337.90           2,537.21            -               2,537.21          1,525.52        1,011.69        200,812.38
 44        7/1/2014       200,812.38           2,537.21            -               2,537.21          1,533.15        1,004.06        199,279.23
 45        8/1/2014       199,279.23           2,537.21            -               2,537.21          1,540.81          996.40        197,738.41
 46        9/1/2014       197,738.41           2,537.21            -               2,537.21          1,548.52          988.69        196,189.89
 47       10/1/2014       196,189.89           2,537.21            -               2,537.21          1,556.26          980.95        194,633.63
 48       11/1/2014       194,633.63           2,537.21            -               2,537.21          1,564.04          973.17        193,069.59
 49       12/1/2014       193,069.59           2,537.21            -               2,537.21          1,571.86          965.35        191,497.73
 50        1/1/2015       191,497.73           2,537.21            -               2,537.21          1,579.72          957.49        189,918.01
 51        2/1/2015       189,918.01           2,537.21            -               2,537.21          1,587.62          949.59        188,330.39
 52        3/1/2015       188,330.39           2,537.21            -               2,537.21          1,595.56          941.65        186,734.83
Pmt   Payment     Beginning    Scheduled   Extra                                                Ending
No.   Date        Balance      Payment     Payment   Total Payment     Principal   Interest     Balance
 53    4/1/2015   186,734.83    2,537.21        -           2,537.21   1,603.54       933.67   185,131.29
 54    5/1/2015   185,131.29    2,537.21        -           2,537.21   1,611.55       925.66   183,519.74
 55    6/1/2015   183,519.74    2,537.21        -           2,537.21   1,619.61       917.60   181,900.12
 56    7/1/2015   181,900.12    2,537.21        -           2,537.21   1,62
								
To top