Read Carefully: The car the client wants to purchase is a 2023 BMW 750 i that has a sticker price of $136,778 and was approved at an interest rate of 7.00% for 6 years or 72 months. The client has agreed to pay $20,000 towards the sticker price as a down payment. 4. In cells C5 to C10, enter the BMW Financial Loan Terms. 5. In cell C11, calculate the monthly payment of the loan. 6. In cell C15, using a cell reference, enter the principal value of the loan. 7. In cell D15, calculate the Interest Payment. 8. In cell E15, calculate the Principal Payment. 9. In cell F15, sum cells D15 and E15 to calculate the Total Payment. 10. In cell C16, calculate the next starting principal balance. 11. Complete the rest of the Amortization Schedule for the car. BMW Financial Analysis Read Carefully: The car the client wants to purchase is a 2023 BMW 750 i that has a sticker price of $136,778 and was approved at an interest rate of 7.00% for 6 years or 72 months. The client has agreed to pay $20,000 towards the sticker price as a down payment. 4. In cells C5 to C10, enter the BMW Financial Loan Terms. 5. In cell C11, calculate the monthly payment of the loan. 6. In cell C15, using a cell reference, enter the principal value of the loan. 7. In cell D15, calculate the Interest Payment. 8. In cell E15, calculate the Principal Payment. 9. In cell F15, sum cells D15 and E15 to calculate the Total Payment. 10. In cell C16, calculate the next starting principal balance. 11. Complete the rest of the Amortization Schedule for the car. BMW Financial Analysis