Difference between revisions of "Manuals/calci/cumipmt"

 
(9 intermediate revisions by one other user not shown)
Line 1: Line 1:
<div style="font-size:30px">'''CUMIPMT(R, NPPeriods, PValue, SP, EP, Type)'''</div><br/>
+
<div style="font-size:30px">'''CUMIPMT(R,PP,PV,SP,EP,Type)'''</div><br/>
 
*<math>R</math> is the interest rate.
 
*<math>R</math> is the interest rate.
 
*<math>PP</math> is the total number of payment periods.
 
*<math>PP</math> is the total number of payment periods.
Line 13: Line 13:
 
  2. Payment Periods <math>(PP)\le 0</math>
 
  2. Payment Periods <math>(PP)\le 0</math>
 
  3. Present Value<math>(PV)\le 0</math>
 
  3. Present Value<math>(PV)\le 0</math>
  4. First Period<math>(SP)\lt 1</math>
+
  4. Start Period<math>(SP)\lt 1</math>
  5. End Period<math>EP\lt 1</math>
+
  5. End Period<math>(EP)\lt 1</math>
  6. <math>SP \gt EP</math>,
+
  6. <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'''
Line 22: Line 22:
  
 
==Examples==
 
==Examples==
=CUMIPMT(0.03/12,B3*12,B4,13,24,0)
+
=CUMIPMT(0.03/12,12*12,12000,13,24,0)
 +
-322.8066039
 +
=CUMIPMT(0.02/12,10*12,200000,10,20,1)
 +
-3269.9831.
  
CUMIPMT returns -5527.3132.
+
==Related Videos==
  
Consider another example
+
{{#ev:youtube|1jQp96xzkhY|280|center|CUMIPMT}}
  
=CUMIPMT(0.02/12,10*12,200000,10,20,1)
+
==See Also==
CUMIPMT returns -3269.9831.
+
*[[Manuals/calci/cumprinc | CUMPRINC]]
 +
*[[Manuals/calci/couppcd | COUPPCD]]
 +
*[[Manuals/calci/coupncd | COUPNCD]]
  
 
==References==
 
==References==
 +
[https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_CUMIPMT_function CUMIPMT]

Latest revision as of 13:02, 19 July 2015

CUMIPMT(R,PP,PV,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 (unknown function "\lt"): {\displaystyle (SP)\lt 1}

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

6. 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,12*12,12000,13,24,0)

-322.8066039

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

-3269.9831.

Related Videos

CUMIPMT

See Also

References

CUMIPMT