PLEASE USE EXCEL TO SOLVE THIS QUESTION

2. A bank called you to offer an RM10,000 loan for your Hari Raya expenditures. The loan is to be paid monthly in arrears over 2 years. The offer sounds enticing as the rate is 3% per annum. But that is not the annual effective interest rate, i. The total interest amount to be paid is 10,000*(3%*2 years) and the monthly payment will be 10,000*(1+3%*2 years)/24 over 24 months. a) Using a random value of i, construct a table listing outstanding balance(Bt), principal repaid (Pt) ,and interest paid (It) for each t from month 1 to 24. (3 Mark) b) Find the actual effective interest rate, using goal seek