Difference between revisions of "Manuals/calci/cumipmt"

Latest revision as of 12:02, 19 July 2015

CUMIPMT(R,PP,PV,SP,EP,Type)

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 R} is the interest rate.
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 PP} is the total number of payment periods.
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 PV} is the present value.
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} is the Start period beginning with 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 EP} is the End period.
$Type$ is the timing of the payment.

Description

This function gives the cumulative interest paid on a loan between 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} and 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 EP} .
CUMIPMT shows the ERROR value when

1. Interest RateFailed 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 (R)\le 0}

2. Payment Periods 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 (PP)\le 0}

3. Present ValueFailed 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 (PV)\le 0}

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

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 Type} 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

CUMIPMT

@@ 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>NPPeriods</math> is the total number of payment periods.
+*<math>PP</math> is the total number of payment periods.
 *<math>PV</math> is the present value.
-*<math>SP</math> is the first period beginning with 1.
+*<math>SP</math> is the Start period beginning with 1.
-*<math>EP</math> is the last period.
+*<math>EP</math> is the End period.
 *<math>Type</math> is the timing of the payment.
@@ Line 10: / Line 10: @@
 *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>
+. Interest Rate<math>(R)\le 0</math>
-  <math>NPPeriods\le 0</math>
+. Payment Periods <math>(PP)\le 0</math>
-  <math>PresentValue\le 0</math>
+. Present Value<math>(PV)\le 0</math>
-  <math>P\lt 1</math>
+. Start Period<math>(SP)\lt 1</math>
-  <math>EP\lt 1</math>
+. End Period<math>(EP)\lt 1</math>
-  <math>SP \gt EP</math>,
+. <math>SP \gt EP</math>
 *<math>Type</math> should be 0 or 1.
   '''TYPE'''             '''TIMIING'''
@@ Line 22: / Line 22: @@
 ==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==
+[https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_CUMIPMT_function CUMIPMT]