that returns the cumulative interest paid on a loan between a start period and an end period in webfocus. Please help to solve this problem.i tried in many ways but no luck.This message has been edited. Last edited by: FP Mod Chuck,
Webfocus AppStudio 8201 Windows
January 28, 2019, 12:03 PM
Hi, Could you provide a sample code of what you are trying to do.
WF 8.2.04 Windows/Unix All Formats In Focus since 2006
January 28, 2019, 12:59 PM
Durai, What you need to do is find out what the math is behind the CUMIPMT and implement that.
I have not looked at this in detail:
but the person claims that it contains the math behind it.
Prod WF 8.1.04, QA WF 8.2.03, Dev WF 8.2.03
January 28, 2019, 11:11 PM
-* File ExcelFunctionCUMIPMT.fex
SET PAGE = OFF
DEFINE FUNCTION CUMIPMT (P/D12.2, I/D12.2, N/D12.2, B/D12.2, E/D12.2, Q/D12.2)
-* Formulas from - https://www.wikihow.com/Calculate-Loan-Payments
-* - http://pistulka.com/Other/?p=1678
-* Input Parms:
-* Start Balance = P
-* APR = I
-* Cash Flows (Payments) = N
-* Payment Start = B
-* Payment End = E
-* Payments Per Year = Q
-* Step 1: Calculate the Payment.
M/D12.2 = P * ( (I/Q) / (1 - (1 + (I/Q))**-N));
-* Step 2: Calculate the Cumulative Interest Paid Between Two Periods.
CUMIPMT/D12.2 = (((P-M*Q/I)*(1+(I/Q))**(B-1)+M*Q/I)-((P-M*Q/I)*(1+(I/Q))**E+M*Q/I))-M*(E-B+1);
DEFINE FILE CAR
CUMIPMTS/D12.2 = CUMIPMT(100000, .05, 48, 6, 7, 12);
TABLE FILE CAR
"Example of finding Cumulative"
"Interest Paid Between Two Periods"
IF RECORDLIMIT EQ 1
ON TABLE SET STYLE *
TYPE = TITLE, JUSTIFY=CENTER,$