Need to fill out excel sheet. Please also write down the dates and everything and send it in excel format thank you ill be sure to give full 5/5 rating then!

Record your responses on the spreadsheet template. 1. On January 1, 2014, Bernard Ltd. issues 500 5% bonds with a face value of $1 000. The bonds mature on December 31, 2023 and pay interest semi-annually. Prepare all the necessary journal entries to record the issue of the bonds for each of the following scenarios. . bonds sold at 100 . bonds sold at 102 . bonds sold at 98.2 2. Record the bond interest expense on June 30, 2014 for each of the above scenarios. 3. Record the retirement of the Benjamin Lid. bonds on December 31, 2023.D G A B C E F General Journal Page Debit Credit Date Particulars 1a) face value VOUAWN Jan 9 b) 10 11 12 13 14 15 c) 16 17 18 19 20 21 2a) 22 23 24 25 26 27 b ) 28 29 30 31 32 33 c) 34 35 36 37 38 39 3 40 41 42 43 44 Sheet1 Sheet2 Sheet3 + Ready