You just started work at a wealth management firm and your boss asks you to evaluate a 30-year bond with a face value of $1,000 that, according to the prospectus, you can purchase next month (01-June-2016) when it is initially issued. The bond is designed to provide a 6.5% yield-tomarket (YTM) and makes annual 01 June coupon payments. Your plan is purchase the bond for face value (par) at issuance. A. What is the coupon (interest rate) attached to this bond? B. If the YTM is expected to remain constant, what is the minimum price you would accept to sell the bond on May 31, 2023, the day before you receive the 7th coupon payment? (Show your work by solving without the “PRICE” function first, then check with the function if you want.) ? C. What is the duration on June 2, 2023, two days after the sale (i.e., the new buyer has already received the June 1, 2023 coupon payment)? (Show your work by solving using the stream of cash inflows—without the “DURATION” function. You can then check with the function if you want.)? D. What is the modified duration at that same time?