Let's Get Social!
Focal Point    Focal Point Forums    WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] CUMIPMT formula implementation Needed
 Go New Search Notify Tools Reply
 [SOLVED] CUMIPMT formula implementation Needed
Gold member
 posted January 28, 2019 07:39 AM
I need to implement the Excel formula

=CUMIPMT(rate, nper, pv, start_period, end_period, type)

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

 Posts: 53 | Registered: May 09, 2016 IP
Gold member
 posted January 28, 2019 12:03 PM Hide Post
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

 Posts: 74 | Location: UK | Registered: September 17, 2018 IP
Guru
 posted January 28, 2019 12:59 PM Hide Post
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:

see [URL=http://pistulka.com/Other/?p=1678][/URL]

but the person claims that it contains the math behind it.

Fernando

Prod WF 8.1.04, QA WF 8.2.03, Dev WF 8.2.03

 Posts: 277 | Registered: October 10, 2006 IP
Master
 posted January 28, 2019 11:11 PM Hide Post
Something like?...
```-* 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)
-* Note:
-*  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);
END
-*
DEFINE FILE CAR
CUMIPMTS/D12.2 = CUMIPMT(100000, .05, 48, 6, 7, 12);
END
-*
TABLE FILE CAR
"Example of finding Cumulative"
"Interest Paid Between Two Periods"
PRINT CAR
CUMIPMTS
IF RECORDLIMIT EQ 1
ON TABLE SET STYLE *
INCLUDE=jellybean_combo.sty, \$
TYPE = TITLE, JUSTIFY=CENTER,\$
ENDSTYLE
END
```

This message has been edited. Last edited by: David Briars,

 Posts: 808 | Registered: April 23, 2003 IP
Gold member
 posted January 29, 2019 12:38 AM Hide Post
Thanks so much for all.Problem solved with your Help

This message has been edited. Last edited by: Durai,

Webfocus AppStudio 8201
Windows

 Posts: 53 | Registered: May 09, 2016 IP