On August 15, 2000, the Canadian Government issued a bond maturing on February 15, 2030. The bond has a coupon rate of 8.25%, payable semi annually on 15 February and 15 August. If, on June 18, 2015 a $ 100 face value bond is selling for $115.00, what is the bonds yield to maturity using the following Excel functions. Show the detailed cash flow calculations (2 marks)

1. XIRR
2. Yield

Show the calculation that will reconcile the difference in the YTM calculation between XIRR and Yield