Suppose you are Investing money in an RESP (Registered Educational Savings Plan) to meet your child's post-secondary schooling expenses. You expect you will have to pay out $20,000 per year for 4 years starting 9 years from now. We will just consider the first year's obligation of $20,000. You have available the three bonds described below:

- A zero canon bond

- A 5% coupon bond

- An 8% coupon bond

Each has a face value of $1,000. They all mature in 10 years, have the same default risk and pay any coupons annually. There are no other special provisions.

a. Calculate the current price and duration of each bond.

b. Calculate the shares of Bonds I and 3 in an optimal immunized portfolio.

Please asnwer using excel, thanks!