

Go  New  Search  Notify  Tools  Reply 
Gold member 
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  

Gold member 
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  

Guru 
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  

Master 
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/CalculateLoanPayments *  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 = (((PM*Q/I)*(1+(I/Q))**(B1)+M*Q/I)((PM*Q/I)*(1+(I/Q))**E+M*Q/I))M*(EB+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,  

Gold member 
Thanks so much for all.Problem solved with your HelpThis message has been edited. Last edited by: Durai, Webfocus AppStudio 8201 Windows  

Powered by Social Strata 
Please Wait. Your request is being processed... 