Manuals/calci/CUMIPMT

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

• Where 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 Rate} is the interest rate, per peroid,
• 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 NoPaymentPeriods} is the number of periods over which the loan or investment is to be paid,
• 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 PresentValue} is the present value of loan or investment,
• 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 StartPeriod} is the number of the first period over which the interest is to be calculated (must be an integer between 1 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 NoPaymentPeriods} )
• $EndPeriod$ is the number of the last period over which the interest is to be calculated (must be an integer between 1 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 NoPaymentPeriods} )
• 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} 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)

• 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 StartPeriod} should be smaller than 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 EndPeriod} . Else Calci displays #NUM !error message.
• If 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 StartPeriod} or 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 EndPeriod} is <=0, then Calci displays #NUM !error message.
• If 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 StartPeriod} or 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 EndPeriod} is > $NoPaymentPeriods$, then Calci displays #NUM !error message.
• 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} 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 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} 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:

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

Related Videos

CUMPRINC and CUMIPMT

See Also

• CUMPRINC
• COUPDAYS
• COUPDAYBS
• COUPDAYSNC

References

• Coupon
• Day Count Basis

• List of Main Z Functions

• Z3 home