D 1 2 3 4 15 16 17 18 19 20 21 2242NER 23 25 26 27 28 Name: 29 The Clay Peterson 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 Clay Peterson 0 1 3 4 5 6 What is the amount of each semiannual interest payment? $420,000 Complete the amortization schedule for these bonds. Semiannual Cash Interest Paid Bond Interest Expense Interest Period Instructions Bond 1 Bond 2 5 + 8% 7% 2 Your score this tab: Discount Amortization + 0% Unamortized Discount Carrying Value