1. Suppose that on January 2, 2019, the U.S. Treasury auctioned the following four T-Bills:

	28-Day	91-Day	182-Day	270-Day
Issue Date	1/2/2019	1/2/2019	1/2/2019	1/2/2019
Maturity Date	1/30/2019	4/3/2019	7/3/2019	9/29/2019
Face Value per $100	100	100	100	100
Price per $100	99.50	98.30	97.00	95.50

a. Determine the bank discount rate for each T-Bill (can use either formula method or DISC function).

b. Determine the bond equivalent yield for each T-Bill (can use either the formula method or the YIELDDISC function).

2. The following T-Bill quotes can be found in the Wall Street Journal.

Settlement date	5/30/2023	5/30/2023	5/30/2023	5/30/2023
Maturity date	6/29/2023	8/1/2023	9/28/2023	12/28/2023
Bid	5.108	5.088	5.038	4.608
Ask	5.098	5.078	5.028	4.598

Calculate the bid price, ask price, and ask yield for each bond on the settlement date. Assume face value is $10,000.

here is the excel sheet to fill

\begin{tabular}{|l|r|r|r|r|} \hline \multicolumn{1}{c|}{ A } & \multicolumn{1}{c|}{C} & \multicolumn{1}{c|}{ C } & \multicolumn{1}{c|}{ E } & \multicolumn{1}{c|}{ F } \\ \cline { 2 - 5 } & \multicolumn{1}{|c|}{ 28-Day } & 91-Day & 182-Day & \multicolumn{1}{c|}{ 270-Day } \\ \hline Issue Date & 1/2/2019 & 1/2/2019 & 1/2/2019 & 1/2/2019 \\ Maturity Date & 1/30/2019 & 4/3/2019 & 7/3/2019 & 9/29/2019 \\ Face Value per $100 & 100 & 100 & 100 & 100 \\ Price per $100 & 99.50 & 98.30 & 97.00 & 95.50 \\ \hline \end{tabular} a Bank Discount Rate b Bond Equivalent Yield