Please Slove Question According to the given format.

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. 1. 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. At the top of the worksheet (in columns A and B) type the following: *******All highlighted cell should contain formulas******** Bond - face amount Discount Carrying Value Term # of periods Stated % Stated % per period Market % Market % per period To prepare the amortization table type the following column headers: Cash Interest Payment Interest Expense Discount Amortization Unamortized Discount Carrying Value reference amounts from "data" section enter initial formulas for each column Date 1/1/15 6/30/15 12/31/15 6/30/16 12/31/16 6/30/17 12/31/17 6/30/18 12/31/18 6/30/19 12/31/19 6/30/20 12/31/20 6/30/21 12/31/21 6/30/22 12/31/22 6/30/23 12/31/23 6/30/24 12/31/24 copy & paste formulas from the top of each column enter sums 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. 1. 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. At the top of the worksheet (in columns A and B) type the following: *******All highlighted cell should contain formulas******** Bond - face amount Discount Carrying Value Term # of periods Stated % Stated % per period Market % Market % per period To prepare the amortization table type the following column headers: Cash Interest Payment Interest Expense Discount Amortization Unamortized Discount Carrying Value reference amounts from "data" section enter initial formulas for each column Date 1/1/15 6/30/15 12/31/15 6/30/16 12/31/16 6/30/17 12/31/17 6/30/18 12/31/18 6/30/19 12/31/19 6/30/20 12/31/20 6/30/21 12/31/21 6/30/22 12/31/22 6/30/23 12/31/23 6/30/24 12/31/24 copy & paste formulas from the top of each column enter sums