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