Use Excel to answer the following question.

8.A loan of $50,000 is to be paid back with semi-annual payments over 12 years at i⁽²⁾ = 9%.The first payment is R and each succeeding payment increases by 8%.Set up an amortization table.Graph the resulting outstanding balances (using a column graph).Make sure your x-axis goes from 0 to 24.