Wendy buys a bond with a face value of $100, a time to maturity of three years, a coupon of 6% pa with semi-annual payments and a yield of 3% pa. 12 months later (just before the second coupon is to be paid), the Reserve Bank of Australia unexpectedly increases the cash rate. The yield on Wendy's bond increases to 3.3% pa.

Required

Calculate the buying price, the price 12 months later and explain why the price has changed.

(Accurate to the nearest cent)

Question to be answered using excel