Suppose that you take out a $350,000 house mortgage from your local savings bank when the interest rate is 9%. The bank requires you to repay the mortgage in equal annual installments over the next 35 years. Please fill the amortization template provided as attachment. Further Guidelines You have to use formulas to complete the amortization template. Except for the following cell: - Loan Amount - Annual Interest Rate - Loan Period in Years The remaining cells should be calculated using Microsoft Excel formulas. No hardcoded numbers should be used for amortization table. Your assignment should be submitted via Moodle in Microsoft Excel Format. No other format will be accepted. The due date for the assignment will be provided at Moodle. This will make 10 percent of your overall mark