Focal Point

[Solved] NPER Excel formula Implementation Needed

This topic can be found at:

http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/7327024196

http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/7327024196

July 15, 2019, 06:36 AM

[Solved] NPER Excel formula Implementation Needed

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?Webfocus AppStudio 8201

Windows

July 15, 2019, 07:40 AM

http://forums.informationbuild...417070196#3417070196

That's how I came up with the code below which calculates Periods in a function using the formula from this site: https://help.anaplan.com/anape...ctions/All/NPER.html.

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

WebFOCUS 8206, Unix, Windows

July 16, 2019, 06:25 AM

Webfocus AppStudio 8201

Windows