Focal Point
[SOLVED] CUMIPMT formula implementation Needed

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/3417070196

January 28, 2019, 07:39 AM
Durai
[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
January 28, 2019, 12:03 PM
Addy
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
Fernando
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
January 28, 2019, 11:11 PM
David Briars
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,
January 29, 2019, 12:38 AM
Durai
Thanks so much for all.Problem solved with your Help

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


Webfocus AppStudio 8201
Windows