Read the problem. Identify and list the following data relevant to preparing an amortization schedule: Face amount Discount or premium Carrying value (Price of bonds) Term (years) Number of Periods Stated rate of interest (annual %) Stated rate per period Market rate of interest (annual %) Market rate per period The ABC Company issued $800,000 face value, 6%, 10 year bonds on January 1, 2015, with bond interest payments each June 30 and December 31. The bonds sold for $691,287 when the market rate of interest was 8%. II. Prepare a bond amortization schedule using the effective interest method to amortize the bond discount or premium To enter the data into the amortization schedule, copy the data from the "data" section. Enter formulas to compute: Cash interest paid Interest expense Discount amortization Unamortized discount Carrying Value Include headers in the amortization schedule to label each column When completing the problem enter formulas into all cells requiring you to perform mathematical functions. DO NOT enter the dollar amounts directly into those cells