Difference between revisions of "Manuals/calci/cumipmt"

From ZCubes Wiki
Jump to navigation Jump to search
Line 22: Line 22:
  
 
==Examples==
 
==Examples==
=CUMIPMT(0.03/12,B3*12,B4,13,24,0)
 
  
CUMIPMT returns -5527.3132.
+
=CUMIPMT(0.03/12,12*12,12000,13,24,0)
 
+
-322.8066039
Consider another example
 
  
 
=CUMIPMT(0.02/12,10*12,200000,10,20,1)
 
=CUMIPMT(0.02/12,10*12,200000,10,20,1)
CUMIPMT returns -3269.9831.
+
-3269.9831.
  
 
==References==
 
==References==

Revision as of 04:57, 24 February 2014

CUMIPMT(R, NPPeriods, PValue, SP, EP, Type)


  • is the interest rate.
  • is the total number of payment periods.
  •  is the present value.
  •  is the Start period beginning with 1.
  •  is the End period.
  •  is the timing of the payment.

Description

  • This function gives the cumulative interest paid on a loan between and .
  • CUMIPMT shows the ERROR value when
1. Interest Rate
2. Payment Periods 
3. Present Value
4. Start PeriodFailed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle (SP)\lt 1}

5. End PeriodFailed to parse (unknown function "\lt"): {\displaystyle (EP)\lt 1}

6. Failed to parse (unknown function "\gt"): {\displaystyle SP \gt EP}

  • should be 0 or 1.
TYPE             TIMIING
0                 Payment at the end of the period
1                 Payment at the beginning of the period

Examples

=CUMIPMT(0.03/12,12*12,12000,13,24,0)

-322.8066039

=CUMIPMT(0.02/12,10*12,200000,10,20,1)

-3269.9831.

References