On August 15, 2000, the Canadian Government issued a bond maturing on February 15,2030. The bond has a coupon rate of6.75%, payable semi annually on 15February and 15 August. If, on June 01, 2015 a $ 100 face value bond is selling for$115.00, what is the bond's yield to maturity using the following Excelfunctions. Show the detailed cash flow calculations

1.XIRR

2.Yield

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