b. Do all parts of problem 11 of the Mathematics Problems. Do this problem witho

Question

b. Do all parts of problem 11 of the Mathematics Problems. Do this problem without, and with, the Chicago tax of 8%. A printout of an Excel spreadsheet must be part of your answer You are thinking about buying a new car. After all haggling with the dealer and after including all additional chargers like the Acquisition Fee, license sales taxes, your "out-the-door" price is $35,222.74. You decide to lease your new car. The MSRP (Manufacturer's Options is (MSRP+Options) $38,740.00. The car has an estimated Residual Value (should be close to the price at which you can buy the car at the end of the lease but might not be exact) of 58% of $38,740.00, that is, Residual Value $22,469.20. This leaves an amount to be depreciated of Depreciation $35,222.74 -$22,469.20 S12,753.54. (Notice that the (MSRP+Options) was only used to get the Residual Value of the car.) You are told that your monthly payment is $504.26 on a three-year lease [You don't need all of the information in the present paragraph to answer the questions I am about to ask, but I include this information in case y interested. The monthly payment of $504.26 consists of two parts. The first part is called Monthly Depreciation. This is simply $12,753.54/36 S354.26. The other part is called Monthly Rent Charge. In this case, it is (.08011/12)(S22,469.20)- $150.00. The sum of $354.26 and $150.00 is the monthly payment of $504.26.] ou are There are several numbers floating around in the previous paragraphs; but, here is the bottom line: You agree to a three year lease on a car that has an out- the-door price of $35,222.74. The car has a residual value of $22,469.20 after three years. You agree to pay $504.26 per month on the lease. Question: What is the implicit interest rate in this transaction? Hint to do this problem: After laying out the mathematics, use Excel to approximate the answer.

Explanation / Answer

Here the given car price = $35,222.74

The time period is n = 3years = 36 months

After 3 years, the residual value of the car is 22,469.2

The amount to be paid is = $35222.74 - 22469.2 = 12753.54

The monthly payment PMT =504.26

The rate of interst (annual ) using excel function = =RATE(36,504.26,-12753.54)*12=0.2458

For monthly interest rate = 0.2458/12 = 0.02 = 2%

Related Questions

Navigate

• Browse (All)
• Browse B
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.