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

ODFF: YIELDDISC function

From
David King <>
Date
2008-09-06T09:28:26+00:00
ID
48C25B62.17435.11E6821@localhost
Thread
ODFF: YIELDDISC function
"Summary: Calculate the yield of a discounted security per 100 
currency units of face value."

Suggest:
"Summary: Calculate the yield of a discounted non-interest paying 
security."

or "discounted zero coupon bond", or similar - whatever 
description is used elsewhere.

There is a formula and some notes about YEARFRAC (yuk) and non-
compounding here:
http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Ca
lc:_YIELDDISC_function

The internal use of YEARFRAC explains:
"OpenOffice.org 2.0 and Excel returns different results to some 
test cases."

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