1a) You would like to purchase a car that costs$34,000. You have decided to finance the...

1a) You would like to purchase a car that costs $34,000. You have decided to finance the car with a six-year car loan. If the APR (annual percentage rate) is 4.25 percent, compute your monthly payment.

1b) Construct a loan amortization table in Excel for the car loan in Problem 1a. You should do the problem in Excel using monthly payments and should submit the spreadsheet.

Expert Solution

jeff jeffy answered 2 years ago

You would like to purchase a car that costs $32,000. You have decided to finance the...

You would like to purchase a car that costs $32,000. You have decided to finance the car with a four-year car loan. If the APR (annual percentage rate) is 5 percent, compute your monthly payment. Construct a loan amortization table in Excel for the car loan. You should do the problem in Excel using monthly payments and should submit the spreadsheet.

Alex would like to purchase a car if the car is 22000 +HST(13%) and Alex finance:...

Alex would like to purchase a car if the car is 22000 +HST(13%) and Alex finance: the car over 48 months with an APR of 6% what is the monthly payment?

You have decided to buy a car that costs $23,000. Since you do not have a...

You have decided to buy a car that costs $23,000. Since you do not have a big down payment, the lender offers you a loan with an APR of 5.87 percent compounded monthly for 5 years with the first monthly payment due today. What is the amount of your loan payment?

You have decided to buy a car that costs 27400. Since you do not have a...

You have decided to buy a car that costs 27400. Since you do not have a big down payment, the lender offers you a loan with an APR of 6.09 percent compounded monthly for 7 years with the first monthly payment due today. What is the amount of your loan payment

You have decided to buy a car that costs $24,600. Since you do not have a...

You have decided to buy a car that costs $24,600. Since you do not have a big down payment, the lender offers you a loan with an APR of 5.95 percent compounded monthly for 6 years with the first monthly payment due today. What is the amount of your loan payment?

You would like to buy a new car that costs $25,000. The dealer offers you a...

You would like to buy a new car that costs $25,000. The dealer offers you a 3-year loan at an 8% interest rate, and because that rate is higher than market rates they offer to lower the price by $2,000. Assuming you make the required payment, should you accept his offer or seek alternative financing at the 3% rate?

You would like to buy yourself a fabulous new car. You have $50,000 but the car...

You would like to buy yourself a fabulous new car. You have $50,000 but the car costs $68,500. If you can earn 9% interest on a two year investment, how much would you have to invest today to buy the car in two year? Do you have enough? Assume the price of the car will remain the same. N = I = PV = PMT = FV = P/Y =

You would like to purchase a new car in 4 years after you graduate college. The...

You would like to purchase a new car in 4 years after you graduate college. The car you want to buy currently costs $35,000, but you expect the price of this model of car to increase by 5% per year for the next 4 years. How much do you have to invest today if you savings account earns 3% APR (nominal) to exactly pay for your new car? $421,657 $38,122 $42,543 $37,799 please work out and show how nominal rate...

You have decided to buy a car, the price of the car is $18,000. The car...

You have decided to buy a car, the price of the car is $18,000. The car dealer presents you with two choices: (A) Purchase the car for cash and receive $2000 instant cash rebate – your out of pocket expense is $16,000 today. (B) Purchase the car for $18,000 with zero percent interest 36-month loan with monthly payments. Market interest rate is 4%. Which option above is cheaper? How much do you save?

If you wanted to finance a new car, would you apply to a finance company or...

If you wanted to finance a new car, would you apply to a finance company or a commercial bank? What are the advantages and disadvantages of either choice?

Question