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

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

January 28, 2019, 07:39 AM

[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.

Webfocus AppStudio 8201

Windows

January 28, 2019, 12:03 PM

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

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

-* 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

January 29, 2019, 12:38 AM

Webfocus AppStudio 8201

Windows