엑셀 썸네일형 리스트형 java 엑셀 함수 NPV 구현 public static double npv(double[] arrVal, double r){double npvVal = 0;for(int i=0;i 더보기 java 엑셀 함수 IRR 구현 public static int irr(double[] arr){double irrVal = 0.0;// 수익율double r = 0.1;while(true){//f(x)double f1 = 0;//f'(x)double f2 = 0;for(int i=0;i= 2){f2 += (arr[i]/Math.pow(1+r, i));}}// rdouble x1 = r - f1/f2;irrVal = x1;if((x1 - r) < 0.000001)break;r = x1;}System.out.println("IRR : " + irrVal);return (int)(irrVal * 100);} 더보기 이전 1 다음