Skip Menu |

This queue is for tickets about the Finance-Math-IRR CPAN distribution.

Report information
The Basics
Id: 49623
Status: new
Priority: 0/
Queue: Finance-Math-IRR
People
Owner: Nobody in particular
Requestors: kcheung [...] adamsstreetpartners.com
Cc:
AdminCc:
Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)
Attachments
test.pl
XIRR_Test.xls

History Show all quoted text
  Fri Sep 11 09:08:38 2009 kcheung [...] adamsstreetpartners.com - Ticket created
Subject: Finance::Math::IRR differ from Excel's XIRR
Date: Fri, 11 Sep 2009 08:07:56 -0500
To: "'bug-Finance-Math-IRR [...] rt.cpan.org'" <bug-Finance-Math-IRR [...] rt.cpan.org>
From: "Cheung, Kam" <kcheung [...] adamsstreetpartners.com>

Message body is not shown because sender requested not to inline it.

Download XIRR_Test.xls
application/vnd.ms-excel 15k

Message body not shown because it is not plain text.

Hello: I am reporting a potential bug with the module, Finance::Math::IRR (version 0.10). I was comparing the XIRR returned by this module with result from Microsoft Excel's XIRR function. In many cases they are the same. However, I found one case in which the XIRR differ significantly. In the attached case I found, the Excel XIRR gives 2.323% but the Finance::Math::IRR module yields 2.961%. I would appreciate hearing any comments you might have. Attached is the perl script and Excel spreadsheet operating on the same data. I ran the perl script on Windows PC (Windows XP operating system) using Active Perl. Thanks. Kam