Please show all your work. This is my last chance to post a question. Please help me. Thank you so much in advance. I'll give you an upvote.

2 Instructions: 3 4 1) Complete the requirements shown below for each of the two bond issue scenarios. (For all $ amount calculations, Round to the nearest dollar amount) 5 6 7 a) Calculate the bond selling price using TVM tables, formulas, financial calculator or EXCEL You must show your calculations, based on the valuation method your group chose. 8 9 10 b) Complete the Bond Amortization Schedules using EXCEL. (Use the Effective Interest Method to amortize the bond premium or discount) 12 13 c) Record the journal entries from the bond issue through maturity, 14 (It would not be hard to extract data from the amortization table to your journal entries) 15 16 17 18 19 20 21 22 23 24 25 26 27 page 1 28 29 30 31 Bond Issue Scenario 1: On 1/1/2019 Big Sky Inc., issued $25,000,000, 6%, 3-year bonds, due 12/31/2021. The 3% semi-annual coupon payments are paid on June 30th & Dec 31st. At the time of issue, the stated market rate for similar bond issues was 8%, (i.e., 4% semi-annual.) a) Calculate the issue price (present value) of the bond proceeds. (round to nearest dollar). (Show and label your work). TI b) Complete the bond amortization table below. (use EXCEL & round to the nearest dollar) c) Prepare the accounting journal entries for the bond issue on the Journal Entry Sheet. Bond 15 Unamortized Cash Payment Interest Expense Carrying Value 20 Date Bond Par (Maturity) Value Amortization 21 22 01/01/19 06/30/19 12/31/19 06/30/20 12/31/20 06/30/21 12/31/21 page 2 3 40 1 Bond Scenario #1 Journal Entries: Required Complete the 3 transactions for 2019 only, not for the whole duration. 2 3 4 Date Account Titles Debit Credit 5 6 7 8 19 10 11 2 13 14 15 16 7 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 7 38 page 3 39 TO