prepare journal entries to record the following transactions for

I. Prepare a separate "data" section at the top of your worksheet. 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. When formatting, consider alignment, spacing, and presentation of the amortization schedule. & Include appropriate page headers and date for the assignment. Clearly label all of your work Use "Help" if you need assistance in entering formulas or formatting cells. & When you have completed your spreadsheet: Upload to el.earn under "Assignments" in Week 4 using the link to Chalk & Wire