July Additional Assignment: Recall the $45,000 loan that The MixMax Company arranged to finance the purchase of its equipment back on January 1, 20X1. The terms of the loan required monthly payments of $1,001, the first one to be made on February 1, 20X1, and the last on January 1, 20X6 (5 years), at a 12 percent annual interest rate, compounded monthly. Part A: Using Excel, set-up and complete the following schedule. Numbers should be entered in the input area for N, I, and PV. Use Excel to calculate the Payment. Every cell in the loan amortization schedule should contain a formula except for the Period column. Option A N | PV PMT Interest Note Period Payment Expense Principal Payable 0123 0 1,001 2 1,001 3 1,001 45,000 669 59 1,001 60 1,001 0 TOTALS 15,060 45,000