[REBOL] Re: financial functions
From: chalz:earthlink at: 17-Apr-2002 13:27
Heh! Perhaps if I had some idea as to what internal rate of return meant, I could give
you a hand ;)
Perhaps the difference between your function and Excel's function is a matter of rounding?
Since I see no decimals in your comparative values, and they are so close, it almost
seems to suggest that you rounded up, where Excel rounded down No?
Original Message:
-----------------
From: Graham Chiu [gchiu--compkarori--co--nz]
Date: Wed, 17 Apr 2002 23:21:27 +1200
To: [rebol-list--rebol--com]
Subject: [REBOL] financial functions
Does anyone have an internal rate of return function?
something like
irr [ 0 -1073 -1459 -1364 -1247 -1110 31789 ]
= 70.56%
This example is from a book, and Excel says the IRR is 60%
The irr function I wrote says 61%, but it is very messy...
--
Graham Chiu
--
To unsubscribe from this list, please send an email to
[rebol-request--rebol--com] with "unsubscribe" in the
subject, without the quotes.
--------------------------------------------------------------------
mail2web - Check your email from the web at
http://mail2web.com/ .
