Question 4 You must answer this question using an Excel spreadsheet. Please name the excel as: XXXXXX_AT3_BFA503 where xxxxxx is your student ID number. Tom and Laura are applying for a home loan to buy their first home. Their targeted property's price is $620,000 and the bank agrees to lend them 80% of the property value. The home loan offer is for a 30-year term at the rate of 3.00% p.a compounding monthly. Required a. Calculate the monthly payment that Tom and Laura must make under this home loan arrangement. [6 marks] b. Calculate the total interest payment from the beginning of the loan until the end of year 9. How much principal repayment has been made over the first 9 years? [5 marks] C. What is the outstanding loan balance at the end of year 12? [3 marks] d. Draw a timeline to demonstrate the cash flow pattern including monthly payment and outstanding balance in (a) and (c) [4 marks] [Question 4: 18 marks]