Question

In: Finance

   You are buying a car for $30,000 and have three options—all of which will take...

   You are buying a car for $30,000 and have three options—all of which will take 60 months to pay. The first option gives a $3000 discount on the car, but charges 5.9% financing. The second option pays for the car at the full price, but charges 1.9% financing. The third option is also discounted $3000 but at 5.5% financing and has a $5000 balloon payment. Which option will cost the least amount of money?

Solutions

Expert Solution

Option 1
Vehicle Price $30,000
Discount $3,000
Loan to be taken $27,000
Interest 5.90%
Interest per month 0.4917%
EMI for 60 Months: (27000*0.004917*(1.004917)^60)/((1.004917)^60-1)
$520.730
Toatl cost $520.73 *60
$31,243.80
Option 2
Vehicle Price $30,000
Discount $0
Loan to be taken $30,000
Interest 1.90%
EMI for 60 Months: $524.52
Toatl cost $524.52 *60
$31,471.20
Option 3
Vehicle Price $30,000
Discount $3,000
Ballon Payment $5,000
Loan to be taken $27,000
Interest 5.50%
EMI for 60 Months: $443.14
Ballon Payment $5,000
Toatl cost of EMI $443.14 *60
$26,588.40
Add:Ballon payment $5,000
$31,588.40

Option 1 is less cost of $ 31243.

EMI table for Option3

Month Balance Principal Interest Payment
1 $   27,000.00 $     319.39 $ 123.75 $     443.14
2 $   26,680.61 $     320.86 $ 122.29 $     443.14
3 $   26,359.75 $     322.33 $ 120.82 $     443.14
4 $   26,037.42 $     323.80 $ 119.34 $     443.14
5 $   25,713.62 $     325.29 $ 117.85 $     443.14
6 $   25,388.33 $     326.78 $ 116.36 $     443.14
7 $   25,061.55 $     328.28 $ 114.87 $     443.14
8 $   24,733.28 $     329.78 $ 113.36 $     443.14
9 $   24,403.50 $     331.29 $ 111.85 $     443.14
10 $   24,072.20 $     332.81 $ 110.33 $     443.14
11 $   23,739.39 $     334.34 $ 108.81 $     443.14
12 $   23,405.05 $     335.87 $ 107.27 $     443.14
13 $   23,069.19 $     337.41 $ 105.73 $     443.14
14 $   22,731.78 $     338.95 $ 104.19 $     443.14
15 $   22,392.82 $     340.51 $ 102.63 $     443.14
16 $   22,052.31 $     342.07 $ 101.07 $     443.14
17 $   21,710.24 $     343.64 $     99.51 $     443.14
18 $   21,366.61 $     345.21 $     97.93 $     443.14
19 $   21,021.40 $     346.79 $     96.35 $     443.14
20 $   20,674.60 $     348.38 $     94.76 $     443.14
21 $   20,326.22 $     349.98 $     93.16 $     443.14
22 $   19,976.24 $     351.58 $     91.56 $     443.14
23 $   19,624.65 $     353.20 $     89.95 $     443.14
24 $   19,271.46 $     354.81 $     88.33 $     443.14
25 $   18,916.64 $     356.44 $     86.70 $     443.14
26 $   18,560.20 $     358.07 $     85.07 $     443.14
27 $   18,202.13 $     359.72 $     83.43 $     443.14
28 $   17,842.41 $     361.36 $     81.78 $     443.14
29 $   17,481.05 $     363.02 $     80.12 $     443.14
30 $   17,118.03 $     364.68 $     78.46 $     443.14
31 $   16,753.34 $     366.36 $     76.79 $     443.14
32 $   16,386.98 $     368.04 $     75.11 $     443.14
33 $   16,018.95 $     369.72 $     73.42 $     443.14
34 $   15,649.23 $     371.42 $     71.73 $     443.14
35 $   15,277.81 $     373.12 $     70.02 $     443.14
36 $   14,904.69 $     374.83 $     68.31 $     443.14
37 $   14,529.86 $     376.55 $     66.60 $     443.14
38 $   14,153.32 $     378.27 $     64.87 $     443.14
39 $   13,775.04 $     380.01 $     63.14 $     443.14
40 $   13,395.04 $     381.75 $     61.39 $     443.14
41 $   13,013.29 $     383.50 $     59.64 $     443.14
42 $   12,629.79 $     385.26 $     57.89 $     443.14
43 $   12,244.53 $     387.02 $     56.12 $     443.14
44 $   11,857.51 $     388.80 $     54.35 $     443.14
45 $   11,468.72 $     390.58 $     52.56 $     443.14
46 $   11,078.14 $     392.37 $     50.77 $     443.14
47 $   10,685.77 $     394.17 $     48.98 $     443.14
48 $   10,291.61 $     395.97 $     47.17 $     443.14
49 $     9,895.64 $     397.79 $     45.35 $     443.14
50 $     9,497.85 $     399.61 $     43.53 $     443.14
51 $     9,098.24 $     401.44 $     41.70 $     443.14
52 $     8,696.80 $     403.28 $     39.86 $     443.14
53 $     8,293.51 $     405.13 $     38.01 $     443.14
54 $     7,888.38 $     406.99 $     36.16 $     443.14
55 $     7,481.40 $     408.85 $     34.29 $     443.14
56 $     7,072.54 $     410.73 $     32.42 $     443.14
57 $     6,661.82 $     412.61 $     30.53 $     443.14
58 $     6,249.21 $     414.50 $     28.64 $     443.14
59 $     5,834.71 $     416.40 $     26.74 $     443.14
60 $     5,418.31 $     418.31 $     24.83 $     443.14
balloon $     5,000.00 $ 5,000.00 ---------- $ 5,000.00

