PLEASE SOLVE USING EXCEL AND SHOW DETAILED STEPS SO I CAN LEARN

The Tesla dealer offers your professor a loan to purchase the $85,000 Tesla today. a. The loan is offered at a rate of 8% annual compounding for the 5 years. They will make annual payments. Compute the following: i. Aual loan payment amount i. Total interest paid over the entire 5 years ii Total principal paid over the entire 5 years iv nterest paid by the end of year one V. Principal paid by the end of year one The loan is offered at a rate of 8% monthly compounding for the 5 years. Calculate the effective annual rate and then recalculate the following values. They will make annual payments. Compute the following: b. i. Loan payment amount ii Total interest paid over the entire 5 years ii Total principal paid over the entire 5 years