# Car Loan Payment Calculator - Excel by BeunaventuraLongjas

VIEWS: 468 PAGES: 6

• pg 1
```									                                                                              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