Please help with how to solve formulas because I have to put in in excel on how i got it thanks for the help in advance

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