Objectives: Given terms of a loan, calculate a monthly payment. Create a spreadsheet to amortize the loan. Calculate the total amount of principal and interest paid each month. Calculate the total cost of a loan. Description: The purchase price and loan for three different vehicle is given in the following table. Model Subaru Outback Toyota RAV4 Ford Escape Terms of the loan 5 5 5 Interest rate 5.25% compounded semiannually 4% quarterly compounded 5.75% annually compounded Installments are paid on monthly basis. Requirement: You need to create loan amortization schedule each of the 3 vehicles. I