Related Solutions

1a. If you take out a car loan for $30,000 for 6 years at 4.5% Simple...
1a. If you take out a car loan for $30,000 for 6 years at 4.5% Simple interest what is the monthly payment? and How much will you pay in total for interest at the end of the 6 years? 1b. If you take out a car loan for $30,000 for 6 years at 4.5% Compound Interest what is the monthly payment? and How much will you pay in total for interest at the end of the 6 years?
You are looking at buying a house with a $180,000 loan amount. You have 2 options...
You are looking at buying a house with a $180,000 loan amount. You have 2 options for this loan: 1) 15 Year Loan, you can get a monthly interest rate of 0.3% monthly. A) What is your monthly payment? B) What is the total amount you would pay out of pocket over the life of the loan? C) How much interest have you paid? 2) 30 year Loan, you can get a monthly interest rate of 0.3125% monthly. A) What...
You are considering buying a new car. The sticker price is $85,000 and you have $25,000...
You are considering buying a new car. The sticker price is $85,000 and you have $25,000 to put toward a down payment. If you can negotiate a nominal annual interest rate of 6.5 percent and you wish to pay for the car over a 5 year period, what are your monthly car payments? DO NOT USE EXCEL
You are considering buying a new car for $37,000. If you purchase the car you will...
You are considering buying a new car for $37,000. If you purchase the car you will pay $7,000 of the purchase price as a down payment. Below are two options to choose from. Option 1: Pay off the amount borrowed to purchase the car with a 5 year loan, and the annual percentage rate (APR) will be 0%. Option 2: Receive a $2,000 instant rebate. This will lower your loan amount. Pay off the amount borrowed to purchase the car...
You are considering buying a new car for $37,000. If you purchase the car you will...
You are considering buying a new car for $37,000. If you purchase the car you will pay $7,000 of the purchase price as a down payment. Below are two options to choose from. Option 1: Pay off the amount borrowed to purchase the car with a 5 year loan, and the annual percentage rate (APR) will be 0%. Option 2: Receive a $2,000 instant rebate. This will lower your loan amount. Pay off the amount borrowed to purchase the car...
Consumer Buying Behavior - You are the manager for a car dealership which sells and services...
Consumer Buying Behavior - You are the manager for a car dealership which sells and services luxury automobiles. You are interested in understanding more about the consumer buying behavior for your customer base in order to effectively meet customer needs. Currently, your advertising is limited and while you have a service department, many customers go elsewhere to have their car serviced. Create a 300–400-word response on the consumer buying decision process and submit to this Discussion Area. Be sure to...
u are looking for a car and have narrowed it down to two options. You can...
u are looking for a car and have narrowed it down to two options. You can buy a new car at a cost of $23,995, which has estimated life of 12 years and annual maintenance costs of $750 per year. Your second option is a used car at a cost of $14,225, with an estimated remaining life of 7 years and annual maintenance costs of $1800 per year. Which is the cheaper option, given your borrowing cost of 7%?
Anna decides to take out a four-year loan for $30,000 to purchase a new car. Her...
Anna decides to take out a four-year loan for $30,000 to purchase a new car. Her loan officer tells her that she will make equal, monthly payments for the loan at an interest rate of 8 percent per year. How much, in total, did Anna pay in interest over the course of the loan?
Anna decides to take out a four-year loan for $30,000 to purchase a new car. Her...
Anna decides to take out a four-year loan for $30,000 to purchase a new car. Her loan officer tells her that she will make equal, monthly payments for the loan at an interest rate of 8 percent per year. What will the balance of the loan be after 2 years of making payments?
Suppose that you are thinking about buying a car and have narrowed down your choices to...
Suppose that you are thinking about buying a car and have narrowed down your choices to two options. The new car option: the new car costs $26,000 and can be financed with a four-year loan at 7.54%. The used car option: a three-year old model of the same car costs $14,000 and can be financed with a three-year loan at 7.07%. What is the difference in monthly payments between financing the new car and financing the used car? Use PMT...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT