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.

Solutions

Expert Solution

jeff jeffy answered 2 years ago

Next > < Previous

Related Solutions

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 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 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 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?

1a. On January 1, 2021, Julee Enterprises borrows $34,000 to purchase a new Toyota Highlander by...

1a. On January 1, 2021, Julee Enterprises borrows $34,000 to purchase a new Toyota Highlander by agreeing to a 5%, 4-year note with the bank. Payments of $783.00 are due at the end of each month with the first installment due on January 31, 2021. Record the issuance of the note payable and the first two monthly payments. (If no entry is required for a particular transaction/event, select "No Journal Entry Required" in the first account field. Do not round...

Subjects