On July 1, 2021, Reddington Company issued bonds paying interest semiannually on June 30 and December 31 of each year at a coupon rate of 8%. At the issuance date, the market demands a 7% rate of return for bonds from a company with Reddington's creditworthiness and similar maturity. The bonds mature in 40 years on June 30, 2061, in the amount of $100,000,000.

Required: Prepare a bond amortization schedule on excel in good form for these bonds using appropriate excel formulas.

*Please make one work sheet with the amortization schedule and one showing the formulas