473,320 Members | 1,950 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

IRR Calculated by MS Excel is different from VBA Financial.IRR (.Net)

We are using Financial.IRR with .Net 2008 but issue we are facing now is IRR calculted by MS Excel is different from what is returned by .Net code.
For instance for my set of cashflows Excel gives me IRR value whereas .Net code is fails to generate IRR.

Can anyone have solution for this , any idea would be appreciated.
Following is the sample cash flows:

For Guess - -0.69 .nect code fails whereas Excel gives me number

For Guess - -0.38 both gives me same number.

-1300100000
-2094867.86
462482241.3
-523078.94
0
-5230639
-540000000
-4437759273
-1171882896
-7295154860
-1041161101
-3414121070
-2229901910
-54545
-18057046
-24885139
-242488818
-6191000
-807000
0
0
-98699000
-12258000
-8999783
1917599631
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
-100000000
-100000000
200000000
200000000
0
0
0
0
Jan 14 '11 #1
0 802

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Scott Meddows | last post by:
Clive, in Excel 2K they show the formula for calculating Price. You could code your own function, it would be much faster. When you call native code you are taking a preformance hit to call that...
1
by: Dianna K | last post by:
I am opening, reading and extracting an Excel spreadsheet in .Net (VB). It seems to work fine, however, when I am finished and I open up Excel and try to open up the file a message pops up "File Now...
1
by: LP | last post by:
Hi, I need to develop an ASP.NET application that takes report criteria ("filters") input from the user imports data to Excel template, maybe apply additional formatting on Excel and sends...
3
by: Clive | last post by:
Hi, I am developing a app that does soem calculations, rounding etc. Does anyone know if I can use an Excel Library in .Net in order to leverage the functions in MS Excel? Thanks, Clive.
1
by: Brian Conklin | last post by:
Hello Eneryone, I am having a problem. I have written a little app that will take a text "pipe" delimited file and place all of the values in to an Excel spreadsheet. It works great on any of my...
22
by: Howard Kaikow | last post by:
There's a significant problem in automating Excel from VB .NET. Reminds me of a problem I encountered almost 3 years ago that was caused by the Norton Auntie Virus Office plug-in. Can anybody...
4
by: Ivan | last post by:
Hi All, I have tried to automate excel in vb.net and i found a problem that i can't find the solution in anywhere... i hope someone can help me in this group.... the problem is i try using...
3
by: Atley | last post by:
I am trying to create a new spreadsheet in Excel using VB.net 2003. This application has to be useable by a range of users running anywhere from Excel 2000 to Excel XP to Excel 2003. My dev...
6
by: simchajoy2000 | last post by:
Hi, So I do actually know how to read excel into VB.NET using the following approach: With oConn2 .ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=" & FilePath & ";Extended...
10
by: Ben | last post by:
Hi, i have a weird problem and i don't know who is responsible for this: IIS, excel or asp.net. My problem: we use an asp.net 2.0 application under IIS 6.0 (server 2003 sp2) which must write...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.