Docstoc

Mortgage Payment Calculator - Excel Templates

Document Sample
Mortgage Payment Calculator - Excel Templates Powered By Docstoc
					To use this Mortgage Payment calculator, fill-in the yellow shaded cells. Your mortgage amortization schedule will complete auto



Rebuz Mortgage Payment Calculator                                     Mortgage Terms Glossary
                                              Inputs                                           Key Loan Figures
Loan principal amount                   $250,000.00                   Annual loan payments
Annual interest rate (x.xxx%)           7.000%                        Monthly payments
Loan period in years                    30                            Interest in first calendar year
Base year of loan                       2006                          Interest over term of loan
Base month of loan                      7                             Sum of all payments

Payments in First Year
                       Beginning        Mortgage                                      Cumulative     Cumulative
Year   Month                                            Principal     Interest
                       Balance          Payment                                       Principal Paid Interest
                                                                                                     Paid
2006   Jan                $250,000.00       $1,663.26       $204.93       $1,458.33         $204.93    $1,458.33
       Feb                $249,795.07       $1,663.26       $206.12       $1,457.14         $411.05    $2,915.47
       Mar                $249,588.95       $1,663.26       $207.32       $1,455.94         $618.37    $4,371.41
       Apr                $249,381.63       $1,663.26       $208.53       $1,454.73         $826.90    $5,826.14
       May                $249,173.10       $1,663.26       $209.75       $1,453.51       $1,036.65    $7,279.65
       Jun                $248,963.35       $1,663.26       $210.97       $1,452.29       $1,247.62    $8,731.94
       Jul                $248,752.38       $1,663.26       $212.20       $1,451.06       $1,459.82 $10,183.00
       Aug                $248,540.18       $1,663.26       $213.44       $1,449.82       $1,673.26 $11,632.82
       Sep                $248,326.74       $1,663.26       $214.69       $1,448.57       $1,887.95 $13,081.39
       Oct                $248,112.05       $1,663.26       $215.94       $1,447.32       $2,103.89 $14,528.71
       Nov                $247,896.11       $1,663.26       $217.20       $1,446.06       $2,321.09 $15,974.77
       Dec                $247,678.91       $1,663.26       $218.47       $1,444.79       $2,539.56 $17,419.56

Yearly Schedule of Balances and Payments
       Beginning                                                Cumulative Cumulative                 Ending
Year                  Payment       Principal      Interest
       Balance                                                  Principal      Interest Paid          Balance
2007     $247,460.44     $19,959.12      $2,722.52 $17,236.60 Paid $5,262.08       $34,656.16          $244,737.92
2008     $244,737.92     $19,959.12      $2,919.97 $17,039.15        $8,182.05     $51,695.31          $241,817.95
2009     $241,817.95     $19,959.12      $3,131.05 $16,828.07       $11,313.10     $68,523.38          $238,686.90
2010     $238,686.90     $19,959.12      $3,357.40 $16,601.72       $14,670.49     $85,125.11          $235,329.51
2011     $235,329.51     $19,959.12      $3,600.10 $16,359.02       $18,270.60    $101,484.12          $231,729.40
2012     $231,729.40     $19,959.12      $3,860.35 $16,098.77       $22,130.95    $117,582.89          $227,869.05
2013     $227,869.05     $19,959.12      $4,139.42 $15,819.70       $26,270.37    $133,402.59          $223,729.63
2014     $223,729.63     $19,959.12      $4,438.66 $15,520.46       $30,709.03    $148,923.05          $219,290.97
2015     $219,290.97     $19,959.12      $4,759.53 $15,199.59       $35,468.56    $164,122.64          $214,531.44
2016     $214,531.44     $19,959.12      $5,103.60 $14,855.52       $40,572.15    $178,978.17          $209,427.85
2017     $209,427.85     $19,959.12      $5,472.54 $14,486.58       $46,044.69    $193,464.75          $203,955.31
2018     $203,955.31     $19,959.12      $5,868.15 $14,090.97       $51,912.83    $207,555.73          $198,087.17
2019     $198,087.17     $19,959.12      $6,292.35 $13,666.77       $58,205.19    $221,222.49          $191,794.81
2020     $191,794.81     $19,959.12      $6,747.23 $13,211.89       $64,952.42    $234,434.38          $185,047.58
2021     $185,047.58     $19,959.12      $7,234.99 $12,724.13       $72,187.40    $247,158.52          $177,812.60
2022     $177,812.60     $19,959.12      $7,758.00 $12,201.12       $79,945.41    $259,359.63          $170,054.59
2023     $170,054.59     $19,959.12      $8,318.83 $11,640.29       $88,264.24    $270,999.92          $161,735.76
2024     $161,735.76     $19,959.12      $8,920.20 $11,038.92       $97,184.44    $282,038.84          $152,815.56
2025     $152,815.56     $19,959.12      $9,565.04 $10,394.08     $106,749.48     $292,432.92          $143,250.52
2026     $143,250.52     $19,959.12     $10,256.50    $9,702.62   $117,005.98     $302,135.54          $132,994.02
2027     $132,994.02     $19,959.12     $10,997.94    $8,961.18   $128,003.92     $311,096.72          $121,996.08
2028     $121,996.08     $19,959.12     $11,792.99    $8,166.13   $139,796.91     $319,262.85          $110,203.09
2029     $110,203.09     $19,959.12     $12,645.50    $7,313.62   $152,442.41     $326,576.47           $97,557.59
2030       $97,557.59    $19,959.12     $13,559.65    $6,399.47   $166,002.05     $332,975.95           $83,997.95
2031       $83,997.95    $19,959.12     $14,539.87    $5,419.25   $180,541.93     $338,395.19           $69,458.07
2032       $69,458.07    $19,959.12     $15,590.96    $4,368.16   $196,132.89     $342,763.35           $53,867.11
2033       $53,867.11    $19,959.12     $16,718.03    $3,241.09   $212,850.92     $346,004.44           $37,149.08
2034       $37,149.08    $19,959.12     $17,926.58    $2,032.54   $230,777.50     $348,036.98           $19,222.50
2035       $19,222.50    $19,959.12     $19,222.50      $736.62   $250,000.00     $348,773.60                $0.00
yellow shaded cells. Your mortgage amortization schedule will complete automatically.




                                  Key Loan Figures
                                                             $19,959.12
                                                              $1,663.26
                                                             $17,419.56
                                                            $348,773.60
                                                            $598,773.60



                                                         Ending
                                                         Balance
                                                            $249,795.07
                                                            $249,588.95
                                                            $249,381.63
                                                            $249,173.10
                                                            $248,963.35
                                                            $248,752.38
                                                            $248,540.18
                                                            $248,326.74
                                                            $248,112.05
                                                            $247,896.11
                                                            $247,678.91
                                                            $247,460.44

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