Today is 1 January 2019. Lucy is planning to purchase a 10-year 4.15% p.a. Treasury bond with a face value of $100. The maturity date of the treasury bond is 1 January 2029. The bond is redeemable at par. (25 marks)

• Use Goal Seek to find Lucy’s yield to maturity (express your answer as a j2), if the purchase price is $96.5.

• Use Goal Seek to find Lucy’s net yield to maturity, that is after tax rate, (express your answer as a j2), if the purchase price is $95.5. Given that Lucy needs to pay 30% tax on coupon payment (interest payment) only.

• Use Goal Seek to find Lucy’s net yield to maturity, that is after tax rate, (express your answer as a j2), if the purchase price is $94.5. Given that Lucy needs to pay 30% tax on coupon payment (interest payment) and capital gain.