Can anyone help me with these please??????/

Please explain step by step , so that if it's not the correct one, I can try by myself.

Computing Bond Issue Price and Preparing an Amortization Table in Excel On December 31, 2015, Kaplan, Inc., issues $550,000 of 9% bonds that pay interest semiannually and mature in 10 years (December 31, 2025). Round answer to two decimal places. Issue price $ The amortization schedule can be completed using the following Excel template: Using the figures from the amortization schedule created in Excel, complete the amortization schedule below for 2016: Enter answers using two decimal places