Suppose that General Motors Acceptance Corporation issued a bond with 10 years until maturity, a face value of $1,000, and a coupon rate of 7% (annual payments). The yield to maturity on this bond when it was issued was 6%. Assuming the yield to maturity remains constant, what is the price of the bond immediately after it makes its first coupon payment? $ Maturity (years) Face value Coupon rate Yield to maturity 10 1,000 7% Coupon Remaining Maturity (ycars) Bond price + Requirements 1 In cell D11, by using cell references, calculate the coupon payment of the bond (1 pt.). 2 In cell D12, by using cell references, calculate the number of periods left on the bond (1 pt.). 3 In cell D13, by using cell references, calculate the price of the bond (1 pt.). Note: The output of the expression or function you typed in this cell is expected as a positive number