Additional August Assignment: Recall the $45,000 loan that The MixMax Company arranged to finance the purchase of its equipment back on January 1, 20X1. Consider the possibility that the company might have issued a 5-year, 12% APR, coupon bond in place of the loan, compounded semiannually. Part 1 - Using Excel, set-up and complete 3 sheets using the following schedule, assuming that the bonds were issued at a. Par (12 percent market rate) b. Premium (10 percent market rate) c. Discount (14 percent market rate) Use the Excel PV function to calculate the Present Value of each bond. PVC PMT FV Interest Payment interest Expense Premium/ Discount Amortization Ending Carrying Value Bonds Payable Premium/ (Discount) 1-1-X1 6-30-X1 12-31-X1 6-30-X2 12-31-X2 6-30-X3 12-31-X3 6-30-X4 12-31-X4 6-30-15 12-31-X5 TOTALS