Scenario:\ Company A operates major manufacturing facilities in five regions.\ All five regions issued bonds to finance purchases of large pieces of machinery.\ Bond discounts are amortized annually on December 31 using the straight-line 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 y the bond has been in effect, and the call price of the bond if it has been redeemed early. If the Call price paid column includes an amount, it indica 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.

$

\ R2. Cell I2: 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 negativ amount. If the bond has not been redeemed, leave the Gain (Loss) amount column blank.

Company A operates major manufacturing facilities in five regions. All five regions issued bonds to finance purchases of large pieces of machinery. Bond discounts are amortized annually on December 31 using the straight-line 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 y the bond has been in effect, and the call price of the bond if it has been redeemed early. If the Call price paid column includes an amount, it indic 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. $ R2. Cell I2: 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 negativ amount. If the bond has not been redeemed, leave the Gain (Loss) amount column blank