3. In carly July 2019, the U.S. Treasury issued three T-Bills, and they had issued a one-year T-Bill on June 20, 2019: Issue Date Maturity Date Face Value per $100 Price per $100 4-Week 7/9/2019 8/6/2019 100 13-Week 26-Week 52-Week 7/5/2019 7/5/2019 6/20/2016 10/3/2019 1/2/2020 6/18/2020 100 100 100 99.463750 98.796778 97.992944 99.828111 Calculate the bank discount rate for each security using the formula given in the chapter and using the Disc function. b. Calculate the bond equivalent yield for each security using the formula given in the chapter and using the YIELDDisc function. c. Find the most recent T-Bill auction results from: https://www.treasurydirect.gov /instit/annceresultannceresult.htm. You will need to click the CUSIP numbers to get the auction prices. Repeat parts a and b. Issue Date Maturity Date Redemption Value Auction Price 4-Week 7/9/2019 8/6/2019 100.0000 99.828111 13-Week 7/5/2019 10/3/2019 100.0000 99.463750 26-Week 52-Week 7/5/2019 6/20/2019 1/2/2020 6/18/2020 100.0000 100.0000 98.796778 97.992944 Discount Rate Book Formula Disc Function Bond Equivalent Book Formula Yield Disc Function 3. In carly July 2019, the U.S. Treasury issued three T-Bills, and they had issued a one-year T-Bill on June 20, 2019: Issue Date Maturity Date Face Value per $100 Price per $100 4-Week 7/9/2019 8/6/2019 100 13-Week 26-Week 52-Week 7/5/2019 7/5/2019 6/20/2016 10/3/2019 1/2/2020 6/18/2020 100 100 100 99.463750 98.796778 97.992944 99.828111 Calculate the bank discount rate for each security using the formula given in the chapter and using the Disc function. b. Calculate the bond equivalent yield for each security using the formula given in the chapter and using the YIELDDisc function. c. Find the most recent T-Bill auction results from: https://www.treasurydirect.gov /instit/annceresultannceresult.htm. You will need to click the CUSIP numbers to get the auction prices. Repeat parts a and b. Issue Date Maturity Date Redemption Value Auction Price 4-Week 7/9/2019 8/6/2019 100.0000 99.828111 13-Week 7/5/2019 10/3/2019 100.0000 99.463750 26-Week 52-Week 7/5/2019 6/20/2019 1/2/2020 6/18/2020 100.0000 100.0000 98.796778 97.992944 Discount Rate Book Formula Disc Function Bond Equivalent Book Formula Yield Disc Function