The Company issues 9%, 3-year bonds with a par value of $580,000 and semiannual interest payments. On the issue date, the annual market rate for these bonds is 10%. 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. What is the amount of each semiannual interest payment? \begin{tabular}{|l} \hline \\ \hline \\ \hline \end{tabular} The Company issues 10%, 3-year bonds with a par value of $530,000 and semiannual interest payments. On the issue date, the annual market rate for these bonds is 9%. 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. What is the amount of each semiannual interest payment