Car Loan Payment Calculator - Excel by BeunaventuraLongjas

VIEWS: 468 PAGES: 6

More Info
									                                                                              Dream Car
Loan Payment Calculator
Item                    Mustang           Rate                                              4%
Price                   $       50,000.00 Years                                               6
Down Payment (10%)      $        5,000.00 Monthly Payment                              $704.03
Loan Amount             $       45,000.00 Total Cost                                $55,690.39
                                          Total Interest                             $5,690.39


Interest Rate Schedule 6 year loan
Rate                    Monthly Payment Total Cost                            Total Interest
                1.00%            $644.20                       $51,382.24             $1,382.24
                1.50%            $653.94                       $52,083.47             $2,083.47
                2.00%            $663.77                       $52,791.43             $2,791.43
                2.50%            $673.70                       $53,506.11             $3,506.11
                3.00%            $683.72                       $54,227.51             $4,227.51
                3.50%            $693.83                       $54,955.61             $4,955.61
                4.00%            $704.03                       $55,690.39             $5,690.39
                4.50%            $714.33                       $56,431.86             $6,431.86
                5.00%            $724.72                       $57,179.98             $7,179.98
                5.50%            $735.20                       $57,934.75             $7,934.75
                6.00%            $745.78                       $58,696.16             $8,696.16
                6.50%            $756.45                       $59,464.17             $9,464.17
                7.00%            $767.21                       $60,238.78            $10,238.78
                7.50%            $778.06                       $61,019.96            $11,019.96
                8.00%            $789.00                       $61,807.70            $11,807.70
                8.50%            $800.03                       $62,601.97            $12,601.97
                9.00%            $811.15                       $63,402.74            $13,402.74
                9.50%            $822.36                       $64,210.00            $14,210.00
               10.00%            $833.66                       $65,023.71            $15,023.71


Loan Amortization Table
             Payment            Principal                   Pay to Interest    Pay to Principal
                   1    $      45,000.00                               150            $554.03
                   2    $      44,445.97                      148.1532225             $555.88
                   3    $      43,890.09                      146.3002892             $557.73
                   4    $      43,332.35                      144.4411793             $559.59
                   5    $      42,772.76                      142.5758725             $561.46
                   6    $      42,211.30                      140.7043479             $563.33
                   7    $      41,647.98                      138.8265849             $565.21
                   8    $      41,082.77                      136.9425628             $567.09
                   9    $      40,515.68                      135.0522605             $568.98
                  10    $      39,946.70                      133.1556573             $570.88
                  11    $      39,375.82                       131.252732             $572.78
                  12    $      38,803.04                      129.3434636             $574.69
                  13    $      38,228.35                       127.427831             $576.61
                  14    $      37,651.74                       125.505813             $578.53
15   $   37,073.22   123.5773883   $580.46
16   $   36,492.76   121.6425354   $582.39
17   $   35,910.37   119.7012331   $584.33
18   $   35,326.04   117.7534597   $586.28
19   $   34,739.76   115.7991938   $588.23
20   $   34,151.52   113.8384137   $590.19
21   $   33,561.33   111.8710976   $592.16
22   $   32,969.17   109.8972238   $594.14
23   $   32,375.03   107.9167704   $596.12
24   $   31,778.91   105.9297155   $598.10
25   $   31,180.81   103.9360371   $600.10
26   $   30,580.71   101.9357131   $602.10
27   $   29,978.62   99.92872134   $604.10
28   $   29,374.51   97.91503962   $606.12
29   $   28,768.39   95.89464563   $608.14
30   $   28,160.26   93.86751698   $610.17
31   $   27,550.09   91.83363125   $612.20
32   $   26,937.89   89.79296589   $614.24
33   $   26,323.65   87.74549831   $616.29
34   $   25,707.36   85.69120585   $618.34
35   $   25,089.02   83.63006574   $620.40
36   $   24,468.62   81.56205516   $622.47
37   $   23,846.15   79.48715122   $624.55
38   $   23,221.60   77.40533093   $626.63
39   $   22,594.97   75.31657124   $628.72
40   $   21,966.25   73.22084902   $630.81
41   $   21,335.44   71.11814105   $632.92
42   $   20,702.53   69.00842406   $635.02
43   $   20,067.50   66.89167468   $637.14
44   $   19,430.36   64.76786947   $639.27
45   $   18,791.10   62.63698491   $641.40
46   $   18,149.70   60.49899739   $643.53
47   $   17,506.16   58.35388326   $645.68
48   $   16,860.49   56.20161874   $647.83
49   $   16,212.65   54.04218001   $649.99
50   $   15,562.66   51.87554315   $652.16
51   $   14,910.51   49.70168417   $654.33
52   $   14,256.17   47.52057899   $656.51
53   $   13,599.66   45.33220345   $658.70
54   $   12,940.96   43.13653334   $660.90
55   $   12,280.06   40.93354432   $663.10
56   $   11,616.96   38.72321201   $665.31
57   $   10,951.65   36.50551192   $667.53
58   $   10,284.13    34.2804195   $669.75
59   $    9,614.37    32.0479101   $671.99
60   $    8,942.39   29.80795901   $674.23
61   $    8,268.16   27.56054141   $676.47
62   $    7,591.69   25.30563242   $678.73
63   $    6,912.96   23.04320707   $680.99
64   $    6,231.97    20.7732403   $683.26
65   $    5,548.71   18.49570697   $685.54
66   $    4,863.17   16.21058187   $687.82
67   $   4,175.35   13.91783968   $690.12
68   $   3,485.24   11.61745502   $692.42
69   $   2,792.82   9.309402408   $694.72
70   $   2,098.10   6.993656289   $697.04
71   $   1,401.06   4.670191016   $699.36
72   $     701.69   2.338980858   $701.69
ream Car
                     Picture of car here




                     Link to where you found the car here




    Principal Owed
   $     44,445.97
   $     43,890.09
   $     43,332.35
   $     42,772.76
   $     42,211.30
   $     41,647.98
   $     41,082.77
   $     40,515.68
   $     39,946.70
   $     39,375.82
   $     38,803.04
   $     38,228.35
   $     37,651.74
   $     37,073.22
$   36,492.76
$   35,910.37
$   35,326.04
$   34,739.76
$   34,151.52
$   33,561.33
$   32,969.17
$   32,375.03
$   31,778.91
$   31,180.81
$   30,580.71
$   29,978.62
$   29,374.51
$   28,768.39
$   28,160.26
$   27,550.09
$   26,937.89
$   26,323.65
$   25,707.36
$   25,089.02
$   24,468.62
$   23,846.15
$   23,221.60
$   22,594.97
$   21,966.25
$   21,335.44
$   20,702.53
$   20,067.50
$   19,430.36
$   18,791.10
$   18,149.70
$   17,506.16
$   16,860.49
$   16,212.65
$   15,562.66
$   14,910.51
$   14,256.17
$   13,599.66
$   12,940.96
$   12,280.06
$   11,616.96
$   10,951.65
$   10,284.13
$    9,614.37
$    8,942.39
$    8,268.16
$    7,591.69
$    6,912.96
$    6,231.97
$    5,548.71
$    4,863.17
$    4,175.35
$   3,485.24
$   2,792.82
$   2,098.10
$   1,401.06
$     701.69
$       0.00

								
To top