1- Bar Co. sold bonds on January 1, 2012. The bonds pay interest on January 1 and July 1 andl-Bar. Data relating to these bonds are as follows: Face $ 100,000 92.278% Issued at Stated Rate Etteotive RS 8% 10% Instructions A Calculate the Cash Received from the Bend Salf al Calculate the Semi Annual Bend Interest Rates Annual Semi-Annual Stated Rate Effective Rate Cash Received 1 2 3 4 15 25 7 18 19 20 21 22 Prepare the journal enter te zecord the issuance of the donds en vanuary 2012 01/0412 Calculate the Semi-Annual Interest Payment 24 Interest to be paid 26 21 28 29 31 32 34 2. Prepare a bond interest and amertization schedule. When creating the cell reference for column of the fable. Ail E alter the reference but before Aitting cater. Also, when catering the Ecrmula for columa Bis the rable. Ait Et after referencing to the interest rate. Using Ef vill allar per teleck the referencing action. the formulas inte place secu.can Aiolonc. the entire sex and drap it down to the end of the table. co the cable is Effective Interest Method-SemiannualInterest Pagments TA (B C D JE Semi- Interest Bond Amortized Unamortized Bond annual to be Interest Amount Amount Carrying Interest Paid Expense Value Date Periods 36 WW2012 Issue date 37 771/2012 1 38 12/342012 2 39 711/2013 3 40 12/342013 4 7112014 5 42 12/34 2014 6 43 7/1/2015 7 44 12/31/2015 0 45 7/2016 $ 46 12/31/2016 10 37 40 41 42 45 n 44 GI 45 46 n 47 16 th 50 ad 51 am 52 35 54 Prepare the journal entitet interes the mentice ca 12 07/0112 / Sher the delance sheeresentation of the Bends Pagal at December 2014 oa 55 6