Question

In: Finance

Extra Credit Activity #1 You are considering buying a new car worth $15,000. You can finance...

Extra Credit Activity #1

You are considering buying a new car worth $15,000. You can finance the car either by withdrawing cash from your savings account (option 1), which earns 8% interest compounded monthly or by borrowing $15,000 from your dealer for five years at 11% interest compounded monthly and quarterly payments (option 2).

  1. Show the loan amortization schedule for option 2 (50 points)
  2. How much interest will you pay over the lifetime of the loan? (15 points)
  3. How much interest will you earn from your savings account in five years? (15 points)
  4. Which is the best option to buy your new car? Hint: Use future value to compare them. (20 points)

Submit an excel file with your answers. Mac users need to save the spreadsheet as xls or xlsx.

Solutions

Expert Solution

We cannot provide excel sheet, please make a query on Chgg Helpline.

jeff jeffy answered 1 year ago
Next > < Previous

Related Solutions

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...
1. You are considering buying a new car. Price is $23,000 and you will pay down...
1. You are considering buying a new car. Price is $23,000 and you will pay down payment of $3000. If you plan to incase the car over a 50 month period at a nominal interest of 12% what would be you monthly payment? A. $ 613.25 B. $ 510.25 C. $ 480. 65 D. $ 620.50 2. The conflict of interest exists between stockholders and creditors in a corporation because stockholders may A. Increase the firms investment risk level B....
An individual owns a car that is worth $20,000, and is considering buying insurance. However, the...
An individual owns a car that is worth $20,000, and is considering buying insurance. However, the only insurance which is available has a maximum coverage of $15,000, i.e. the policy will pay only $15,000 if the car suffers a total loss in an accident. The price of the policy is $1,800. There is a 10% chance of having an accident in which the car is a total loss. The focus here is to calculate the expected values with and without...
Suppose you are thinking of buying a new car. One of the choices you are considering...
Suppose you are thinking of buying a new car. One of the choices you are considering is a hybrid car. This hybrid model car is $9,000 more expensive than a traditional model; however, the hybrid model will get 40 miles per gallon of gas as compared to 30 miles per gallon for the traditional model. You expect the cost of gas to hover around $3.60 in the foreseeable future. Given the information above and your knowledge of CVP, answer the...
Suppose you are thinking of buying a new car. One of the choices you are considering...
Suppose you are thinking of buying a new car. One of the choices you are considering is a hybrid car. This hybrid model car is $9,000 more expensive than a traditional model; however, the hybrid model will get 40 miles per gallon of gas as compared to 30 miles per gallon for the traditional model. You expect the cost of gas to hover around $3.60 in the foreseeable future. Given the information above and your knowledge of CVP, answer the...
You are buying a car and need to borrow $15,000. You agreed to pay off the...
You are buying a car and need to borrow $15,000. You agreed to pay off the loan in 5 years by making monthly payments. The interest rate is 8%. Determine the monthly payment amount.  
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, because you think it will save you money. Your...
You are considering buying a new​ car, because you think it will save you money. Your think your old car will cost​ $2,200 in gas and maintenance next year​ (Year 1), and you expect that to increase by​ 6% every year until the end of Year 10. A new car will cost you​ $16,500 now​ (Year 0). You think it will cost​ $500 in gas and maintenance next year​ (Year 1), and you expect that to increase by​ 4% every...
Suppose you can buy a new car for $15,000 and sell it for $6,000 after six...
Suppose you can buy a new car for $15,000 and sell it for $6,000 after six years. Or, you can lease the car to $300 per month for three years and return it at the end of the three years. Assume that lease payments are made yearly instead of monthly (i.e., are $3,600 per year for each of the three years). a.) If the interest rate, r, is 4 percent, should you lease or buy? b.) What if the interest...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT