On January 1, 2022, Atlas Company issues 16%, $2,000,000 20-year bonds and the bonds pay interest semi-annually on Jun 30 and Dec 31 each year. The market interest rate at the date of issue is 12%.

1. Calculate the price of the bonds at the issue date (4 points). Use tab one (Bond Price) on the template given
2. Prepare a bond amortization table for the bonds (21 points). Use tab two (Amortization) on the template given

AutoSave OF AA? 2... Make-up Homework_Bond Amortization Home Insert Draw Page Layout Formulas Share Comments Aa Colors MI Data Review View Tell me TR E - Width: Breaks Background Print Page 1) : Height: Titles Setup Automatic Gridines Headings View When Themes As Fonts Margins Orientation Size Print Automatic Area Print Print C7 X fx A B c D G H K L L M N o P R 5 5 T 2 Unamortized Balance Carrying Value 5 5 6:30291 71 8 9 10 11 12 13 14 15 16 17 12 19 20 21 22 23 23 24 25 26 27 28 29 30 24 31 32 3.3 34 35 36 37 38 39 40 41 42 43 44 49 46 47 Date Interest Payment Interee! E Interest Expense 1 Expense Amortization 1/1/22 6/30/22 12:31:22 6/30/23 12/31/23 6/30/24 121811:24 6/3025 12/31:25 E12025 12/31/28 6:2027 12/31/27 G/30129 12:31.29 : 12/31/29 B/30/30 121313 6/30/31 12/31/31 6/30/32 123132 6/30/33 12/31/33 6/30/34 12/31/34 6/30/35 DO 12/31/35 6303 12,31131 E20437 12/21/37 63013 12/31/39 G:20:39 12/31/39 6:30140 B 12:31:401 BX30141 12/31/41 TOTAL Bond Price Bond Amortization + Ready EN + 100%