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 4.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,744.71.

Part a. What is the semi-annual coupon payment?

Part b. What are the accrued interest and invoice price?

Part c. Use XIRR to calculate the annualized yield to maturity (YTM).

Part d. Use YIELD function to calculate the YTM.

Part e. Calculate the annualized rate using the "YTM with the YIELD function"

a. b. Computing the accrued interest Current date Previous interest payment date Next interest payment date Semi-annual coupon Days since last coupon date Days between last coupon date and next coupon date Accrued interest Computing the YTM Bond price Accrued interest Invoice price (bond price + accrued) 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 C. YTM Using XIRR function d. YTM using YIELD function e. Excel's Yiield annualized 20-Feb-2015 15-Oct-2014 15-Apr-2015 Bond cash flow