Public Comment: ODFF: RRI function

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: Blocker
    • ODF 1.2
    • Affects Version/s: ODF 1.2 Part 2 CD 1
    • Component/s: OpenFormula
    • None
    • Hide

      Change the description of RRI to read:

      5.12.45 RRI
      Summary: Returns the interest rate resulting from the profit (return) of an investment
      Syntax: RRI( Number N ; Number Pv ; Number Fv )
      Returns: Percentage
      Constraints: N > 0
      Semantics: Returns the equivalent interest rate when an investment increases in
      value given N (the number of periods), Pv (present value), and
      Fv (future value), calculated as follows:

      [formula remains unchanged]

      Show
      Change the description of RRI to read: 5.12.45 RRI Summary: Returns the interest rate resulting from the profit (return) of an investment Syntax: RRI( Number N ; Number Pv ; Number Fv ) Returns: Percentage Constraints: N > 0 Semantics: Returns the equivalent interest rate when an investment increases in value given N (the number of periods), Pv (present value), and Fv (future value), calculated as follows: [formula remains unchanged]
    • Hide

      Changed the description of RRI to read:

      Summary: Returns an equivalent interest rate when an investment increases in value.
      [Note: the proposal contained the original text, this is the text proposed in the comment]

      Syntax: RRI( Number N ; Number Pv ; Number Fv )

      Returns: Percentage

      Constraints: N > 0

      Semantics: Returns the equivalent interest rate when an investment increases in value given N (the number of periods), Pv (present value), and
      Fv (future value), calculated as follows:

      Show
      Changed the description of RRI to read: Summary: Returns an equivalent interest rate when an investment increases in value. [Note: the proposal contained the original text, this is the text proposed in the comment] Syntax: RRI( Number N ; Number Pv ; Number Fv ) Returns: Percentage Constraints: N > 0 Semantics: Returns the equivalent interest rate when an investment increases in value given N (the number of periods), Pv (present value), and Fv (future value), calculated as follows:

      Copied from office-comment list

      Original author: "David King" <[email protected]>
      Original date: 7 Sep 2008 16:31:19 -0000
      Original URL: http://lists.oasis-open.org/archives/office-comment/200809/msg00011.html

      1. "Summary: Returns the interest rate resulting from the profit
      (return) of an investment"

      That's more or less copied from Calc Help, and doesn't really
      illuminate. How about:
      "Returns an equivalent interest rate when an investment increases in
      value."

      2. Typo: N and P are both used for number of periods - need one or the
      other.

      3. "N is NOT truncated to an integer" - that's OK, but it might be wise
      to note that for fractional N the result is slightly inaccurate, as a
      partial period does not partially compound.

      4. I wonder if this function should really be included in ODFF? Calc has
      it, but Excel does not. It's a simple formula calculation, and you need
      to understand

            Assignee:
            Andreas Guelzow (Inactive)
            Reporter:
            Robert Weir (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: