can someone solve it please with cell referencing

On January 1, 2021, Blossom Satellites issued $1,680,000, 10-year bonds. The bonds pay semi-annual interest on July 1 and January 1, and Blossom has a December 31 year end. A partial bond amortization schedule is presented below: Interest Payment Interest Expense Amortization Semi-Annual Interest Period Jan. 1,2021 July 1, 2021 Jan. 1,2022 July 1, 2022 Jan. 1.2023 July 1, 2023 Jan, 1, 2024 $(1) 50,400 50,400 50,400 50,400 50,400 $(2) 54.769 54.922 55,081 55,244 55,414 $4.222 4,369 (3) [4] 4,844 5,014 Bond Amortized Cost $1,560,616 1.564,838 1,569.207 1,573,729 [5] 1,583,254 1,588,268 A B D 15 a) Were the bonds issued at a premium or a discount? 16 17 b) What is the face value of the bonds? 18 19 c) What is the contractual rate of interest? 20 21 d) Calculate the missing amounts for items (1) through (5) 22 23 24 item [1] item [2] item [3] item [4] item [5] 25 26 27 28 e) What was the market interest rate when the bonds were issued? 29 30 f) Record the accrual of interest on December 31, 2021 31 Date Account title Debit Credit