Re: [office-comment] ODFF: XIRR

[Sheldon Britton <sab_orion@verizon.net>]

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
>
>
>
>
>
>