Instructions: must be in Excel using formulas.

Bond interest and discount amortization.

BU Curriculum Corporation issued $900,000 of 7% bonds on October 1, 2016, due on October 1, 2021. The interest is to be paid twice a year on April 1 and October 1. The bonds were sold to yield 9% effective annual interest.BU Curriculum Corporation closes its books annually on December 31.

Instructions

(a) show an amortization schedule for the above bond (for all periods) in a similar format as below.(Round all answers to the nearest dollar.)Use the effective-interest method.