please solve with excel dont answer A and C

An investor purchases a $135 million face amount of a corporate bond with remaining maturity of 28 years for 100.5 (no accrued interest). The coupons 2.50%. The investor can invest cash at 1.0% annum, compounded semi-annually. The investor expects to sell the corporate bond in 1 year when yields are 2.00% (a) What is the dollar amount of the purchase price of the corporate bond? $ 135,675,000.00 (b) What is the yield to maturity at the time of purchase? (c) What is the interest payment each period? How many periods until the bond is sold? $ 1.687,500.00 (d) What is the expected selling price of the bond? (a) What are the proceeds of the sale? What is the future value of the coupon payments and reinvestment eamings at the time of the bond sale? (g) What is the total cash from the bond sale, coupon payments and reinvestment oamings at the time of the bond sale? ch) What is the total annualized rate of retum, based on a semi-annual bond equivalent