Construct a loan amortization table for a 20-year fixed rate mortgage with annual interest rate of 3.6%. The amount borrowed is $500,000. In addition, compute the WAL (weighted average life) of the loan. Assume there is no prepayment throughout the life of the loan.

Please use EXCEL to complete this question. The loan amortization table should show the monthly mortgage payment, monthly interest payment and principal repayment, and monthly beginning/ending loan balance.