Use the latest daily yield curve rate from US Department of Treasury to price a 10-year bond with $1000 face value, 6% coupon rate, semi-annual payment. Then with the price, calculate the bond YTM.
Please upload screenshots of step by step on how to build this using Excel,