Docstoc

Mortgage Calculator _ Planner Demo

Document Sample
Mortgage Calculator _ Planner Demo Powered By Docstoc
					                                                                                                       Questions?
                                                                                         Email us at demo@simpleplanning




  Budget Planner - Overview

                                                                                                Mortgage
Instructions                                                                                    Calculator
You may move from worksheet to worksheet by clicking on the dark blue buttons
located at the top of each worksheet or the blue tabs at the bottom of this workbook.         Down Payment
                                                                                               Savings Calc
Enter data in only the white cells with gray borders:     $400

Mortgage Calculator
Calculate your monthly mortgage payment, the total loan payment over the life of the loan and well as the full interest p
This calculator requires only four variables: purchase price, down payment, interest rate, and loan term (yrs)
Interest and principal payment detail is illustrated for you via the graph on the right side of the worksheet.

Amortization Schedule
Based off of your assumptions used on the "Mortgage Calculator" tab, this sheet lays out each payment over the life of
At the beginning of the loan, you will see that most of your dollars go to covering the interest. In the out years, more an
of your payment goes to paying down the principal.

Loan Optimizer
Choose the best loan scenario for your personal needs. This worksheet calculates over 300 different mortgage scena
purchase price, down payment, down payment increment, interest rate, interest rate increment, and loan term.

Down Payment Savings Calculator
This three in one savings calculator solves for the following based on your selection:
How much will my savings grow to?
How much do I need to save each month?
How long will it take to save enough?

