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