Please help me with the excel formuals. All yellow boxes need a formula

The issues 5%, 3-year bonds with a par value of $400 000 and semiannua 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 $400,000 3 6% ndhat is the amount of each semiannual interest payment? How of SIO 000 wi_ll be totar Com lete the amortization schedule for these bonds. Semiannual Cash Interest Bond Interest Unamortized Discount $10,000 Carrying Value Interest Period 3 4 Totals pal d smoo Expense so_oo Discount Amortization so_oo