Please show the steps and if solved in Excel please show formulas.

Thanks!

(1pt.) See below the U.S. Treasury Quotes (T-bills) as of Friday, September 23, 2022, from the Wall Street Journal website. Calculate the prices of the government securities we can purchase (for both 9/27, and 9/29 maturities / Assume that the face value of the T-bill is \$100). Explain how the asked yields (2.386 and 2.218) are calculated. The asked yield you calculated could be different from the quotes. Round the price to the nearest dollar amount and calculate the asked yield again. Calculate their effective annual yields. (1pt.) See below the U.S. Treasury Quotes (T-bills) as of Friday, September 23, 2022, from the Wall Street Journal website. Calculate the prices of the government securities we can purchase (for both 9/27, and 9/29 maturities / Assume that the face value of the T-bill is \$100). Explain how the asked yields (2.386 and 2.218) are calculated. The asked yield you calculated could be different from the quotes. Round the price to the nearest dollar amount and calculate the asked yield again. Calculate their effective annual yields