Difference between revisions of "Manuals/calci/cumprinc"

From ZCubes Wiki
Jump to navigation Jump to search
Line 10: Line 10:
 
*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
 
*CUMIPMT shows the ERROR value when
  <math>R\le 0</math>
+
  1. Interest Rate<math>(R)\le 0</math>
  <math>NPPeriods\le 0</math>
+
  2. Payment Periods <math>(PP)\le 0</math>
  <math>PresentValue\le 0</math>
+
  3. Present Value<math>(PV)\le 0</math>
  <math>P\lt 1</math>
+
  4. Start Period<math>(SP)\lt 1</math>
  <math>EP\lt 1</math>
+
  5. End Period<math>(EP)\lt 1</math>
  <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'''
 
  0                 Payment at the end of the period
 
  0                 Payment at the end of the period
 
  1                 Payment at the beginning of the period
 
  1                 Payment at the beginning of the period
 
  
 
==Examples==
 
==Examples==

Revision as of 05:57, 24 February 2014

CUMPRINC(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
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 (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

=CUMPRINC(0.03/12,B3*12,B4,13,24,0)

CUMPRINC returns -11046.6464.

Consider another example

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

CUMPRINC returns -16939.2946.

References