Question 1 Mr. Wilbur wants to re-finance her current loan with an outstanding balance of $185,039. He is approved at an annual rate of 4.12 % starting on 11/01/2017. He will repay the loan in equal bi-weekly payments for the next 15 years. Mr. Wilbur requested a loan amortization schedule for this loan. Create in your workbook a worksheet and name it Question 1. You will need to setup the worksheet using the layout of the sheet below. (HINT: First calculate how much the payments will be and using formulas create the amortization schedule showing each monthly payments for Mr. Wilbur's loan). . B D E F H 1 LOAN AMORTIZATION SCHEDULE 2 LOAN LOAN AMOUNT REPMNT. INTEREST RATE LIFE OF THE LOAN G J 1 3 5 6 7 MTH. PMT. DATE BEG BAL. FIXED PMT. INTEREST PAID PRINCIPAL PAID BALANCE AFTER PMT. ENDING BALANCE INTEREST CHARGED FOR THE PERIOD 8 0 11/01/20 17 11/05/20 17 9 1