i need clarity. i am confuse by the expert answers

Due Date: Uploaded to Canvas (Under Assignments) by 10/10/2021 at 11:59pm. No late work will be accepted. Complete all of the required tasks utilizing excel and label everything. No partial credit can be given if no work is shown. 5. On 1/1/2018, a Company issued a 9.75% stated rate bond with a face value amount of $12 million. The bonds mature in 20 years. The market rate of interest for similar issues was 10.25%. Interest is paid semi-annually on 6/30 and 12/31. a. How much is each interest payment? b. What was the issue price of the bonds