pls help calculate interest expense on June 30 (at the straight-line rate) by excel function

The Kennedy Company issued 5.0% bonds, dated January 1 , with a face amount of $16,000,000 on January 1,2023. The bonds mature on December 31, 2032 (10 years). For bonds of similar risk and maturity, the market yield is 6.5%. Interest is paid semiannually on June 30 and December 31 . Kennedy uses the straight-line method