In the Excel file uploaded in D2L (use the following link), I have shown how to calculate the total monthly installment to be paid and month wise principal and interest payments for a S150,000 home loan for 30 years with an annual interest rate of 4% ://www.msub le/content/4888 ewContent/3462686 You undertake similar exercise for all the following 5 loans Loan Amount $100,000 $200,000 $250,000 5400,000 1,000,000 ime 15 years 0 vears 20 vears 5 vears 30 vears Annual Interest Rate 3.60% 3.75% 3.80% 4.00% 4.25% Assume that the payments are monthly and monthly interest rate is Annual interest rate/12. Find out the monthly installment for each of the loans. Show the principal and interest payments for each month and run down the ending balance to zero. Also draw the chart (as shown in the example excel sheet) for each of the five loans. Use five different spreadsheets of the same Excel file for these five loans Make your observations on the interest payment of these five loans. In the Excel file uploaded in D2L (use the following link), I have shown how to calculate the total monthly installment to be paid and month wise principal and interest payments for a S150,000 home loan for 30 years with an annual interest rate of 4% ://www.msub le/content/4888 ewContent/3462686 You undertake similar exercise for all the following 5 loans Loan Amount $100,000 $200,000 $250,000 5400,000 1,000,000 ime 15 years 0 vears 20 vears 5 vears 30 vears Annual Interest Rate 3.60% 3.75% 3.80% 4.00% 4.25% Assume that the payments are monthly and monthly interest rate is Annual interest rate/12. Find out the monthly installment for each of the loans. Show the principal and interest payments for each month and run down the ending balance to zero. Also draw the chart (as shown in the example excel sheet) for each of the five loans. Use five different spreadsheets of the same Excel file for these five loans Make your observations on the interest payment of these five loans