Question

In: Finance

Prof. Finance decides to buy a 2019 Mazda 6 Signature Edition. After paying a down payment...

Prof. Finance decides to buy a 2019 Mazda 6 Signature Edition. After paying a down payment and taxes, Prof. Finance can finance the rest of the purchase price with a loan of $24,000 for 60 months at a special finance rate offered by Mazda of 1.9% APR compounded monthly.

• He finds out that Mazda has a second offer of $1000 cash back (rebate) in place of the special 1.9% finance rate offered with the cash back being an additional down payment. Prof. Finance finds he can get 2.9% APR financing online for 60 months if he takes the $1000 cash back offer. Answer the following questions.

1. What is the effective annual rate for each loan?

2. What would be the monthly car loan payment under the Mazda’s 1.9% APR financing offer (assume a 60-month loan term)?

3. What would be the monthly car loan payment under the Mazda’s $1000 cash back offer and the 2.9% APR pre-approved financing (assume a 60-month loan term)?

4. At what APR would Prof. Finance be indifferent between the two offers? In other words, what APR (assuming a 60-month loan term) for the $1000 cash back offer would have the same monthly payment with the 1.9% APR financing offer?

5. Let’s assume you go with the offer in question #3. Construct an amortization schedule for the loan for all 60 monthly payments (see section 5-18 of the textbook). What is your loan balance after 36 months?

6. The local Mazda dealer has found a special 2.49% APR loan rate for 60 months from Citibank that Prof. Finance qualifies for if he elects the $1000 cash back option. Prof. Finance says that’s great! What would be the monthly payment under this loan?

7. Prof. Finance is more than happy with the 2.49% APR and $1000 cash back offer but wants a monthly payment of $375 (assume a 60-month loan term) and realizes he will have to put more money down. How much additional money will Prof. Finance have to put down in order to achieve his target monthly payment? Note: original loan amount with cash back was $23,000.

Solutions

Expert Solution

1]

EAR = (1 + (APR / compounding frequency)compounding frequency - 1

Here, the compounding frequency is 12 as the payments are monthly

EAR of 1.9% loan = (1 + (1.9%/12))12 - 1 = 1.917%

EAR of 2.9% loan = (1 + (2.9%/12))12 - 1 = 2.939%

2]

Monthly payment is calculated using PMT function in Excel :

rate = 1.9% / 12 (converting annual rate into monthly rate)

nper = 60 (60 months is the loan term)

pv = 24000 (loan amount)

PMT is calculated to be $419.62

3]

Monthly payment is calculated using PMT function in Excel :

rate = 2.9% / 12 (converting annual rate into monthly rate)

nper = 60 (60 months is the loan term)

pv = 23000 (With the additional down payment, loan amount is reduced by $1000)

PMT is calculated to be $412.26

4]

APR for 2.9% loan is calculated using RATE function in Excel :

nper = 60

pmt = -419.62 (monthly payment with 1.9% APR. This is entered as a negative number because it is a cash outflow)

pv = 23000 (loan amount)

RATE is calculated to be 0.3014%. This is the monthly rate. To get annual rate, we multiply by 12. Annual rate is 3.62%

The APR should be 3.62%


Related Solutions

In order to buy a new car, you finance $23,000 with no down payment for a...
In order to buy a new car, you finance $23,000 with no down payment for a term of five years at an APR of 6%. After you have the car for one year, you are in an accident. No one is injured, but the car is totaled. The insurance company says that before the accident, the value of the car had decreased by 25% over the time you owned it, and the company pays you that depreciated amount after subtracting...
Assume that you decides to buy a house for $187,600. You will pay 20% down payment...
Assume that you decides to buy a house for $187,600. You will pay 20% down payment by your saving and fund the remaining amount (i.e., 80% of the house price) using a mortgage loan. The bank offers 30-year mortgage with monthly interest 0.5313%. You will pay backthe loan in equal amount at the end of each month for the next 30 years. (In other words, just like real-world practice, you will pay back the loan using equal-amount monthly payments).  How much...
Prudence Corporation purchased a machine for $460,000 on September 1, 2019, by paying 20% down payment...
Prudence Corporation purchased a machine for $460,000 on September 1, 2019, by paying 20% down payment in cash and for the balance amount signed a 6%, 10-month note payable for the balance amount. Interest and principle will be paid back together at the end of the note. Prepare journal entries to record: the purchase of the delivery truck, the adjusting journal entry to record the accrued interest on December 31, and the payment of the note at maturity along with...
Dr. Zoidberg decided to buy a 2019 Tesla Model S P100D Hatchback for $130,000. After paying...
Dr. Zoidberg decided to buy a 2019 Tesla Model S P100D Hatchback for $130,000. After paying a down payment and taxes, Dr. Zoidberg can finance the rest of the purchase price with a loan of 100,000 for 5 years at a promotional finance rate of 3% APR compounded quarterly. Please answer the following questions: a. What is the effecting annual rate changed on this loan? b. What would be the quarterly payment on this loan? c. Dr. Zoidberg also discovers...
You are about to buy a home; the purchase price of the car is $200,000 and you are paying 10% of that amount as a down payment and financing the remainder.
You are about to buy a home; the purchase price of the car is $200,000 and you are paying 10% of that amount as a down payment and financing the remainder. Your mortgage loan terms are 30 years of monthly payments at an annual rate of 3.25%.How much are your monthly mortgage payments?Over the life of the loan, how much did you pay in interest?
Derek decides to buy a new car. The dealership offers him achoice of paying $598.00...
Derek decides to buy a new car. The dealership offers him a choice of paying $598.00 per month for 5 years (with the first payment due next month) or paying some amount today. He can borrow money from his bank to buy the car. The bank requires a 6.00% interest rate. What is the most that he would be willing to pay today rather than making the payments?
1. Derek decides to buy a new car. The dealership offers him achoice of paying...
1. Derek decides to buy a new car. The dealership offers him a choice of paying $571.00 per month for 5 years (with the first payment due next month) or paying some amount today. He can borrow money from his bank to buy the car. The bank requires a 6.00% interest rate. What is the most that he would be willing to pay today rather than making the payments?2. Derek plans to buy a $33,258.00 car. The dealership offers zero...
Derek decides to buy a new car. The dealership offers him achoice of paying $515.00...
Derek decides to buy a new car. The dealership offers him a choice of paying $515.00 per month for 5 years (with the first payment due next month) or paying some amount today. He can borrow money from his bank to buy the car. The bank requires a 5.00% interest rate. What is the most that he would be willing to pay today rather than making the payments?Derek plans to buy a $28,418.00 car. The dealership offers zero percent financing...
Derek decides to buy a new car. The dealership offers him achoice of paying $524.00...
Derek decides to buy a new car. The dealership offers him a choice of paying $524.00 per month for 5 years (with the first payment due next month) or paying some amount today. He can borrow money from his bank to buy the car. The bank requires a 5.00% interest rate. What is the most that he would be willing to pay today rather than making the payments?
Derek decides to buy a new car. The dealership offers him achoice of paying $518.00...
Derek decides to buy a new car. The dealership offers him a choice of paying $518.00 per month for 5 years (with the first payment due next month) or paying some amount today. He can borrow money from his bank to buy the car. The bank requires a 6.00% interest rate. What is the most that he would be willing to pay today rather than making the payments? Round to: 2 decimal places.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT