/'[-

D. Case B - You have been to several banks to arrange financing for your car in Case A. The banks have offered a variety of terms and you want to analyze which loan might best fit your budget. Prepare another spreadsheet to include the following: 1. A column for each of the following possible interest rates: A. 3.0% B 4.0% C. 4.5% 5.0% 2. A column for (1) the amount of each monthly payment assuming the above annual interest rates and a 5 year loan, (2) the total amount of all 60 of your payments, (3) the total amount of all 60 amounts of interest, and (4) the total amount of principal you will pay over the life of the 5 year loan. 3. The amount of each monthly payment assuming the above annual interest rates and a 4 year loan. 4. A column for (1) the amount of each monthly payment assuming the above annual interest rates and a 4 year loan, (2) the total amount of all 48 of your payments, (3) the total amount of all 48 amounts of interest, and (4) the total amount of principal you will pay over the life of the 4 year loan