Solve Using Excel (Show Calculations)

On January 1, 2019, BondSeller (BS) issued bonds. The bonds have a total face value of $100,000, a stated interest rate of 10%, and a maturity date of December 31, 2023 (5 years from issuance). Interest is payable on the bonds each December 31. The market rate of interest on similar debt instruments on January 1, 2019 is 7%. 1. Calculate the issue price for the bonds payable 2. Prepare an amortization schedule for the bonds payable 3. Prepare journal entries for a. Issuance b. First interest payment C. Second interest payment