The Amya Jeter Company issues 5%, 3-year bonds with a par value of $400,000 and semiannual interest payments. On the issue date, the anual 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 What is the amount of each semannual interest payment? Average score both tabs: The Amya Jeter Company issues 6%, 3-year bonds with a par value of $350,000 and semannual interest payments. On the issue date, the annual market rate for these bonds is 5%. 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? Comolete the amortization schedule for these bonds Make sure all formulas return oositive values