Can someone please help me solve this with formulas, I tried to understand but i dont get it.

The Company issues 7%,5-year bonds with a par value of $420,000 and semiannual interest payments. On the issue date, the annual market rate for these bonds is 8%. Enter a valid Excel formula or function in each of the yellow cells below. Formulas must refer to cells addresses. Entering a value will be marked as incorrect. Your formula is incorrect. What is the amount of each semiannual interest payment? Complete the amortization schedule for these bonds