Affordability Calculator
Use this calculator to determine how much house you can afford based off of your income and current debt (car loan,
You may choose your own housing cost-to-income ratio as well as the debt-to-income ratio (the industry standard is 28

Refinance Calculator
Based on your old/current mortgage and your new/potential mortgage, this worksheet will calculate your monthly mortg
how much you will save over the life of the new loan and how many years until the refinancing costs are recouped.

Financial Calculators available at www.simpleplanning.com
    - Budget Planner               - Mortgage Calculator
    - Investment Calculator        - Tax Calculator
    - Retirement Planner           - 401k Calculator

Software License Agreement
Simpleplannings.com grants usage of this financial planning "software" under the following terms and conditions:
After the purchasing and downloading of this software from Simpleplanning.com, the purchaser is granted a "license" t
The "licensee" may make copies of this product in an amount that does not exceed the number of licenses originally p
Simpleplanning.com, or for the purpose of creating a backup copy.
This file or the software contained in this file shall not be transferred to a non-licensee without the written consent from

Limitation of Liability
Simpleplanning.com will not be held liable for damages in the event of, but not limited to inaccurate assumptions, calcu
software, hardware, data and network failure and profit/savings losses as a result of using this software.
         Questions?
       demo@simpleplanning.com




    Mortgage       Amortization
                                   Loan Optimizer
    Calculator      Schedule


  Down Payment     Affordability     Refinance
   Savings Calc     Calculator       Calculator




n and well as the full interest payment.
 and loan term (yrs)
f the worksheet.


each payment over the life of the loan.
est. In the out years, more and more



300 different mortgage scenarios based on your inputs:
ement, and loan term.




e and current debt (car loan, credit cards, etc.)
tio (the industry standard is 28% and 36%, respectively)


l calculate your monthly mortgage reduction,
ncing costs are recouped.




ng terms and conditions:
chaser is granted a "license" to use this product.
umber of licenses originally purchased from

thout the written consent from Simpleplanning.com.


inaccurate assumptions, calculation errors,
g this software.
   Mortgage        Amortization                        Down Payment    Affordability       Refinance
                                      Loan Optimizer                                                               Overview
   Calculator       Schedule                            Savings Calc    Calculator         Calculator




                Mortgage Calculator
                                                                                                                       Interest and Pricipal
Mortgage Assumptions                                                       $14,000

Purchase Price                                    $      200,000           $12,000
Down Payment                                      $       20,000
Term of Loan (30 yrs, 15 yrs, etc.)                            30          $10,000

Annual Interest Rate                                        6.00%
                                                                            $8,000


                                                                            $6,000
Results

Monthly Payment                                   $        1,079            $4,000

Total Home Loan Amount                            $     180,000
                                                                            $2,000
Total Loan Payment                                $     388,509
Total Interest                                    $     208,509                  $0
                                                                                       1   2   3   4   5   6   7   8   9 10


   See Amortization Schedule
Overview




  Interest and Pricipal Paid
           Interest     Principal




    10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30

                      Year
   Mortgage      Amortization                     Down Payment         Affordability     Refinance
                                Loan Optimizer                                                             Overview
   Calculator     Schedule                         Savings Calc         Calculator       Calculator




           Yearly Amortization Schedule                                        See Mortgage
                                                                                Calculator             Monthly Amortizatio

        Beginning      Mortgage       Interest      Principal         Ending                           Beginning
Year     Balance         Pmt            Paid          Paid            Balance            Month          Balance
  1    $ 180,000     $     12,950   $ 10,740      $      2,210    $     177,790            1          $ 180,000
  2    $ 177,790     $     12,950   $ 10,604      $      2,347    $     175,443            2          $ 179,821
  3    $ 175,443     $     12,950   $ 10,459      $      2,491    $     172,951            3          $ 179,641
  4    $ 172,951     $     12,950   $ 10,305      $      2,645    $     170,306            4          $ 179,460
  5    $ 170,306     $     12,950   $ 10,142      $      2,808    $     167,498            5          $ 179,278
  6    $ 167,498     $     12,950   $     9,969   $      2,982    $     164,516            6          $ 179,095
  7    $ 164,516     $     12,950   $     9,785   $      3,165    $     161,351            7          $ 178,911
  8    $ 161,351     $     12,950   $     9,590   $      3,361    $     157,990            8          $ 178,727
  9    $ 157,990     $     12,950   $     9,382   $      3,568    $     154,422            9          $ 178,541
 10    $ 154,422     $     12,950   $     9,162   $      3,788    $     150,634           10          $ 178,355
 11    $ 150,634     $     12,950   $     8,929   $      4,022    $     146,613           11          $ 178,167
 12    $ 146,613     $     12,950   $     8,681   $      4,270    $     142,343           12          $ 177,979
 13    $ 142,343     $     12,950   $     8,417   $      4,533    $     137,810           13          $ 177,790
 14    $ 137,810     $     12,950   $     8,138   $      4,813    $     132,997           14          $ 177,599
 15    $ 132,997     $     12,950   $     7,841   $      5,109    $     127,888           15          $ 177,408
 16    $ 127,888     $     12,950   $     7,526   $      5,425    $     122,463           16          $ 177,216
 17    $ 122,463     $     12,950   $     7,191   $      5,759    $     116,704           17          $ 177,023
 18    $ 116,704     $     12,950   $     6,836   $      6,114    $     110,590           18          $ 176,829
 19    $ 110,590     $     12,950   $     6,459   $      6,491    $     104,098           19          $ 176,634
 20    $ 104,098     $     12,950   $     6,058   $      6,892    $      97,206           20          $ 176,438
 21    $    97,206   $     12,950   $     5,633   $      7,317    $      89,890           21          $ 176,241
 22    $    89,890   $     12,950   $     5,182   $      7,768    $      82,121           22          $ 176,043
 23    $    82,121   $     12,950   $     4,703   $      8,247    $      73,874           23          $ 175,844
 24    $    73,874   $     12,950   $     4,194   $      8,756    $      65,118           24          $ 175,644
 25    $    65,118   $     12,950   $     3,654   $      9,296    $      55,822           25          $ 175,443
 26    $    55,822   $     12,950   $     3,081   $      9,869    $      45,952           26          $ 175,241
 27    $    45,952   $     12,950   $     2,472   $     10,478    $      35,474           27          $ 175,038
 28    $    35,474   $     12,950   $     1,826   $     11,124    $      24,350           28          $ 174,834
 29    $    24,350   $     12,950   $     1,140   $     11,811    $      12,539           29          $ 174,629
 30    $    12,539   $     12,950   $       411   $     12,539    $           (0)         30          $ 174,423
                                                                                          31          $ 174,216
                                                                                          32          $ 174,008
                                                                                          33          $ 173,798
                                                                                          34          $ 173,588
                                                                                          35          $ 173,377
                                                                                          36          $ 173,165
                                                                                          37          $ 172,951
                                                                                          38          $ 172,737
                                                                                          39          $ 172,521
                                                                                          40          $ 172,305
                                                                                          41          $ 172,087
                                                                                          42          $ 171,868
                                                                                          43          $ 171,649
                                                                                          44          $ 171,428
                                                                                          45          $ 171,206
 46   $   170,982
 47   $   170,758
 48   $   170,533
 49   $   170,306
 50   $   170,078
 51   $   169,850
 52   $   169,620
 53   $   169,389
 54   $   169,156
 55   $   168,923
 56   $   168,688
 57   $   168,453
 58   $   168,216
 59   $   167,978
 60   $   167,738
 61   $   167,498
 62   $   167,256
 63   $   167,013
 64   $   166,769
 65   $   166,524
 66   $   166,277
 67   $   166,029
 68   $   165,780
 69   $   165,530
 70   $   165,279
 71   $   165,026
 72   $   164,772
 73   $   164,516
 74   $   164,260
 75   $   164,002
 76   $   163,743
 77   $   163,482
 78   $   163,220
 79   $   162,957
 80   $   162,693
 81   $   162,427
 82   $   162,160
 83   $   161,892
 84   $   161,622
 85   $   161,351
 86   $   161,078
 87   $   160,805
 88   $   160,529
 89   $   160,253
 90   $   159,975
 91   $   159,696
 92   $   159,415
 93   $   159,133
 94   $   158,849
 95   $   158,564
 96   $   158,278
 97   $   157,990
 98   $   157,701
 99   $   157,410
100   $   157,118
101   $   156,825
102   $   156,530
103   $   156,233
104   $   155,935
105   $   155,635
106   $   155,334
107   $   155,032
108   $   154,728
109   $   154,422
110   $   154,115
111   $   153,807
112   $   153,496
113   $   153,185
114   $   152,871
115   $   152,557
116   $   152,240
117   $   151,922
118   $   151,603
119   $   151,281
120   $   150,959
121   $   150,634
122   $   150,308
123   $   149,981
124   $   149,651
125   $   149,320
126   $   148,988
127   $   148,654
128   $   148,318
129   $   147,980
130   $   147,641
131   $   147,300
132   $   146,957
133   $   146,613
134   $   146,267
135   $   145,919
136   $   145,569
137   $   145,218
138   $   144,865
139   $   144,510
140   $   144,153
141   $   143,795
142   $   143,434
143   $   143,072
144   $   142,709
145   $   142,343
146   $   141,976
147   $   141,606
148   $   141,235
149   $   140,862
150   $   140,487
151   $   140,110
152   $   139,732
153   $   139,351
154   $   138,969
155   $   138,584
156   $   138,198
157   $   137,810
158   $   137,420
159   $   137,028
160   $   136,634
161   $   136,238
162   $   135,840
163   $   135,440
164   $   135,038
165   $   134,634
166   $   134,228
167   $   133,820
168   $   133,410
169   $   132,997
170   $   132,583
171   $   132,167
172   $   131,749
173   $   131,328
174   $   130,906
175   $   130,481
176   $   130,054
177   $   129,625
178   $   129,194
179   $   128,761
180   $   128,325
181   $   127,888
182   $   127,448
183   $   127,006
184   $   126,562
185   $   126,116
186   $   125,667
187   $   125,216
188   $   124,763
189   $   124,308
190   $   123,850
191   $   123,390
192   $   122,928
193   $   122,463
194   $   121,996
195   $   121,527
196   $   121,056
197   $   120,582
198   $   120,106
199   $   119,627
200   $   119,146
201   $   118,662
202   $   118,176
203   $   117,688
204   $   117,197
205   $   116,704
206   $   116,209
207   $   115,710
208   $   115,210
209   $   114,707
210   $   114,201
211   $   113,693
212   $   113,182
213   $   112,669
214   $   112,153
215   $   111,634
216   $   111,113
217   $   110,590
218   $   110,064
219   $   109,535
220   $   109,003
221   $   108,469
222   $   107,932
223   $   107,393
224   $   106,850
225   $   106,305
226   $   105,758
227   $   105,207
228   $   104,654
229   $   104,098
230   $   103,540
231   $   102,978
232   $   102,414
233   $   101,847
234   $   101,277
235   $   100,704
236   $   100,128
237   $    99,550
238   $    98,968
239   $    98,384
240   $    97,797
241   $    97,206
242   $    96,613
243   $    96,017
244   $    95,418
245   $    94,816
246   $    94,211
247   $    93,603
248   $    92,992
249   $    92,377
250   $    91,760
251   $    91,140
252   $    90,516
253   $    89,890
254   $    89,260
255   $    88,627
256   $    87,991
257   $    87,352
258   $    86,709
259   $    86,064
260   $    85,415
261   $    84,763
262   $    84,107
263   $    83,448
264   $    82,787
265   $    82,121
266   $   81,453
267   $   80,781
268   $   80,105
269   $   79,427
270   $   78,745
271   $   78,059
272   $   77,370
273   $   76,678
274   $   75,982
275   $   75,283
276   $   74,580
277   $   73,874
278   $   73,164
279   $   72,451
280   $   71,734
281   $   71,013
282   $   70,289
283   $   69,561
284   $   68,830
285   $   68,095
286   $   67,356
287   $   66,614
288   $   65,868
289   $   65,118
290   $   64,364
291   $   63,607
292   $   62,846
293   $   62,081
294   $   61,312
295   $   60,539
296   $   59,763
297   $   58,982
298   $   58,198
299   $   57,410
300   $   56,618
301   $   55,822
302   $   55,022
303   $   54,218
304   $   53,409
305   $   52,597
306   $   51,781
307   $   50,961
308   $   50,136
309   $   49,308
310   $   48,475
311   $   47,638
312   $   46,797
313   $   45,952
314   $   45,103
315   $   44,249
316   $   43,391
317   $   42,529
318   $   41,662
319   $   40,792
320   $   39,916
321   $   39,037
322   $   38,153
323   $   37,264
324   $   36,371
325   $   35,474
326   $   34,572
327   $   33,666
328   $   32,755
329   $   31,840
330   $   30,920
331   $   29,995
332   $   29,066
333   $   28,132
334   $   27,193
335   $   26,250
336   $   25,302
337   $   24,350
338   $   23,392
339   $   22,430
340   $   21,463
341   $   20,491
342   $   19,514
343   $   18,533
344   $   17,546
345   $   16,555
346   $   15,558
347   $   14,557
348   $   13,550
349   $   12,539
350   $   11,523
351   $   10,501
352   $    9,474
353   $    8,442
354   $    7,405
355   $    6,363
356   $    5,316
357   $    4,263
358   $    3,205
359   $    2,142
360   $    1,074
  Overview




Monthly Amortization Schedule
                                                                   Interest
           Mortgage      Interest     Principal        Ending
             Pmt           Paid         Paid           Balance            6.00%
         $      1,079   $     900   $        179   $     179,821
         $      1,079   $     899   $        180   $     179,641
         $      1,079   $     898   $        181   $     179,460
         $      1,079   $     897   $        182   $     179,278
         $      1,079   $     896   $        183   $     179,095
         $      1,079   $     895   $        184   $     178,911
         $      1,079   $     895   $        185   $     178,727
         $      1,079   $     894   $        186   $     178,541
         $      1,079   $     893   $        186   $     178,355
         $      1,079   $     892   $        187   $     178,167
         $      1,079   $     891   $        188   $     177,979
         $      1,079   $     890   $        189   $     177,790
         $      1,079   $     889   $        190   $     177,599
         $      1,079   $     888   $        191   $     177,408
         $      1,079   $     887   $        192   $     177,216
         $      1,079   $     886   $        193   $     177,023
         $      1,079   $     885   $        194   $     176,829
         $      1,079   $     884   $        195   $     176,634
         $      1,079   $     883   $        196   $     176,438
         $      1,079   $     882   $        197   $     176,241
         $      1,079   $     881   $        198   $     176,043
         $      1,079   $     880   $        199   $     175,844
         $      1,079   $     879   $        200   $     175,644
         $      1,079   $     878   $        201   $     175,443
         $      1,079   $     877   $        202   $     175,241
         $      1,079   $     876   $        203   $     175,038
         $      1,079   $     875   $        204   $     174,834
         $      1,079   $     874   $        205   $     174,629
         $      1,079   $     873   $        206   $     174,423
         $      1,079   $     872   $        207   $     174,216
         $      1,079   $     871   $        208   $     174,008
         $      1,079   $     870   $        209   $     173,798
         $      1,079   $     869   $        210   $     173,588
         $      1,079   $     868   $        211   $     173,377
         $      1,079   $     867   $        212   $     173,165
         $      1,079   $     866   $        213   $     172,951
         $      1,079   $     865   $        214   $     172,737
         $      1,079   $     864   $        216   $     172,521
         $      1,079   $     863   $        217   $     172,305
         $      1,079   $     862   $        218   $     172,087
         $      1,079   $     860   $        219   $     171,868
         $      1,079   $     859   $        220   $     171,649
         $      1,079   $     858   $        221   $     171,428
         $      1,079   $     857   $        222   $     171,206
         $      1,079   $     856   $        223   $     170,982
$   1,079   $   855   $   224   $   170,758
$   1,079   $   854   $   225   $   170,533
$   1,079   $   853   $   227   $   170,306
$   1,079   $   852   $   228   $   170,078
$   1,079   $   850   $   229   $   169,850
$   1,079   $   849   $   230   $   169,620
$   1,079   $   848   $   231   $   169,389
$   1,079   $   847   $   232   $   169,156
$   1,079   $   846   $   233   $   168,923
$   1,079   $   845   $   235   $   168,688
$   1,079   $   843   $   236   $   168,453
$   1,079   $   842   $   237   $   168,216
$   1,079   $   841   $   238   $   167,978
$   1,079   $   840   $   239   $   167,738
$   1,079   $   839   $   240   $   167,498
$   1,079   $   837   $   242   $   167,256
$   1,079   $   836   $   243   $   167,013
$   1,079   $   835   $   244   $   166,769
$   1,079   $   834   $   245   $   166,524
$   1,079   $   833   $   247   $   166,277
$   1,079   $   831   $   248   $   166,029
$   1,079   $   830   $   249   $   165,780
$   1,079   $   829   $   250   $   165,530
$   1,079   $   828   $   252   $   165,279
$   1,079   $   826   $   253   $   165,026
$   1,079   $   825   $   254   $   164,772
$   1,079   $   824   $   255   $   164,516
$   1,079   $   823   $   257   $   164,260
$   1,079   $   821   $   258   $   164,002
$   1,079   $   820   $   259   $   163,743
$   1,079   $   819   $   260   $   163,482
$   1,079   $   817   $   262   $   163,220
$   1,079   $   816   $   263   $   162,957
$   1,079   $   815   $   264   $   162,693
$   1,079   $   813   $   266   $   162,427
$   1,079   $   812   $   267   $   162,160
$   1,079   $   811   $   268   $   161,892
$   1,079   $   809   $   270   $   161,622
$   1,079   $   808   $   271   $   161,351
$   1,079   $   807   $   272   $   161,078
$   1,079   $   805   $   274   $   160,805
$   1,079   $   804   $   275   $   160,529
$   1,079   $   803   $   277   $   160,253
$   1,079   $   801   $   278   $   159,975
$   1,079   $   800   $   279   $   159,696
$   1,079   $   798   $   281   $   159,415
$   1,079   $   797   $   282   $   159,133
$   1,079   $   796   $   284   $   158,849
$   1,079   $   794   $   285   $   158,564
$   1,079   $   793   $   286   $   158,278
$   1,079   $   791   $   288   $   157,990
$   1,079   $   790   $   289   $   157,701
$   1,079   $   789   $   291   $   157,410
$   1,079   $   787   $   292   $   157,118
$   1,079   $   786   $   294   $   156,825
$   1,079   $   784   $   295   $   156,530
$   1,079   $   783   $   297   $   156,233
$   1,079   $   781   $   298   $   155,935
$   1,079   $   780   $   300   $   155,635
$   1,079   $   778   $   301   $   155,334
$   1,079   $   777   $   303   $   155,032
$   1,079   $   775   $   304   $   154,728
$   1,079   $   774   $   306   $   154,422
$   1,079   $   772   $   307   $   154,115
$   1,079   $   771   $   309   $   153,807
$   1,079   $   769   $   310   $   153,496
$   1,079   $   767   $   312   $   153,185
$   1,079   $   766   $   313   $   152,871
$   1,079   $   764   $   315   $   152,557
$   1,079   $   763   $   316   $   152,240
$   1,079   $   761   $   318   $   151,922
$   1,079   $   760   $   320   $   151,603
$   1,079   $   758   $   321   $   151,281
$   1,079   $   756   $   323   $   150,959
$   1,079   $   755   $   324   $   150,634
$   1,079   $   753   $   326   $   150,308
$   1,079   $   752   $   328   $   149,981
$   1,079   $   750   $   329   $   149,651
$   1,079   $   748   $   331   $   149,320
$   1,079   $   747   $   333   $   148,988
$   1,079   $   745   $   334   $   148,654
$   1,079   $   743   $   336   $   148,318
$   1,079   $   742   $   338   $   147,980
$   1,079   $   740   $   339   $   147,641
$   1,079   $   738   $   341   $   147,300
$   1,079   $   736   $   343   $   146,957
$   1,079   $   735   $   344   $   146,613
$   1,079   $   733   $   346   $   146,267
$   1,079   $   731   $   348   $   145,919
$   1,079   $   730   $   350   $   145,569
$   1,079   $   728   $   351   $   145,218
$   1,079   $   726   $   353   $   144,865
$   1,079   $   724   $   355   $   144,510
$   1,079   $   723   $   357   $   144,153
$   1,079   $   721   $   358   $   143,795
$   1,079   $   719   $   360   $   143,434
$   1,079   $   717   $   362   $   143,072
$   1,079   $   715   $   364   $   142,709
$   1,079   $   714   $   366   $   142,343
$   1,079   $   712   $   367   $   141,976
$   1,079   $   710   $   369   $   141,606
$   1,079   $   708   $   371   $   141,235
$   1,079   $   706   $   373   $   140,862
$   1,079   $   704   $   375   $   140,487
$   1,079   $   702   $   377   $   140,110
$   1,079   $   701   $   379   $   139,732
$   1,079   $   699   $   381   $   139,351
$   1,079   $   697   $   382   $   138,969
$   1,079   $   695   $   384   $   138,584
$   1,079   $   693   $   386   $   138,198
$   1,079   $   691   $   388   $   137,810
$   1,079   $   689   $   390   $   137,420
$   1,079   $   687   $   392   $   137,028
$   1,079   $   685   $   394   $   136,634
$   1,079   $   683   $   396   $   136,238
$   1,079   $   681   $   398   $   135,840
$   1,079   $   679   $   400   $   135,440
$   1,079   $   677   $   402   $   135,038
$   1,079   $   675   $   404   $   134,634
$   1,079   $   673   $   406   $   134,228
$   1,079   $   671   $   408   $   133,820
$   1,079   $   669   $   410   $   133,410
$   1,079   $   667   $   412   $   132,997
$   1,079   $   665   $   414   $   132,583
$   1,079   $   663   $   416   $   132,167
$   1,079   $   661   $   418   $   131,749
$   1,079   $   659   $   420   $   131,328
$   1,079   $   657   $   423   $   130,906
$   1,079   $   655   $   425   $   130,481
$   1,079   $   652   $   427   $   130,054
$   1,079   $   650   $   429   $   129,625
$   1,079   $   648   $   431   $   129,194
$   1,079   $   646   $   433   $   128,761
$   1,079   $   644   $   435   $   128,325
$   1,079   $   642   $   438   $   127,888
$   1,079   $   639   $   440   $   127,448
$   1,079   $   637   $   442   $   127,006
$   1,079   $   635   $   444   $   126,562
$   1,079   $   633   $   446   $   126,116
$   1,079   $   631   $   449   $   125,667
$   1,079   $   628   $   451   $   125,216
$   1,079   $   626   $   453   $   124,763
$   1,079   $   624   $   455   $   124,308
$   1,079   $   622   $   458   $   123,850
$   1,079   $   619   $   460   $   123,390
$   1,079   $   617   $   462   $   122,928
$   1,079   $   615   $   465   $   122,463
$   1,079   $   612   $   467   $   121,996
$   1,079   $   610   $   469   $   121,527
$   1,079   $   608   $   472   $   121,056
$   1,079   $   605   $   474   $   120,582
$   1,079   $   603   $   476   $   120,106
$   1,079   $   601   $   479   $   119,627
$   1,079   $   598   $   481   $   119,146
$   1,079   $   596   $   483   $   118,662
$   1,079   $   593   $   486   $   118,176
$   1,079   $   591   $   488   $   117,688
$   1,079   $   588   $   491   $   117,197
$   1,079   $   586   $   493   $   116,704
$   1,079   $   584   $   496   $   116,209
$   1,079   $   581   $   498   $   115,710
$   1,079   $   579   $   501   $   115,210
$   1,079   $   576   $   503   $   114,707
$   1,079   $   574   $   506   $   114,201
$   1,079   $   571   $   508   $   113,693
$   1,079   $   568   $   511   $   113,182
$   1,079   $   566   $   513   $   112,669
$   1,079   $   563   $   516   $   112,153
$   1,079   $   561   $   518   $   111,634
$   1,079   $   558   $   521   $   111,113
$   1,079   $   556   $   524   $   110,590
$   1,079   $   553   $   526   $   110,064
$   1,079   $   550   $   529   $   109,535
$   1,079   $   548   $   532   $   109,003
$   1,079   $   545   $   534   $   108,469
$   1,079   $   542   $   537   $   107,932
$   1,079   $   540   $   540   $   107,393
$   1,079   $   537   $   542   $   106,850
$   1,079   $   534   $   545   $   106,305
$   1,079   $   532   $   548   $   105,758
$   1,079   $   529   $   550   $   105,207
$   1,079   $   526   $   553   $   104,654
$   1,079   $   523   $   556   $   104,098
$   1,079   $   520   $   559   $   103,540
$   1,079   $   518   $   561   $   102,978
$   1,079   $   515   $   564   $   102,414
$   1,079   $   512   $   567   $   101,847
$   1,079   $   509   $   570   $   101,277
$   1,079   $   506   $   573   $   100,704
$   1,079   $   504   $   576   $   100,128
$   1,079   $   501   $   579   $    99,550
$   1,079   $   498   $   581   $    98,968
$   1,079   $   495   $   584   $    98,384
$   1,079   $   492   $   587   $    97,797
$   1,079   $   489   $   590   $    97,206
$   1,079   $   486   $   593   $    96,613
$   1,079   $   483   $   596   $    96,017
$   1,079   $   480   $   599   $    95,418
$   1,079   $   477   $   602   $    94,816
$   1,079   $   474   $   605   $    94,211
$   1,079   $   471   $   608   $    93,603
$   1,079   $   468   $   611   $    92,992
$   1,079   $   465   $   614   $    92,377
$   1,079   $   462   $   617   $    91,760
$   1,079   $   459   $   620   $    91,140
$   1,079   $   456   $   623   $    90,516
$   1,079   $   453   $   627   $    89,890
$   1,079   $   449   $   630   $    89,260
$   1,079   $   446   $   633   $    88,627
$   1,079   $   443   $   636   $    87,991
$   1,079   $   440   $   639   $    87,352
$   1,079   $   437   $   642   $    86,709
$   1,079   $   434   $   646   $    86,064
$   1,079   $   430   $   649   $    85,415
$   1,079   $   427   $   652   $    84,763
$   1,079   $   424   $   655   $    84,107
$   1,079   $   421   $   659   $    83,448
$   1,079   $   417   $   662   $    82,787
$   1,079   $   414   $   665   $    82,121
$   1,079   $   411   $   669   $    81,453
$   1,079   $   407   $   672   $   80,781
$   1,079   $   404   $   675   $   80,105
$   1,079   $   401   $   679   $   79,427
$   1,079   $   397   $   682   $   78,745
$   1,079   $   394   $   685   $   78,059
$   1,079   $   390   $   689   $   77,370
$   1,079   $   387   $   692   $   76,678
$   1,079   $   383   $   696   $   75,982
$   1,079   $   380   $   699   $   75,283
$   1,079   $   376   $   703   $   74,580
$   1,079   $   373   $   706   $   73,874
$   1,079   $   369   $   710   $   73,164
$   1,079   $   366   $   713   $   72,451
$   1,079   $   362   $   717   $   71,734
$   1,079   $   359   $   721   $   71,013
$   1,079   $   355   $   724   $   70,289
$   1,079   $   351   $   728   $   69,561
$   1,079   $   348   $   731   $   68,830
$   1,079   $   344   $   735   $   68,095
$   1,079   $   340   $   739   $   67,356
$   1,079   $   337   $   742   $   66,614
$   1,079   $   333   $   746   $   65,868
$   1,079   $   329   $   750   $   65,118
$   1,079   $   326   $   754   $   64,364
$   1,079   $   322   $   757   $   63,607
$   1,079   $   318   $   761   $   62,846
$   1,079   $   314   $   765   $   62,081
$   1,079   $   310   $   769   $   61,312
$   1,079   $   307   $   773   $   60,539
$   1,079   $   303   $   776   $   59,763
$   1,079   $   299   $   780   $   58,982
$   1,079   $   295   $   784   $   58,198
$   1,079   $   291   $   788   $   57,410
$   1,079   $   287   $   792   $   56,618
$   1,079   $   283   $   796   $   55,822
$   1,079   $   279   $   800   $   55,022
$   1,079   $   275   $   804   $   54,218
$   1,079   $   271   $   808   $   53,409
$   1,079   $   267   $   812   $   52,597
$   1,079   $   263   $   816   $   51,781
$   1,079   $   259   $   820   $   50,961
$   1,079   $   255   $   824   $   50,136
$   1,079   $   251   $   829   $   49,308
$   1,079   $   247   $   833   $   48,475
$   1,079   $   242   $   837   $   47,638
$   1,079   $   238   $   841   $   46,797
$   1,079   $   234   $   845   $   45,952
$   1,079   $   230   $   849   $   45,103
$   1,079   $   226   $   854   $   44,249
$   1,079   $   221   $   858   $   43,391
$   1,079   $   217   $   862   $   42,529
$   1,079   $   213   $   867   $   41,662
$   1,079   $   208   $   871   $   40,792
$   1,079   $   204   $   875   $   39,916
$   1,079   $   200   $   880   $   39,037
$   1,079   $   195   $     884   $   38,153
$   1,079   $   191   $     888   $   37,264
$   1,079   $   186   $     893   $   36,371
$   1,079   $   182   $     897   $   35,474
$   1,079   $   177   $     902   $   34,572
$   1,079   $   173   $     906   $   33,666
$   1,079   $   168   $     911   $   32,755
$   1,079   $   164   $     915   $   31,840
$   1,079   $   159   $     920   $   30,920
$   1,079   $   155   $     925   $   29,995
$   1,079   $   150   $     929   $   29,066
$   1,079   $   145   $     934   $   28,132
$   1,079   $   141   $     939   $   27,193
$   1,079   $   136   $     943   $   26,250
$   1,079   $   131   $     948   $   25,302
$   1,079   $   127   $     953   $   24,350
$   1,079   $   122   $     957   $   23,392
$   1,079   $   117   $     962   $   22,430
$   1,079   $   112   $     967   $   21,463
$   1,079   $   107   $     972   $   20,491
$   1,079   $   102   $     977   $   19,514
$   1,079   $    98   $     982   $   18,533
$   1,079   $    93   $     987   $   17,546
$   1,079   $    88   $     991   $   16,555
$   1,079   $    83   $     996   $   15,558
$   1,079   $    78   $   1,001   $   14,557
$   1,079   $    73   $   1,006   $   13,550
$   1,079   $    68   $   1,011   $   12,539
$   1,079   $    63   $   1,016   $   11,523
$   1,079   $    58   $   1,022   $   10,501
$   1,079   $    53   $   1,027   $    9,474
$   1,079   $    47   $   1,032   $    8,442
$   1,079   $    42   $   1,037   $    7,405
$   1,079   $    37   $   1,042   $    6,363
$   1,079   $    32   $   1,047   $    5,316
$   1,079   $    27   $   1,053   $    4,263
$   1,079   $    21   $   1,058   $    3,205
$   1,079   $    16   $   1,063   $    2,142
$   1,079   $    11   $   1,068   $    1,074
$   1,079   $     5   $   1,074   $       (0)
Monthly Int    Years        Months


        0.5%           30            360
    Mortgage      Amortization                       Down Payment        Affordability       Refinance
                                   Loan Optimizer                                                              Overview
    Calculator     Schedule                           Savings Calc        Calculator         Calculator




     Loan Optimizer                                 Purchase Price   $ 200,000               Loan Term (30, 15 yrs, etc.)
                                                    Down Payment     $ 20,000                        Annual Interest Rate
   Display: Monthly Mortgage                          Increment by   $        500                             Increment by



Down Payment      4.75%          5.00%      5.25%         5.50%          5.75%           6.00%        6.25%       6.50%
   $15,000        $965           $993       $1,022        $1,050         $1,080          $1,109      $1,139       $1,169
   $15,500        $962           $990       $1,019        $1,048         $1,077          $1,106      $1,136       $1,166
   $16,000        $960           $988       $1,016        $1,045         $1,074          $1,103      $1,133       $1,163
   $16,500        $957           $985       $1,013        $1,042         $1,071          $1,100      $1,130       $1,160
   $17,000        $955           $982       $1,011        $1,039         $1,068          $1,097      $1,127       $1,157
   $17,500        $952           $980       $1,008        $1,036         $1,065          $1,094      $1,124       $1,154
   $18,000        $949           $977       $1,005        $1,033         $1,062          $1,091      $1,121       $1,150
   $18,500        $947           $974       $1,002        $1,031         $1,059          $1,088      $1,118       $1,147
   $19,000        $944           $972        $999         $1,028         $1,056          $1,085      $1,114       $1,144
   $19,500        $942           $969        $997         $1,025         $1,053          $1,082      $1,111       $1,141
  $20,000         $939           $966        $994         $1,022         $1,050          $1,079      $1,108       $1,138
   $20,500        $936           $964        $991         $1,019         $1,048          $1,076      $1,105       $1,135
   $21,000        $934           $961        $988         $1,016         $1,045          $1,073      $1,102       $1,131
   $21,500        $931           $958        $986         $1,014         $1,042          $1,070      $1,099       $1,128
   $22,000        $929           $956        $983         $1,011         $1,039          $1,067      $1,096       $1,125
   $22,500        $926           $953        $980         $1,008         $1,036          $1,064      $1,093       $1,122
   $23,000        $923           $950        $977         $1,005         $1,033          $1,061      $1,090       $1,119
   $23,500        $921           $947        $975         $1,002         $1,030          $1,058      $1,087       $1,116
   $24,000        $918           $945        $972          $999          $1,027          $1,055      $1,084       $1,112
   $24,500        $915           $942        $969          $996          $1,024          $1,052      $1,081       $1,109
   $25,000        $913           $939        $966          $994          $1,021          $1,049      $1,078       $1,106
   $25,500        $910           $937        $964          $991          $1,018          $1,046      $1,074       $1,103
   $26,000        $908           $934        $961          $988          $1,015          $1,043      $1,071       $1,100
   $26,500        $905           $931        $958          $985          $1,012          $1,040      $1,068       $1,097
     30
  6.00%
  0.25%



6.75%     7.00%    7.25%    7.50%    7.75%
$1,200    $1,231   $1,262   $1,294   $1,325
$1,197    $1,227   $1,259   $1,290   $1,322
$1,193    $1,224   $1,255   $1,287   $1,318
$1,190    $1,221   $1,252   $1,283   $1,315
$1,187    $1,218   $1,248   $1,280   $1,311
$1,184    $1,214   $1,245   $1,276   $1,307
$1,180    $1,211   $1,242   $1,273   $1,304
$1,177    $1,208   $1,238   $1,269   $1,300
$1,174    $1,204   $1,235   $1,266   $1,297
$1,171    $1,201   $1,231   $1,262   $1,293
$1,167    $1,198   $1,228   $1,259   $1,290
$1,164    $1,194   $1,225   $1,255   $1,286
$1,161    $1,191   $1,221   $1,252   $1,282
$1,158    $1,188   $1,218   $1,248   $1,279
$1,155    $1,184   $1,214   $1,245   $1,275
$1,151    $1,181   $1,211   $1,241   $1,272
$1,148    $1,178   $1,207   $1,238   $1,268
$1,145    $1,174   $1,204   $1,234   $1,264
$1,142    $1,171   $1,201   $1,231   $1,261
$1,138    $1,168   $1,197   $1,227   $1,257
$1,135    $1,164   $1,194   $1,224   $1,254
$1,132    $1,161   $1,190   $1,220   $1,250
$1,129    $1,158   $1,187   $1,217   $1,247
$1,125    $1,154   $1,184   $1,213   $1,243
          1
Monthly Mortgage
Total Interest Payment
Total Loan Payment       1
   Mortgage        Amortization                       Down Payment    Affordability         Refinance
                                     Loan Optimizer                                                                 Overview
   Calculator       Schedule                           Savings Calc    Calculator           Calculator




  Down Payment Savings Calculator

     Solve for:
   How much will my savings grow to?                                                      Chart: 2 years
   How much do I need to save each month?
   How long will it take to save enough?                                                               Down Payment Savings Over T
                                                                          $25,000
Savings Assumptions
Down Payment Savings Goal                        $        20,000
                                                                          $20,000
How many months from now?                                     24
Current Savings                                  $        10,000
Monthly Savings Contribution                     $           400          $15,000

Rate of Return (Interest Rate)                             6.00%
Compound Rate of Return                         Monthly                   $10,000



                                                                           $5,000
Results

Required monthly contribution:                        $343                      $0
                                                                                      1    2   3   4    5   6   7   8   9   10
      Overview




                                                                    2
                                                               Solver
                                                                    1
                                                                    2
                                                                    3
Down Payment Savings Over Time




                                                            Chart
                                                            Month
                                                                        1
                                                                        2
                                                                        3
                                                                        4
                                                                        5
         9   10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
                                                                        6
             Month                                                      7
                                                                        8
                                                                        9
                                                                        10
                                                                        11
                                                                        12
                                                                        13
                                                                        14
                                                                        15
                                                                        16
                                                                        17
                                                                        18
                                                                        19
                                                                        20
                                                                        21
                                                                        22
                                                                        23
                                                                        24
                                         12
                               Monthly         # of Comp     Annual        Comp period Monthly
    Answer         Compound Compound           Periods       Contribution Contribution Interest %     Chart     # of years
    20,000.00                             2                24 $    4,800   $      343        0.50%      3               2.00
      343.21         Daily               365                                                         6 months
       20.76        Monthly              12                                                           1 year
                   Quarterly              4                                                          2 years
                    Annually              1                                                          5 years

11271.59776                                                                                          10 years




                  Monthly      Compound
             24        1            1
Monthly Savings
$ 10,393.21
$    10,788
$     11,186
$     11,585
$     11,986
$     12,389
$     12,794
$     13,201
$     13,610
$     14,022
$     14,435
$     14,850
$     15,268
$     15,687
$     16,109
$     16,533
$     16,959
$     17,387
$     17,817
$     18,249
$     18,684
$     19,120
$     19,559
$     20,000
   Mortgage        Amortization                      Down Payment      Affordability   Refinance
                                    Loan Optimizer                                                         Overview
   Calculator       Schedule                          Savings Calc      Calculator     Calculator




      How much house can I afford?

Mortgage Assumptions                                                                                         Monthly Housing Cos
Annual Gross Income                                          $        60,000
Max housing cost ratio allowed                                           28%
Max housing cost & debt ratio allowed                                    36%
Interest Rate:                                                         6.00%                                 $88
                                                                                                    $150
Term of the Loan (30 years, 15 years, etc.)                                30          $78
Down Payment                                                 $        20,000
Real Estate Taxes (annual estimate)                    1.0% $          1,800
Homeowner's Insurance (annual)                         0.6% $          1,050
Maintenance Expense (annual)                                 $         1,000
Monthly debt Expenses
Car Payment                                                  $           300
                                                                                                           Pricipal & Interest Payment
Alimony Paid
                                                                                                           PMI Payment (estimate)
Credit Card payments                                         $             50                              Real Estate Taxes
Other debts (student loans, etc.)                                                                          Homeowner's Insurance
Total Annual Expenses                                        $           350                               Assessments/Maintenance Expe



Results
Monthly Pricipal & Interest Payment                          $         1,001
Monthly PMI Payment (estimate)                               $            78
Taxes + Insurance + Maintenance                              $           321
Total Monthly Housing Payment                                $         1,400
Loan Amount                                                  $       166,910
Purchase Price of Home                                       $       186,910
Overview




  Monthly Housing Cost




  $88      $83



                             $1,001




Pricipal & Interest Payment
PMI Payment (estimate)
Real Estate Taxes
Homeowner's Insurance
Assessments/Maintenance Expense
$              1,079
    $179,996   $75.00   Pricipal & Interest Payment       $ 1,001
    $167,487   $69.79   PMI Payment (estimate)            $    78
    $168,356   $70.15   Real Estate Taxes                 $   150
    $188,296   $78.46   Homeowner's Insurance             $    88
                        Assessments/Maintenance Expense   $    83
   Mortgage         Amortization                    Down Payment    Affordability        Refinance
                                   Loan Optimizer
   Calculator        Schedule                        Savings Calc    Calculator          Calculator




                Refinancing Calculator
                                                                                                        Refinancing Savings & Cos
Mortgage Assumptions
Old (your current) Interest Rate                         6.00%
Original Loan Amount                           $      180,000
Original Loan Term (in years)                               30
Months Left to Pay on Original Loan                         25
New Interest Rate                                        5.50%
New Loan Amount                                $      165,000
New Loan Term (in years)                                    25

Refinancing Cost
Application Fee                                $           500
                                                                                    $0         $5,000
Appraisal Fee                                  $           900
Attorney's Fees (lenders & lenders):           $         1,500
Credit Check                                   $           100
Documentation Preparation                      $           750                 Results
Inspections                                    $         1,500
Other                                          $         1,000                Years until Refinancing Costs are Recouped
Title Search & Insurance                       $           600                Savings (Life of Loan)
Total Refinancing Cost                         $         6,850                Monthly Mortgage Reduction
   Refinance
                     Overview




                 Refinancing Savings & Cost

                                                    Mortgage
                                                    Savings,
                                                    $19,784



                   Refinancing
                   Cost, $6,850



                                  Total (Net)
                                   Savings,
                                   $12,934


        $5,000        $10,000     $15,000       $20,000        $25,000




s until Refinancing Costs are Recouped                     8.7 yrs
ngs (Life of Loan)                                        $12,934
 hly Mortgage Reduction                                     $66
              Chart
Total (Net) Savings $12,934
               $
Refinancing Cost      6,850
Mortgage Savings $19,784

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:0
posted:5/18/2012
language:
pages:39
fanzhongqing fanzhongqing http://
About