The following list shows a few US Treasury Bills with their maturity dates and yields.

Please pick any one of these US Treasury Bills and show how its yield to maturity (YTM) is calculated.

Please use a spreadsheet to show your calculations.

Issue Description CUSIP Coupon Maturity Benchmark Price YTW YTM Treasury Bill 0.081 0.081 UNITED STATES TREAS BILLS CUSIP: 9127964M8 0.000 99.959 03-11-2021 Treasury Bill 0.077 0.077 UNITED STATES TREAS BILLS CUSIP: 9127962Q1 0.000 99.952 04-22-2021 Treasury Bill 0.071 0.071 UNITED STATES TREAS BILLS CUSIP: 912796284 0.000 99.950 05-20-2021 Treasury Bill 0.085 0.085 UNITED STATES TREAS BILLS CUSIP: 9127963HO 0.000 99.934 06-17-2021 Double Old 12 Month 0.095 0.095 UNITED STATES TREAS BILLS CUSIP: 912796356 0.000 99.919 07-15-2021 Old 12 Month 0.093 0.093 UNITED STATES TREAS BILLS CUSIP: 9127964B2 0.000 99.913 08-12-2021 12 Month 0.098 0.098 UNITED STATES TREAS BILLS CUSIP: 9127964LO 0.000 99.901 09-09-2021