also create an amortization table using excel showing the steps. Thank you. (my ending carrying value amount matches my face value, but somehow my table is off)

On June 30,2020 , Novak Company issued $4,880,000 face value of 13%,20-year bonds at $5,247,120, a yield of 12%. Novak uses the effective-interest method to amortize bond premium or discount. The bonds pay semiannual interest on June 30 and December 31. The issuance of the bonds on June 30,2020 . The payment of interest and the amortization of the premium on December 31,2C The payment of interest and the amortization of the premium on June.30, 2021. The payment of interest and the amortization of the premium on December 31,2C