Manuals/calci/CUMIPMT - Revision history

Devika at 22:03, 22 August 2018

2018-08-22T22:03:27Z

Devika at 21:02, 29 June 2018

2018-06-29T21:02:57Z

Swapna at 02:06, 17 March 2017

2017-03-17T02:06:03Z

Swapna at 02:03, 17 March 2017

2017-03-17T02:03:27Z

Swapna: Created page with "= CUMIPMT(Rate,NoPaymentPeriods,PresentValue,StartPeriod,EndPeriod,Type) = Where $Rate$ is the interest rate, per peroid, $NoPaymentPeriods$ is the nu..."

2017-03-16T11:01:14Z

Created page with "= CUMIPMT(Rate,NoPaymentPeriods,PresentValue,StartPeriod,EndPeriod,Type) = *Where <math>Rate</math> is the interest rate, per peroid, *<math>NoPaymentPeriods</math> is the nu..."

New page

= CUMIPMT(Rate,NoPaymentPeriods,PresentValue,StartPeriod,EndPeriod,Type) =

*Where <math>Rate</math> is the interest rate, per peroid,
*<math>NoPaymentPeriods</math> is the number of periods over which the loan or investment is to be paid,
*<math>PresentValue</math> is the present value of loan or investment,
*<math>StartPeriod</math> is the number of the first period over which the interest is to be calculated (must be an integer between 1 and <math>NoPaymentPeriods</math>)
*<math>EndPeriod</math> is the number of the last period over which the interest is to be calculated (must be an integer between 1 and <math>NoPaymentPeriods</math>)
*<math>Type</math> is specifies whether the payment is made at the start or end of the period.

CUMIPMT() calculates the cumulative interest paid on a loan or an investment, between two specific periods.

== Description ==

CUMIPMT(Rate,NoPaymentPeriods,PresentValue,StartPeriod,EndPeriod,Type)

*<math>StartPeriod</math> should be smaller than <math>EndPeriod</math>. Else Calci displays #NUM !error message.
*If <math>StartPeriod</math> or <math>EndPeriod</math> is <=0, then Calci displays #NUM !error message.
*If <math>StartPeriod</math> or <math>EndPeriod</math> is > <math>NoPaymentPeriods</math>, then Calci displays #NUM !error message.
*<math>Type</math> value is an integer value (either 0 or 1).
'''0''' indicates the payment is made at the end of the period;
'''1''' indicates the payment is made at the start of the period.
*If <math>Type</math> value is other than 0 or 1, Calci displays #N/A error message.

== Examples ==

Consider the following example that shows the use of COUPNUM function:

<div id="2SpaceContent" class="zcontent" align="left">

{| id="TABLE3" class="SpreadSheet blue"
|- class="even"
| class=" " |
| class=" " |
| class=" " |

|- class="odd"
| class="sshl_f" |
| class=" " |
| class=" " |

|- class="even"
| class=" " |
| class=" " |
| class=" " |

|- class="odd"
| class=" " |
| class=" " |
| class=" " |
|}

=CUMIPMT() ''displays '' as a result.
=CUMIPMT() ''displays '' as a result.

==Related Videos==

{{#ev:youtube|1jQp96xzkhY|280|center|CUMPRINC and CUMIPMT}}

== See Also ==

*[[Manuals/calci/CUMPRINC | CUMPRINC]]
*[[Manuals/calci/COUPDAYS | COUPDAYS]]
*[[Manuals/calci/COUPDAYBS | COUPDAYBS]]
*[[Manuals/calci/COUPDAYSNC | COUPDAYSNC]]

== References ==

*[http://en.wikipedia.org/wiki/Coupon_(bond) Coupon]
*[http://en.wikipedia.org/wiki/Day_count_convention Day Count Basis]

*[[Z_API_Functions | List of Main Z Functions]]

*[[ Z3 | Z3 home ]]

@@ Line 1: / Line 1: @@
-= CUMIPMT(Rate,NoPaymentPeriods,PresentValue,StartPeriod,EndPeriod,Type) =
+<div style="font-size:30px">'''CUMIPMT(Rate,NoPaymentPeriods,PresentValue,StartPeriod,EndPeriod,Type)'''</div><br/>
 *Where <math>Rate</math> is the interest rate, per peroid,
 *<math>NoPaymentPeriods</math> is the number of periods over which the loan or investment is to be paid,
@@ Line 7: / Line 6: @@
 *<math>EndPeriod</math> is the number of the last period over which the interest is to be calculated,
 *<math>Type</math> specifies whether the payment is made at the start or end of the period.
+**CUMIPMT(), returns the cumulative interest paid between two periods.
 == Description ==

@@ Line 8: / Line 8: @@
 *<math>Type</math> specifies whether the payment is made at the start or end of the period.
-CUMIPMT() calculates the cumulative interest paid on a loan or an investment, between two specific periods.
+CUMIPMT(), returns the cumulative interest paid between two periods.
 == Description ==

@@ Line 112: / Line 112: @@
 == See Also ==
 *[[Manuals/calci/CUMPRINC | CUMPRINC]]
 == References ==