For all of the following questions: DO NOT type your answers into MyLO. There are many questions in this test. If you set up your spreadsheet correctly, you will have plenty of time to complete it. If you do not set up your spreadsheet correctly, you may run out of time. To answer the questions, copy the answer cell from Excel and paste the value into MyLO. DO NOT type your answers into MyLO. They will be marked as incorrect. Please ensure that the formatting of your answers is correct. If you do not use the correct formatting, your answer will be marked as incorrect. Your answer cells MUST be formatted to Currency, with 2 decimal places and the $ symbol. Use the PMT formula on these questions. With a loan of $800000 , 12 repayments per year (monthly repayments), a term of 10 years and an interest rate of 2% per annum, what is the required repayment per month?____