Amortized Loan Payment Schedule Excel Assignment Using Excel formulas, please complete the following information in the required cells (see yellow highlighted cells): Annual Interest Beginning Balance for Years 2 10 Ending Balance for Years 1 10 Total Amount of Payments Total Cumulative Interest On January 1st, company borrows $2,000,000 to be paid back over 10 years. The annual interest rate for the loan is 10%. The annual payment of $325,490.79 will be paid on December 31st of each year.