I-Bar Co sold bonds on January 1, 2012. The bonds pay interest on January 1 and July 1. Data relating to these bonds are as follows: Face $100,000 Stated Rate Effective Rat 8% Issued at 92 278% 10% Instructions: b) Cakulate the Cash Received from the Bond Sale a) Cakulate the Semi Annual Bond Interest Rates Annual Semi-Annual Stated Rate Cell Reference Fomula Effective Rate Cell Reference Fomula Label Label Cash Received Cell Reference Cell Reference Fomula c) Prepare the joumal entry to record the issuance of the bonds on January 1, 2012 01/01/12 Account title Account title Account title Cell Reference Formula Cell Reference d) Cakulate the Semi-Annual Interest Payment Label Label Interest to be paid ell Reference ell Reference Formula e. Prepare a bond interest and amortization schedule. When creating the cell reference for column A of the table.hit F4.after the reference but before hitting enter. Also, when entering the SFormula for column B in the wbk, hit F4.after referencing to the interest rate. Using F4 will allow! you to lock the referencing portion of the formulas into place so you can highlight the entire row and drag it down to the end of the cable. When the table is complete, you will be off.by_sl in the last row of columns Dand F because of rounding Effective Interest Method-Semiannual Interest Payments (A) (B) (C) D ( E Date Semi- Interest Bond Amortized Unamortized Bond annual to be interest Amount Amount Carrying Va Interest Pald Expense Value Periods 1/1/2012 Issue date Cell Reference Cell Reference 7/1/2012 Cell referenc Formula Formula Formula Formula 12/31/2012 Cell referenc Formula Formula Formula Formula Cell referenc 7/1/2013 Formula Fomula Formula Cell referenc 12/31/2013 Formula Formula Formula Formula Cell referenci Formula Formula 7/1/2014 Formula Formula Cell referenc 12/31/2014 Formula Formula Formula Formula Cell referenc Formula 7/1/2015 F Formula Formula ula Formula Formula Formula Fomula 12/31/2015 Cell referenc Cell referenc Formula Formula 7/1/2016 Formula Formula Formula Cell referend Formula Formula 12/31/2016 Formula I-Bar Co sold bonds on January 1, 2012. The bonds pay interest on January 1 and July 1. Data relating to these bonds are as follows: Face $100,000 Stated Rate Effective Rat 8% Issued at 92 278% 10% Instructions: b) Cakulate the Cash Received from the Bond Sale a) Cakulate the Semi Annual Bond Interest Rates Annual Semi-Annual Stated Rate Cell Reference Fomula Effective Rate Cell Reference Fomula Label Label Cash Received Cell Reference Cell Reference Fomula c) Prepare the joumal entry to record the issuance of the bonds on January 1, 2012 01/01/12 Account title Account title Account title Cell Reference Formula Cell Reference d) Cakulate the Semi-Annual Interest Payment Label Label Interest to be paid ell Reference ell Reference Formula e. Prepare a bond interest and amortization schedule. When creating the cell reference for column A of the table.hit F4.after the reference but before hitting enter. Also, when entering the SFormula for column B in the wbk, hit F4.after referencing to the interest rate. Using F4 will allow! you to lock the referencing portion of the formulas into place so you can highlight the entire row and drag it down to the end of the cable. When the table is complete, you will be off.by_sl in the last row of columns Dand F because of rounding Effective Interest Method-Semiannual Interest Payments (A) (B) (C) D ( E Date Semi- Interest Bond Amortized Unamortized Bond annual to be interest Amount Amount Carrying Va Interest Pald Expense Value Periods 1/1/2012 Issue date Cell Reference Cell Reference 7/1/2012 Cell referenc Formula Formula Formula Formula 12/31/2012 Cell referenc Formula Formula Formula Formula Cell referenc 7/1/2013 Formula Fomula Formula Cell referenc 12/31/2013 Formula Formula Formula Formula Cell referenci Formula Formula 7/1/2014 Formula Formula Cell referenc 12/31/2014 Formula Formula Formula Formula Cell referenc Formula 7/1/2015 F Formula Formula ula Formula Formula Formula Fomula 12/31/2015 Cell referenc Cell referenc Formula Formula 7/1/2016 Formula Formula Formula Cell referend Formula Formula 12/31/2016 Formula