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