Can someone help me with this

Clipboard Font Alignment BE21 X Y fx F G H I BC BD A B D Name Ankush Thakur Your score this tab: 14% 2 The Ankush Thakur Company issues 5%, 3-year bonds with a par value of $400,000 and semiannual interest payments. On the issue date, the annual market rate for these bonds is 6%. Enter a valid 3 4 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. 8 Par Value $400,000 9 Term (years) 10 Annual market % 6% 11 Annual contract % 5% 12 Payments per year 13 14 15 What is the amount of each semiannual interest payment? $10,000 16 How many semiannual payments of $10,000 will be made in total? 17 18 19 20 Complete the amortization schedule for these bonds. Semiannual Cash Interest Bond Interest Discount Unamortized Carrying Interest Period Paid Expense Amortization Discount Value 21 22 23 24 25 26 27 28 29 30 Totals $0.00 $0.00 $0.00 34 35 36 37 38 39 Instructions Bond 1 Bond 2 + .Ready