In the Excel file uploaded in D2L, I have shown how to calculate the total monthly installment to be paid and month wise principal and interest payments for a $150,000 home loan for 30 years with an annual interest rate of 4%. You undertake similar exercise for all the following 5 loans: Loan Amount Time Annual Interest Rate $100,000 15 years 3.60% $200,000 3.75% $250,000 3.80% $400,000 4.00% $1,000,000 30 years 4.25% 20 years 20 years 25 years 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, I have shown how to calculate the total monthly installment to be paid and month wise principal and interest payments for a $150,000 home loan for 30 years with an annual interest rate of 4%. You undertake similar exercise for all the following 5 loans: Loan Amount Time Annual Interest Rate $100,000 15 years 3.60% $200,000 3.75% $250,000 3.80% $400,000 4.00% $1,000,000 30 years 4.25% 20 years 20 years 25 years 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