N27 fx A B C D E F G H 1 J K L M N P 2 On January 1, 2021, Bobcat Company sold 10% bonds having a face value of $300,000 to yield 12% market rate. 3 The bonds are dated January 1, 2021 and mature in 5 years, with interest payable semiannually on July 1 and January 1 of each year, starting July 1, 2021. 4 5 Instructions 6 Prepare complete bond amortization schedules for Bobcat using the Excel templates on the following tabs. 7 8 Tab 1: Assume Bobcat allocates interest and unamortized discount or premium on the EFFECTIVE-INTEREST (EI) basis. Make sure to fill in dates as well. 9 10 Tab 2: Assume Bobcat allocates interest and unamortized discount or premium on the STRAIGHT-LINE (SL) basis. Make sure to fill in dates as well. 11 12 Notes: Compute the present value of the bond using Excel formulas. All highlighted cells should be formulas. For example, cash interest payment should have something like: 300,000*10%*6/12 13 14 Questions Tab: Using your tables, answer the related questions on the question tab. 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Instructions Tab 1 El Template Tab 2 SL Template Questions +