NPER(Rate, PMT, Pv, Fv, Type) calculates the number of periods required to pay off a loan for a constant periodic payment and a constant interest rate.I Found this formula in Excel and need to implement this in Webfocus.Pls any one help me to solve this?This message has been edited. Last edited by: Durai,
SET PAGE = OFF
DEFINE FUNCTION NPER (P/D12.2, F/D12.2, PMT/D12.2, R/D12.2, T/I1)
-* Note:
-* LOG((-R*F+PMT*(1+Rate*Type))/(Rate*Pv+PMT*(1+Rate*Type)))/LOG(1+Rate)
-* Input Parms:
-* Present Value = P
-* Future Value = F
-* Payment =PMT
-* Interest = R
-* Type =T
NPER/D12.2 = LOG((-R*F+PMT*(1+R*T)) / (R * P+PMT*(1+R*T)))/LOG(1+R);
END
-*
DEFINE FILE CAR
PERIODS/D12.2 = NPER(-10487,4000,300,.0040,0);
END
-*
TABLE FILE CAR
"Example of NPER"
"Number of Periods"
PRINT
PERIODS
BY COUNTRY
ON TABLE SET STYLE *
ENDSTYLE
END
This message has been edited. Last edited by: BabakNYC,
WebFOCUS 8206, Unix, Windows
July 16, 2019, 06:25 AM
Durai
Thank you so much BabakNYC. I solved my problem with your Help