D E A company issued bonds dated January 1, 2020 with a par value of $500,000 and a stated rate of 8% Interest is paid semiannually on June 30 and December 31. The bonds mature in two 7 years. The annual market rate at the date of issuance is 10%. 2 3 Par Value 4 Stated Interest Rate 5 Market Interest Rate 6 n 7 i 8 pmt 9 Calculate the bonds' selling price. Round calculations to the nearest dollar. Tables are 10 included in subsequent tabs to this Excel file. You may use the tables or Excel. (3.5 points) 11 12 73 14 15 Prepare an Amortization table using the effective interest method. Fill in the blanks in the headings to indicate if there is a premium or discount. Round calculations to the nearest 16 dollar. (14.5 points) 17 Bond Semiannual Interest Cash Interest Interest Unamortized Carrying 18 Period End Paid Expense Amortization Value 19 20 21 22 23