question1-6please

Use the following information to answer QUESTIONS 1.6. You observe a month treasury bill is yielding 2.40% and a two year treasury note has coupon of 420. Assume all coupon paying bonds are trading at a par of 100 and pay sen Annually Year (Period) Yield to maturity (%) Spot Rate 05 (1) 2.4% 1.0 (2) A D 15 (3) B E 2.0 (4) 4,20% Question 1 1 pts Answer with interpolated values what is tse value of cell A? Round to decimal places and Balodude the percentare sign. For example, if the answer is 3.6789% then enter 3681 Question 2 1 pts Using Intolation, what is the value of cell B? (Round to 2 decimal places and do not include the percent For example the answer is 3.6789% then enter 3681 Question 3 1 pts What is the value of cell C? (Round to 2 decimal places and do not include the percentage sign. For example, the answers 36789x then enter 3.68) Question 4 1 What is the value of cell D Round to 4 decimal places and do not indude the poorele the answer 3.67892k then enter 3.6789 Question 5 What is the value of cell E? (Round to 4 decimal places and do not include the percentag. For example, the answer is 3.67892% then enter 3.6789 Question 6 1 Assume the value for AH318-37%, CH2.4%D83.1054% 3.7156% What is the price of 5% treasury note that matures in one year with par value of 100? (Round to 4 decimal places and do not include the dollarslan, For example of the price is 08.56789 enter 98.5679)