← Prev in month ← Prev in thread
Next in thread → Next in month →

ODFF: RECEIVED function

From
David King <>
Date
2008-09-04T21:56:39+00:00
ID
48C067BC.22231.11ACE8F@localhost
Thread
ODFF: RECEIVED function
ODFF 28Jun08:

RECEIVED

"Summary: Calculate the amount received at maturity for a fixed interest 
security per 100 currency units of face value."

Revised suggestion:
"Summary: Calculates the amount received at maturity for a zero coupon 
bond."

(The function returns the actual amount received (not per 100). It looks 
as if the formula takes no account of any interest / coupons paid, 
merely the discount at which it is sold.)

In addition, I think we need to indicate more clearly that the days 
difference is subject to the usual rules of 'basis', and to have 
specified somewhere how the year length is calculated. For example in 
basis 1 Calc just takes the length of the year containing the settlement 
date - which is different to Excel for 15Sep08 (settlement) to 15Mar09 
(maturity) (366 vs 365).

D
← Prev in month ← Prev in thread
Next in thread → Next in month →