The following data shows the YTM for a 1-year US Treasury Bill, a 5-yr T-note and a 30 -yr Treasure bond, depending on which month you purchase the bond in the last year. Download this spreadsheet below then answer the following questions. 1. If the face value of each bond is $100, what is the price paid each month for each 1-year T-bill? each 5-yr T-note? Each 30 -yr Treasury bond? Calculate the price for each bond for each month. 2. Using the Price you generate in (1) as well as the time to maturity and FV given (\$100), calculate the YTM for each bond for each month. Check your calculation with the reported YTM. The following data shows the YTM for a 1-year US Treasury Bill, a 5-yr T-note and a 30 -yr Treasure bond, depending on which month you purchase the bond in the last year. Download this spreadsheet below then answer the following questions. 1. If the face value of each bond is $100, what is the price paid each month for each 1-year T-bill? each 5-yr T-note? Each 30 -yr Treasury bond? Calculate the price for each bond for each month. 2. Using the Price you generate in (1) as well as the time to maturity and FV given (\$100), calculate the YTM for each bond for each month. Check your calculation with the reported YTM