The T-note described..... Premium or Discount.

If possible please show work on how to solve part one in excel. Thank you.

Bonds often pay a coupon twice a year. For the valuation of bonds that make semiannual payments, the number of periods doubles, whereas the amount of cash flow decreases by half. Using the values of cash flows and number of periods, the valuation model is adjusted accordingly. Assume that a $1,000,000 par value, semiannual coupon US Treasury note with five years to maturity has a coupon rate of 6%. The yield to maturity (YTM) of the bond is 9.90%. Using this information and ignoring the other costs involved, calculate the value of the Treasury note: $534,907.72$849,059.88$1,018,871.86$721,700.90 Based on your calculations and understanding of semiannual coupon bonds, complete the following statement: The T-note described in this problem is selling at a