Docstoc

biweekly-mortgage-calculator_1_

Document Sample
biweekly-mortgage-calculator_1_ Powered By Docstoc
					                             Bi-weekly Mortgage Calculator: This calculator shows the differences between a
                             weekly mortgage payment. Fill in the information in the white box, and your results
                             a visual representation of the differences between the two payment methods, see t


                                                                                   Principal vs. Interest: Mont
                                                                      $1,000.00
                                                                       $900.00
          Amount of mortgage $                 150,000                 $800.00
               Down payment $                   20,000                 $700.00




                                                            Payment
                                                                       $600.00
           Annual interest rate                  8.00%                 $500.00
      Term of mortgage (years)                       30                $400.00
                                                                       $300.00
              Monthly payment                  $947.58                 $200.00
                                                                       $100.00
                                                                          $0.00
            Total principal paid $             150,000
             Total interest paid $             191,128
               Grand total paid $              341,128


             Biweekly payment      $            473.79
          Number of payments                    596.86
  New term of mortgage (years)                   22.89                            Principal vs. Interest: Bi
New term of mortgage (months)                   274.72                $500.00
            Total principal paid   $        150,000.00                $450.00
                                                                      $400.00
             Total interest paid   $        132,784.70      Payment   $350.00
               Grand total paid    $        282,784.70                $300.00
                                                                      $250.00
                                                                      $200.00
Savings with biweekly payment      $       58,342.94                  $150.00
                                                                      $100.00
       Time savings in years                                           $50.00
       with biweekly payment                   7.11                       $-
s the differences between a monthly mortgage payment and a bi-
 white box, and your results will show up in the remaining boxes. For
wo payment methods, see the graphs at the right.


rincipal vs. Interest: Monthly Payment

                                                           Year
                                                             1             2            3           4         5
                                                           Principal
                                                            $860.05      $852.26       $843.83    $834.69   $824.80
                                                           Interest
                                                              $87.52      $95.31       $103.75    $112.88   $122.78




                     Year


                                                             1             2            3           4          5
                                                       $     391.63     $ 384.82   $    377.45   $ 369.46   $ 360.81
rincipal vs. Interest: Bi-weekly Payment               $       82.16    $ 88.97    $     96.34   $ 104.33   $ 112.98



                                                           Principal
                                                           Interest




                    Year
  6          7          8          9          10         11         12         13         14
$814.08    $802.48    $789.91    $776.30    $761.56    $745.60    $728.31    $709.59    $689.31
$133.49    $145.10    $157.66    $171.27    $186.01    $201.98    $219.27    $237.99    $258.27




   6          7          8          9          10         11         12         13         14
$ 351.45   $ 341.31   $ 330.33   $ 318.43   $ 305.56   $ 291.61   $ 276.51   $ 260.15   $ 242.44
$ 122.34   $ 132.48   $ 143.46   $ 155.35   $ 168.23   $ 182.18   $ 197.28   $ 213.64   $ 231.35
  15         16         17         18         19         20         21         22         23
$667.35    $643.57    $617.81    $589.92    $559.71    $526.99    $491.56    $453.18    $411.62
$280.23    $304.01    $329.77    $357.66    $387.87    $420.59    $456.02    $494.40    $535.95




   15         16         17         18         19         20         21         22
$ 223.26   $ 202.49   $ 180.00   $ 155.64   $ 129.27   $ 100.70   $ 69.77    $ 36.27
$ 250.53   $ 271.30   $ 293.79   $ 318.15   $ 344.52   $ 373.09   $ 404.02   $ 437.51
  24        25        26        27        28        29        30
$366.61   $317.87   $265.08   $207.91   $145.99    $78.94     $6.32
$580.96   $629.71   $682.50   $739.67   $801.58   $868.64   $941.26
Dear Friend,

   Thanks for downloading this Excel personal finance spreadsheet. It
gives me a real thrill to know that I've made something that people find
useful and that benefits them.


   Since you've downloaded and actually opened this spreadsheet, you're
probably concerned about paying off your mortgage as quickly as possible.
The Biweekly Payment system is great, but there's another technique that
blows biweekly payments out of the water. It's called Mortgage Cycling .

   Mortage Cycling Revealed is an insider guide to paying off your mortgage
in 10 years or less, while building much more equity than with a biweekly
mortgage payment.

  To find out more about the secrets of Mortgage Cycling, please click on
the picture below.

  Sincerely,


 Sean Payne
 adsheet. It
 people find



dsheet, you're
 kly as possible.
technique that
gage Cycling .

ff your mortgage
ith a biweekly


please click on

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:1
posted:5/17/2012
language:English
pages:11
fanzhongqing fanzhongqing http://
About