On April 10, 2014, the U.S. Treasury issued three T-Bills, and they had issued a one-year T-Bill on April 3, 2014:

a. Calculate the bank discount rate for each security using the formulas given in the chapter and using the Disc function.
b. Calculate the bond equivalent yield for each security using the formulas given in the chapter and using the YIELDDISC functions.
c. Find the most recent T-Bill auction results from: https://www.treasurydirect.gov/instit/annceresult/annceresult.htm. You will need to click the CUSIP numbers to get the auction prices. Repeat parts a and b.

Transcribed Image Text:

4-Week13-Week 26-Week 52-Week Issue Date Maturity Date Face Value per $100 Price per $100 4/10/20144/10/2014 4/10/2014 4/3/2014 5/8/20147/10/2014 10/9/2014 4/2/2015 100 99.99805699.992417 99.974722 99.873611 100 100 100