Docstoc

Braden Mortgage Loan Payment Calculator with Amortization Schedule

Document Sample
Braden Mortgage Loan Payment Calculator with Amortization Schedule Powered By Docstoc
					               Loan Payment Calculator
Date                 10-Oct-2007 Rate                      5.75%      Year
Item                       Home Years                          18        1
Price                $265,000.00 Monthly Payment        $1,748.80        2
Down Payment          $30,000.00 Total Interest       $142,740.46        3
Loan Amount          $235,000.00 Total Cost           $407,740.46        4

                Interest Rate Schedule                                  5
         Rate   Monthly Payment      Total Interest      Total Cost     6
                       $1,748.80      $142,740.46     $407,740.46       7
        4.50%           1,589.36       108,302.37       373,302.37      8
        4.75%           1,620.58       115,044.51       380,044.51      9
        5.00%           1,652.13       121,859.98       386,859.98     10
        5.25%           1,684.02       128,748.21       393,748.21     11
        5.50%           1,716.24       135,708.58       400,708.58     12
        5.75%           1,748.80       142,740.46       407,740.46     13
        6.00%           1,781.68       149,843.19       414,843.19     14
        6.25%           1,814.89       157,016.11       422,016.11     15
        6.50%           1,848.42       164,258.51       429,258.51     16
        6.75%           1,882.27       171,569.68       436,569.68     17
        7.00%           1,916.43       178,948.90       443,948.90     18
        7.25%           1,950.90       186,395.42       451,395.42
        7.50%           1,985.69       193,908.46       458,908.46
        7.75%           2,020.77       201,487.26       466,487.26
    Amortization Schedule
   Beginnng        Ending      Paid On        Interest
    Balance       Balance     Principal           Paid
$235,000.00   227326.7922    $7,673.21    13312.37332
227326.7922   219200.5594    $8,126.23    12859.34842
219200.5594   210594.5553    $8,606.00    12379.57701
210594.5553   201480.4541    $9,114.10    11871.47998

201480.4541   191828.2579    $9,652.20    11333.38499
191828.2579   181606.1977   $10,222.06    10763.52095
181606.1977   170780.6288   $10,825.57    10160.01224
170780.6288   159315.9201   $11,464.71     9520.87248
159315.9201    147174.337   $12,141.58    8843.998013
 147174.337   134315.9168   $12,858.42    8127.160993
134315.9168   120698.3377   $13,617.58    7368.002036
120698.3377    106276.779   $14,421.56    6564.022462
 106276.779   91003.77392   $15,273.01     5712.57607
91003.77392   74829.05319   $16,174.72    4810.860427
74829.05319   57699.37968   $17,129.67    3855.907644
57699.37968   39558.37313   $18,141.01    2844.574609
39558.37313   20346.32462   $19,212.05    1773.532644
20346.32462             0   $20,346.32    639.2565408

				
DOCUMENT INFO