Please help answer these questions below.

Scenario: Company A operates major manufacturing facilities in ve regions. All ve regions issued bonds to nance purchases of large pieces of machinery. Bond discounts are amortized annually on December 31 using the straightrline method. The Data worksheet contains a list of bonds. Each row provides information about one bond for one region, including face amount, discount amount when issued, term in years, number of full years the bond has been in effect, and the call price of the bond ifit has been redeemed early. If the Call price paid column includes an amount, it indicates that the bond has been repaid. Required: Open spreadsheet Complete three columns on the Data worksheet: Annual amortization, Carrying amount to date, and Gain (Loss) amount. R1. Cell H2: Enter a formula that results in the annual amortization amount using the data in row 2. $:l R2. Cell 12: Enter a formula that results in the carrying amount to date using the data in row 2. $:] R3. Cell K2: Enter a formula that results in the amount of gain or loss, if applicable, using the data in row 2. Enter a loss, if applicable, as a negative amount. If the bond has not been redeemed, leave the Gain (Loss) amount column blank. $l:l R4. Copy dawn the entries in cells H21 [2, and K2 to all other rows with data. Steps to create a pivot table: 51. Select a cell in the data on the Data worksheet. 52. Select Insert l PivotTable. The data range will automatically be inserted. A \"Create PivotTable" window should appear. $3.1n the window, under "Choose where you want the PivotTable report to be placed", select \"New Worksheet". A new worksheet should appear With the PivotTable. S4. A PivatTahle Field List should pop up. Drag fields into rows, columns, lters, and values areas as needed. (If this gray work box does not appear, right click in the pivot table and select "Show Field List".) Questions: Use the information on the Data worksheet and pivot tables, formulas, and/or functions to answer the Following questipns. Q1. What is the total carrying amount for bonds held more than 10 years in the York region? $:l Q2. What is the amount of the total net gain or loss for bonds that were redeemed In the Caralina and Jersey regions? (Enter a loss as a negative number.) $:l Q3. What is the total amount of annual amortization for the Mexico region on all bonds that have not yet been redeemed? $:l Q4. What is the amount of the highest call price oic any 25 or 307year term bond? $:l A B C D E F G H K Bond Region Face amount Discount amount Years in term Years held Annual amortization Carrying amount to date Call price paid Gain (Loss) amount Bond 22 Mexico 9,700,000 2,790,000 20 6 7,592,000 W Bond 94 Mexico 3,900,000 1,683,000 30 2,662,000 Bond 128 York 1,300,000 36,000 5 P UT Bond 139 York 3,300,000 477,000 10 3 6 Bond 123 Jersey 4,800,000 342,000 5 1 4662000 Bond 88 Carolina 8,300,000 1,791,000 15 5 8 Bond 54 Carolina 7,800,000 1,683,000 15 9 Bond 71 Carolina 1,800,000 288,000 30 21 10 Bond 70 Carolina 8,400,000 3,627,000 30 11 6286000 Bond 102 York 6,300,000 2,718,000 30 19 5409000 12 Bond 111 York 5,600,000 603,000 20 12 5,305,000 13 Bond 138 York 6,100,000 990,000 30 11 14 Bond 146 Jersey 2,600,000 558,000 15 8 15 Bond 45 York 3,200,000 918,000 20 5 2562000 16 Bond 39 Mexico 5,000,000 1,080,000 15 6 17 Bond 116 York 7,900,000 216,000 5 4 8,093,000 18 Bond 10 Dakota 6,200,000 891,000 10 8 19 Bond 3 Carolina 4,200,000 1,512,000 25 19 3,914,000 20 Bond 41 York 6,100,000 990,000 30 15 5,773,000 21 Bond 13 Dakota 9,000,000 729,000 15 11 8894000 22 Bond 29 Carolina 3,400,000 981,000 20 15 3,092,000 23 Bond 141 Carolina 1,500,000 81,000 10 7 24 Bond 19 York 900,000 72,000 15 9 862000 25 Bond 97 Jersey 5,600,000 450,000 15 7 5306000