PLEASE USE EXCEL!

7. Valuing semiannual coupon bonds Aa Aa 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 U.S. Treasury note with two years to maturity (YTM) has a coupon rate of 4%. The yield to maturity of the bond is 9.90%. Using this information and ignoring the other costs involved, calculate the value of the Treasury note: $1,074,327.42 $895,272.85 O $760,981.92 O $564,021.90 Based on your calculations and understanding of semiannual coupon bonds, complete the following statement: Assuming that interest rates remain constant, the T-note's price is expected to decrease increase