OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.

# office-comment message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]

Subject: Re: [office-comment] ODFF: XIRR

• From: Sheldon Britton <sab_orion@verizon.net>
• To: David King <openoffice@drking.plus.com>
• Date: Sat, 06 Sep 2008 17:19:14 -0400

```Re: "The last function I am reviewing... "

So then, will there not be consideration of the "/*Economic Rate of
Return*/" (/*ERR*/) /*Function*/ that is required during
"/*international project considerations*/"; (for example: when
converting from IRR (values) to ERR (values)); hence, an continuing and
inherent limitation of Calc (also Excel).

Best regards,

Sheldon A. Britton

David King wrote:
> The last function I am reviewing...
>
> 1. "The first cash-flow amount is a negative number that represents the
> investment."
>
> Not true - it might be a loan (positive). Better to say something like
> "the first given cash flow has the earliest date".
>
> 2. "The later cash flows are discounted based on the annual discount
> rate and the timing of the flow."
>
> Discount rate here is the same as the rate returned by XIRR - it would
> be better not to introduce different terminology.
>
> 3. "The range of Values and Dates must be the same size."
>
> Do they need to be the same shape? (I actually don't know...)
>
> 4. Needs to say something about how it is the an iteration and what
> equation it uses (PVs sum to zero). The Calc wiki help pages may oblige
> here.
>
> 5. Needs to set realistic error limits, as it is an iteration.
>
>
> D
>
>
>
>
>
>

```

• References:
• ODFF: XIRR
• From: "David King" <openoffice@drking.plus.com>

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]