$\backslash$table$[[,$A$,$B$,$C$,$D$,$E$,$G$,$H$],[1,$Name:,victoria mireles,Your score this tab:,$0\%,,,]]$

$2$

$3$

The victoria mireles Company issues $5\%,3-$year bonds with a par value of $$610,000$ and semiannual interest payments. On the issue date, the annual market rate for these bonds is $6\%.$ 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$[[$$$610,000$