Insert Draw Page Layout Formulas Data Review View Helo Editing - 3 Calibri BEBv av A. Er mv General Thanks for using Office Weve made some updates to the playing to give you more control your decliyou to several oud-backed series. You art to go to the otict on the web Pinay Settings. These optional dous bedred festes are provided to you under the Microsoft Strical Agreement and fe QUESTION 2: BONDS PAYABLE (@mads) 0 G H QUESTION 2: BONDS PAYABLE (8 marks) On January 1, 2022, Cookie Ltd. issued severwyear, 4% bonds with a face value of $800,000. The bonds provide the bondholders a 3% yield and pay Interest semi-annually on July 1 and January 2. The company follows IFRS, has an August 31 yearend, and uses the effective interest method to amortize any discount or premium. REQUIRED (1). Calculate the bond issun prion, state whether the bond is issued at a premium or discount and state the premium or discount amount in positive terms). Round issun price to nearest whole dollar (o decimals) using the ROUND fomula. The Wy or rate can be entered as a decimal or whole number Bond Issue price Premium or Discount? Premium of Discount Amount ($2 n 9 10 PMT 11 y or rate TA State positivel Cover Sheet 02 Calculation Mode Automatic Workbook Q3 04 05 06 + INUW 1ao X x olo acel rsingh145 g - Savedi v Search (Alt + 0) View V File Home Insert Draw Page Layout Formulas Data Review Helo Editing Calibri V 14 BEY GAY y , General 8 Thanks for using Office Weve made some updates to the pracy settings to get you more control. Your organization's admin allows you to use seweral doud-based in, you get to deddew to to the Office on the wtb Pracy Settings. Thest options dubidest provided to you under the Microsoft Services Agreement lume 1 50 QUESTION 2: BONOS PAYABLE (@marks) D F G H 10 PM 11 Vyot rate 12 PY PY *ROUND DOO 12 decimals 14 15 (2). Complete the bond amortization table for the first two interest payments. Round Interest expense to the nearest whole dollar (0 decimals) using the ROUND formula State all amounts in positive numbers II Use cell referencing to Input values abowe in requirement (1). The amortization schedule should be prepared in positive numbers similar to what we did in class. G Date Interest expense Interest Payment Amortization Carrying amount *ROUND 13 1.Jan.22 interest 19 1-Jul-22 expense to 20 1 Jan 23 decimals 21 22 END OF QUESTION 2 17 value 24 Activate 04 OS06 Cover Sheet 01 02 03 Cilicon Mode Autom Workbook F