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

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • PANKAJ SINGH
    New Member
    • Jan 2011
    • 1

    #1

    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
Working...