Docstoc

Auto_Loan_Calculation_Analysis

Document Sample
Auto_Loan_Calculation_Analysis Powered By Docstoc
					            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

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