1. On August 17, 2022, the United States Treasury issued four Securities issuances:

	28 that	91 that	182 that	364 that
Issue date	8/17/2022	8/17/2022	8/17/2022	8/17/2022
Due date	9/14/2022	11/14/2022	2/15/2023	8/16/2023
Nominal value per $100	100	100	100	100
Price per $100	99.992222	99.962083	99.575333	98.948444

1. In another spreadsheet within your Excel worksheet:
   1. Calculate the bank discount rate for each security using the formulas learned in the module and using the Disc function .
   2. Calculate the equivalent yield of a bond for each security, using the formulas learned in the YieldDisc module and function .