1 | settlement | 2/1/2011 | |
---|---|---|---|
2 | maturity | 6/30/2011 | |
3 | price | 99 | |
4 | Result | 0.02440512508 | |
5 | Formula | =TBILLYIELD(B1,B2,B3) | |
6 |
1 | settlement | maturity | discount | Result | Formula | |
---|---|---|---|---|---|---|
2 | 3/31/2008 | 6/1/2009 | 9% | #NUM! | =TBILLYIELD(A2,B2,C2) | |
3 | 3/31/2009 | 6/1/2008 | 9% | #NUM! | =TBILLYIELD(A3,B3,C3) | |
4 | 3/31/2008 | 6/1/2009 | -5% | #NUM! | =TBILLYIELD(A4,B4,C4) | |
5 |