[SOLVED] CUMIPMT formula implementation Needed

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

Addy

Gold member

posted

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

Ignored post by Addy posted

Show Post

Fernando

Guru

posted

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: 278 | Registered: October 10, 2006

Ignored post by Fernando posted

Show Post

David Briars

Master

posted

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