Please answer question in the Excel spreadsheet format below. All calculations have to include cell references and formulas to be condsidered for full credit. Thank you.

Suppose you just borrowed $76,000 and arranged for a 2-year loan with monthly payments beginning one month from today. Prepare the amortization schedule for this loan. The interest rare is 8.2058 . Show the total amounts in payment, interest, and principal. To complete this part efficiently, set up the formulas in the first row of the table, and utilize Copy/Paste to fill out the