B
bill
Excel's help wrote:
TBILLEQ is calculated as TBILLEQ = (365 x rate)/(360-(rate
x DSM)), where DSM is the number of days between
settlement and maturity computed according to the 360 days
per year basis.
but when I calculate :
=TBILLEQ("2003/1/1","2003/10/20",1) in excel 2000
got the result: 3.311507142
that is to say dsm=249.7782839
who can help me for how dsm is calculate?
thanks very much!
TBILLEQ is calculated as TBILLEQ = (365 x rate)/(360-(rate
x DSM)), where DSM is the number of days between
settlement and maturity computed according to the 360 days
per year basis.
but when I calculate :
=TBILLEQ("2003/1/1","2003/10/20",1) in excel 2000
got the result: 3.311507142
that is to say dsm=249.7782839
who can help me for how dsm is calculate?
thanks very much!