[OFFICE-1099] Public Comment: ODFF: RECEIVED function - OASIS Technical Committees Issue Tracker

XML

Word

Printable

Proposal:

Hide

Replace:

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

with

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

For semantics, replace current sentence and formula with:

"The return value is: Investment/(1-Discount * YEARFRAC(Settlement; Maturity; Basis))"

Also, replace "Basis: the type which indicates how the year is to be calculated by days; see section 3.11.6"

with

"Basis: the day count basis used in this calculation; see section 3.11.6

Show
Replace: "Summary: Calculate the amount received at maturity for a fixed interest security per 100 currency units of face value." with "Summary: Calculates the amount received at maturity for a zero coupon bond." For semantics, replace current sentence and formula with: "The return value is: Investment/(1-Discount * YEARFRAC(Settlement; Maturity; Basis))" Also, replace "Basis: the type which indicates how the year is to be calculated by days; see section 3.11.6" with "Basis: the day count basis used in this calculation; see section 3.11.6
Resolution:

Hide

Did so. Also added a reference to YEARFRAC.

Show
Did so. Also added a reference to YEARFRAC.

Copied from office-comment list

Original author: "David King" <openoffice@drking.plus.com>
Original date: 4 Sep 2008 21:56:39 -0000
Original URL: http://lists.oasis-open.org/archives/office-comment/200809/msg00004.html