You will be using Excel as a tool to assist in solving this accounting problem. Students completing this assignment will demonstrate the ability to: Use arithmetic operators (addition, subtraction, multiplication, and division) in spreadsheets. Enter simple formulas into spreadsheets to calculate values Copy formulas from one cell to another. Use the sum function. Format cells using decimal points, currency, etc. Right Click; Click Format cells; Click Number; Click Currency or Date Use underline, bold, spacing (left, center, right) functions. Create appropriate headers and footers including date ALWAYS include a header with your name, assignment, and date Create borders-Right click; Click Format; Click Border Print selected problem area. Print landscape versus portrait You are to independently prepare an amortization schedule for the bond problem (below) using Excel. You MUST use formulas where possible. There is very little data that should be 'hard-keyed' into the spreadsheet. 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, 69%, 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%. Prepare a bond amortization schedule using the effective interest methed to amortize the bond discount or premium. II 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 formalas into all cells requiring you to perform mathematical functions. DO NOT