Excel IRR formula in javasript

Question

public static async IRRCalc(CArray: string | any[], guest: number) {    
        const inc = 0.000001;
        let NPV;
        do {
          guest += inc;
          NPV = 0;
          for (let j = 0; j < CArray.length; j++) {
            NPV += CArray[j] / Math.pow(1 + guest, j);
          }
        } while (NPV > 0);
        console.log('2222222222');
        return guest * 100;
      }

i am using below function IRR calculation by passing my cashflow and guess value 0.001 .i am not getting exact output as my excel is calculated my excel IRR formula is =IRR(G$26:G$386,0.01)*12

my cashflow input is [-150000,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,659.75,1009.75]}

the excel output is 2.36,but why my code is giving 2.336.
can anyone suggest please?

so i have tried changing the floting point numbers like gess value to IRRCalc(IRRval, 0.001)

//to

IRRCalc(IRRval, 0.0001)

inc = 0.000001;

//to

inc = 0.00000001 and followed the example from Javascript IRR (Internal rate of return) Formula Accuracy but no solutions i found to make my output same as exell

Did you check whether the value in Excel is rounded in any way? — Nico Haase, Aug 23 '22 at 08:08
Please do not remove the most important part of your post - the question itself — Nico Haase, Aug 23 '22 at 08:11
no ita not rounded formula in excel is =IRR(G$26:G$386,0.01)*12 — sanjib mohanty, Aug 23 '22 at 08:17
What did you try to resolve the problem? Where are you stuck? — Nico Haase, Aug 23 '22 at 08:21
i am trying to call this function const final = (await this.IRRCalc(repaymentArray, 0.001)) * 12; and tried with adjusting the floating values to 0.001 and inc values also but not getting appropriate as excel output — sanjib mohanty, Aug 23 '22 at 08:39
Please add all clarification to your question by editing it, along with your attempts to resolve the problem — Nico Haase, Aug 23 '22 at 08:40

Excel IRR formula in javasript

0 Answers0