Please show the steps and the calculation formula for Excel.

1. Express your hypothetical age in years and month only (Forget about day, for example if you are 22 years and 5 months and 15 days, then use 22 years and 5 months. If you are 22 years and 6 month and 16 days, then use 23 years and 7 months. Assume an age that have not been chosen by any other students. Assume you buy a zero-coupon bond that matures when you get to retirement age of 67 If your goal is to have $1,000,000.00 when you retire at age 67 and if the yield of this bond is 5% compounded semiannually, how much you must invest today to achieve your goal? Face value of each zero-coupon bond is $10,000 2. Assume your child was born today and you like to have $40,000 for 4 years college expenses at UHV when your child gets to 18-year- old. To implement this strategy, you decide to buy a zero-coupon bond, maturity 18 years, with face value of $40,000 that yields 4.6% semi-annual What is your total investment today to achieve this goal