Please show the equations you used on excel to solve these problems. thank you

1) Assuming a semi-annual interest payment determine both the bond-equivalent and annual effective annual yield (to two significant digits) of a bond whose current price is $972, a coupon rate of 7%, a face value of $1000 and with a maturity of 15 years. (8 points) 2) You would like to have $5 million dollars when you retire at age 65. You are 25 years old and you want to make your first savings payment one month from now. You have already saved $36,000 for your retirement. Assume interest rate is 7%, how much money must you set aside per month until and including your 65th birthday? (10 points)