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.


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...
You are buying a new car. You can choose any car you want, Determine what your...
You are buying a new car. You can choose any car you want, Determine what your monthly car payments will be. *Do not forget to include tax and interest rate* include maker, model, and year of car. include sticker price, APR, and tax rate. Show all the work for determing cost. include thorough explanation for how monthly payments were determined. Compare at least two different plans such as one with down payment versus one without.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT