Please use spreadsheet to do it thankss!!!!!!!!

Computer Questions - Use a spreadsheet to answer the following questions (38 marks total) 1. A loan of $30,000 is to be paid back with semi-annual payments over 10 years at i(2) = 8%. The first payment is R and each succeeding payment increases by 12%. Set up an amortization table. Graph the resulting outstanding balances (using a column graph). Make sure your x-axis goes from 0 to 20. (4 + 2 = 6 marks)