Re: In IRR period in data flow compared to period in result percentage
From: Norman Harker (njharker_at_optusnet.com.au)
Date: 05/01/04
- Next message: yukon degenhart: "sort distances in feet and inches"
- Previous message: Debra Dalgleish: "Re: Will divide now!"
- In reply to: JCN: "In IRR period in data flow compared to period in result percentage"
- Next in thread: JCN: "Re: In IRR period in data flow compared to period in result percentage"
- Reply: JCN: "Re: In IRR period in data flow compared to period in result percentage"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 2 May 2004 04:07:51 +1000
Hi JCN!
I suspect that your problems lies in:
"with many with blank/zero amounts"
Don't insert blanks in cash flows that you use an IRR or NPV on!!!
If you have blanks instead of zeros, these functions will treat the
next zero / positive / negative flow as occurring immediately after
the last zero / positive / negative flow.
Consider:
-100000
blank
110000
=IRR(A1:A3)
Returns: 10%
-100000
0
110000
=IRR(B1:B3)
Returns: 4.88088481701527%
-- Regards Norman Harker MVP (Excel) Sydney, Australia njharker@optusnet.com.au It is imperative that the patches provided by Microsoft in its April Security Release be applied to Systems as soon as possible. Worms / viruses that exploit vulnerabilities addressed by these patches are now spreading. See: http://www.microsoft.com/security/protect/
- Next message: yukon degenhart: "sort distances in feet and inches"
- Previous message: Debra Dalgleish: "Re: Will divide now!"
- In reply to: JCN: "In IRR period in data flow compared to period in result percentage"
- Next in thread: JCN: "Re: In IRR period in data flow compared to period in result percentage"
- Reply: JCN: "Re: In IRR period in data flow compared to period in result percentage"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
