# Auto_Loan_Calculation_Analysis by fanzhongqing

VIEWS: 0 PAGES: 5

• pg 1
```									            Criteria of            Lease Option      Purchase Option
Consideratin               Amount              Amount
Cost of Car at date of Purchase     \$   41,000.00     \$      41,000.00
Down Payment                        \$    1,000.00     \$      14,000.00
Loan Amount                              n/a          \$      27,000.00
Interest Rate on Loan                    n/a                     6.19%
Monthly Payment                     \$      500.00     \$         524.37
Number of Months                                36                   60
Total Monthly Payments              \$   18,000.00     \$      31,462.46
Total Paid of Car                   \$   19,000.00     \$      45,462.46

Difference between leasing and buying over the course of the lease
\$                        (877.48)
Cost of Car            41,000
Down Pmt.              14,000
Loan Amt.              27,000
Interest Rate            6.2%
Loan Amount            27,000
# of Periods                60
Monthly Pmts          \$524.37

# of Months     Pmt Amt            Principal       Interest            Principal Remaining    Pmt Amt       Interest
27,000.00          600.00
1                   524.37          385.10              139.28              26,614.90          600.00        139.28
2                   524.37          387.09              137.29              26,227.81        1,000.00        134.95
3                   524.37          389.08              135.29              25,838.73          600.00        128.65
4                   524.37          391.09              133.28              25,447.64          600.00        124.41
5                   524.37          393.11              131.27              25,054.54          600.00        120.22
6                   524.37          395.13              129.24              24,659.40          600.00        116.06
7                   524.37          397.17              127.20              24,262.23          600.00        111.95
8                   524.37          399.22              125.15              23,863.01          600.00        107.89
9                   524.37          401.28              123.09              23,461.73          600.00        103.87
10                  524.37          403.35              121.02              23,058.37          600.00          99.90
11                  524.37          405.43              118.94              22,652.94          600.00          95.98
12                  524.37          407.52              116.85              22,245.42          600.00          92.11
13                  524.37          409.63              114.75              21,835.79          600.00          88.29
14                  524.37          411.74              112.64              21,424.06          600.00          84.53
15                  524.37          413.86              110.51              21,010.19          600.00          80.83
16                  524.37          416.00              108.38              20,594.20          600.00          77.18
17                  524.37          418.14              106.23              20,176.06          600.00          73.60
18                  524.37          420.30              104.07              19,755.76          600.00          70.08
19                  524.37          422.47              101.91              19,333.29          600.00          66.62
20                  524.37          424.65               99.73              18,908.64          600.00          63.22
21                  524.37          426.84               97.54              18,481.80          600.00          59.89
22                  524.37          429.04               95.34              18,052.77          600.00          56.63
23                  524.37          431.25               93.12              17,621.51          600.00          53.45
24                  524.37          433.48               90.90              17,188.04          600.00          50.33
25                  524.37          435.71               88.66              16,752.32          600.00          47.29
26                  524.37          437.96               86.41              16,314.36          600.00          44.32
27                  524.37          440.22               84.15              15,874.14          600.00          41.43
28                  524.37          442.49               81.88              15,431.65          600.00          38.62
29                  524.37          444.77               79.60              14,986.88          600.00          35.88
30                  524.37          447.07               77.31              14,539.81          600.00          33.23
31                  524.37          449.37               75.00              14,090.44          600.00          30.67
32                  524.37          451.69               72.68              13,638.75          600.00          28.19
33                  524.37          454.02               70.35              13,184.73          600.00          25.80
34                  524.37          456.36               68.01              12,728.37          600.00          23.49
35                  524.37          458.72               65.66              12,269.65          600.00          21.27
36                  524.37          461.08               63.29              11,808.56          600.00          19.15
37                  524.37          463.46               60.91              11,345.10          600.00          17.12
38                  524.37          465.85               58.52              10,879.25          600.00          15.19
39                  524.37          468.26               56.12              10,410.99          600.00          20.27
40                  524.37          470.67               53.70               9,940.32          600.00          18.24
41                  524.37          473.10               51.28               9,467.23          600.00          16.31
42      524.37      475.54      48.84   8,991.69           600.00        14.48
43      524.37      477.99      46.38   8,513.69           600.00        12.75
44      524.37      480.46      43.92   8,033.24           600.00        11.11
45      524.37      482.94      41.44   7,550.30           600.00         9.58
46      524.37      485.43      38.95   7,064.87           600.00         8.16
47      524.37      487.93      36.44   6,576.94           600.00         6.83
48      524.37      490.45      33.93   6,086.49           600.00         5.62
49      524.37      492.98      31.40   5,593.51           600.00         4.51
50      524.37      495.52      28.85   5,097.99           600.00         3.50
51      524.37      498.08      26.30   4,599.92           600.00         2.61
52      524.37      500.65      23.73   4,099.27           600.00         1.83
53      524.37      503.23      21.15   3,596.04           600.00         1.16
54      524.37      505.82      18.55   3,090.22           600.00         0.61
55      524.37      508.43      15.94   2,581.78           288.58         0.17
56      524.37      511.06      13.32   2,070.72             0.17         0.00
57      524.37      513.69      10.68   1,557.03             0.00         0.00
58      524.37      516.34       8.03   1,040.69             0.00         0.00
59      524.37      519.01       5.37     521.68             0.00         0.00
60      524.37      521.68       2.69       0.00                -         0.00
Total        31,462.46   27,000.00   4,462.46                   33,088.75     2,759.32

Total Savings on Interest   1,703.15
Principal       Principal Remaining
27,000.00
460.73              26,539.28
865.05              25,674.22
471.35              25,202.87
475.59              24,727.28
479.78              24,247.50
483.94              23,763.57
488.05              23,275.52
492.11              22,783.41
496.13              22,287.28
500.10              21,787.18
504.02              21,283.16
507.89              20,775.27
511.71              20,263.56
515.47              19,748.09
519.17              19,228.92
522.82              18,706.11
526.40              18,179.71
529.92              17,649.78
533.38              17,116.40
536.78              16,579.62
540.11              16,039.51
543.37              15,496.15
546.55              14,949.59
549.67              14,399.92
552.71              13,847.21
555.68              13,291.53
558.57              12,732.96
561.38              12,171.57
564.12              11,607.46
566.77              11,040.69
569.33              10,471.36
571.81               9,899.55
574.20               9,325.34
576.51               8,748.83
578.73               8,170.11
580.85               7,589.26
582.88               7,006.38
584.81               9,751.00
579.73               9,171.27
581.76               8,589.51
583.69               8,005.82
585.52    7,420.30
587.25    6,833.05
588.89    6,244.16
590.42    5,653.75
591.84    5,061.90
593.17    4,468.73
594.38    3,874.35
595.49    3,278.85
596.50    2,682.36
597.39    2,084.97
598.17    1,486.80
598.84      887.97
599.39      288.58
288.41        0.17
0.17        0.00
0.00        0.00
0.00        0.00
0.00        0.00
(0.00)       0.00
30,329.43

```
To top