Difference between revisions of "Manuals/calci/cumipmt"

From ZCubes Wiki
Jump to navigation Jump to search
Line 9: Line 9:
 
==Description==
 
==Description==
 
*This function gives the cumulative interest paid on a loan between <math>SP</math> and <math>EP</math>.
 
*This function gives the cumulative interest paid on a loan between <math>SP</math> and <math>EP</math>.
*CUMIPMT shows the ERROR value when <math>R\le 0</math>, <math>NPPeriods\le=0</math>, <math>PresentValue\le 0<math>, or <math>P\lt 1<math>, <math>EP\lt 1<math>, <math>SP \gt EP<math>,
+
*CUMIPMT shows the ERROR value when <math>R\le 0</math>, <math>NPPeriods\le=0</math>, <math>PresentValue\le 0</math>, or <math>P\lt 1</math>, <math>EP\lt 1</math>, <math>SP \gt EP</math>,
 
*<math>Type</math> should be 0 or 1.
 
*<math>Type</math> should be 0 or 1.
 
  '''TYPE'''             '''TIMIING'''
 
  '''TYPE'''             '''TIMIING'''

Revision as of 07:05, 12 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 first period beginning with 1.
  •  is the last 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 , , , or Failed to parse (unknown function "\lt"): {\displaystyle P\lt 1} , Failed to parse (unknown function "\lt"): {\displaystyle EP\lt 1} , Failed 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 \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,B3*12,B4,13,24,0)

CUMIPMT returns -5527.3132.

Consider another example

=CUMIPMT(0.02/12,10*12,200000,10,20,1) CUMIPMT returns -3269.9831.

References