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


Help: OASIS Mailing Lists Help | MarkMail Help

office-comment message

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

Subject: ODFF: XIRR

The last function I am reviewing...

1. "The first cash-flow amount is a negative number that represents the 

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 

5. Needs to set realistic error limits, as it is an iteration.


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