please include excel formulas in response and i will upvote

Computing the accrued interest Current date Previous interest payment date Next interest payment date Semi-annual coupon 20-Feb-2015 15-Oct-2014 15-Apr-2015 a. Days since last coupon date Days between last coupon date and next coupon date Accrued interest 09 2 3 b. 4. 5 16 17 18 19 20 21 22 23 24 25 Computing the YTM Bond price Accrued interest Invoice price (bond price + accrued) Bond cash flow 26 Date 20-Feb-2015 15-Apr-2015 15-Oct-2015 15-Apr-2016 15-Oct-2016 15-Apr-2017 15-Oct-2017 15-Apr-2018 15-Oct-2018 15-Apr-2019 15-Oct-2019 15-Apr-2020 15-Oct-2020 27 28 29 30 31 32 33 34 35 c. 36 d. YTM Using XIRR function YTM using YIELD function Excel's Ylield annualized 37 e. 38 39 TREASURY BOND VALUATION On Feb. 20, 2015, you are offered a US Treasury note. Here are the terms of the note: - The note has face value of $100,000 and 6.5% coupon rate. The note matures on Oct. 15, 2020 -- The semi-annual interest on the note is paid on April 15 and Oct 15 of each year. The last interest payment was Oct. 15, 2014, and the next interest payments are on Apr 15, 2015 and Oct 15, 2015. - On the last date, the bond's principal of $100,000 is also returned. -- On Feb. 20, 2015, the bond was priced at $109,477.71. Part a. What is the semi-annual coupon payment? Part b. What is the accrued interest? Part c. Use XIRR to calculate the annualized yield to maturity (YTM). Part d. Use YIELD function to calculate the YTM. Is there a difference between the two YTMs and why? Part e. Calculate the annualized rate using the YTM with the YIELD function