Q3\4

Use the following Information to answer QUESTIONS 1 - 6. You observe a six month treasury bill is yielding 2.40% and a two year treasury note has coupon of 4.20%. Assume all coupon paying bonds are trading at a par of 100 and pay semi-annually. Year (Period) Yield to maturity (%) Spot Rate (%) 0.5 (1) 2.4% 1.0 (2) A 1.5 (3) B E 2.0 (4) 4.20% 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, if the answer is 3.6789% then enter 3.68) Question 4 1 pts What is the value of cell D? (Round to 4 decimal places and do not include the percentage sign. For example, if the answer is 3.67892% then enter 3.6789) Use the following Information to answer QUESTIONS 1 - 6. You observe a six month treasury bill is yielding 2.40% and a two year treasury note has coupon of 4.20%. Assume all coupon paying bonds are trading at a par of 100 and pay semi-annually. Year (Period) Yield to maturity (%) Spot Rate (%) 0.5 (1) 2.4% 1.0 (2) A 1.5 (3) B E 2.0 (4) 4.20% 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, if the answer is 3.6789% then enter 3.68) Question 4 1 pts What is the value of cell D? (Round to 4 decimal places and do not include the percentage sign. For example, if the answer is 3.67892% then enter 3.6789)