The Connor Wagner 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.

Par Value

Term $($years$)$

Annual market $\%$

Annual contract $\%$

Payments per year

$\backslash$table$[[$$$420,000$