Excel: The remaining problems are to be solved in an Excel file. You should use one file for all questions and use separate tabs for each question. You may only open one blank file. If you use Excel for your calculations for other problems, use that same file but use new tabs for the problems here. Be sure to clearly label your answers. 1. 10 points. Heughan Mobile issued a $20,000,000, 10 -year 8% bond with semi-annual interest payments. Calculate the following three items: a. The semi-annual interest payments. b. The issue price if market rate when it was issued was 7.25% c. The issue price if the market rate when it was issued was 8% 2. 20 points. Balfe Auto Assembly issued a 5 -year, 10% bond of $12,000,000. Interest payments are made annually. It was issued to yield 11%. a. Calculate the issue price of the bond. b. Prepare the amortization table for the full life of the bond. c. Prepare the journal entries for the issuance of the bond, the first interest payment, the final interest payment, and the retirement of the bond. Excel: The remaining problems are to be solved in an Excel file. You should use one file for all questions and use separate tabs for each question. You may only open one blank file. If you use Excel for your calculations for other problems, use that same file but use new tabs for the problems here. Be sure to clearly label your answers. 1. 10 points. Heughan Mobile issued a $20,000,000, 10 -year 8% bond with semi-annual interest payments. Calculate the following three items: a. The semi-annual interest payments. b. The issue price if market rate when it was issued was 7.25% c. The issue price if the market rate when it was issued was 8% 2. 20 points. Balfe Auto Assembly issued a 5 -year, 10% bond of $12,000,000. Interest payments are made annually. It was issued to yield 11%. a. Calculate the issue price of the bond. b. Prepare the amortization table for the full life of the bond. c. Prepare the journal entries for the issuance of the bond, the first interest payment, the final interest payment, and the retirement of the bond