Manuals/calci/IPMT

From ZCubes Wiki
Revision as of 20:38, 24 October 2013 by MassBot1 (talk | contribs) (Created page with "<div id="6SpaceContent" class="zcontent" align="left">  <font color="#000000">'''<font face="Arial, sans-serif"><font size="2">IPMT(R, per, nper, P value, F value, type)</...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
 

IPMT(R, per, nper, P value, F value, type)

Where 'R' is the interest rate per period, 'per' is the period to find the interest, 'nper' is the total number of payment periods in an annuity, 'P value' is the present value, 'F value' is the future value and 'type' indicates when payments are due.

 

This function returns the interest payment for a given period for an investment.

IPMT

Lets see an example,

IPMT(R, per, nper, P value, F value, type)

B

15%

1

3

7500

=IPMT(B2, 3, B4, B5) is -428.4557

Syntax
Examples
Description
Column1 Column2 Column3 Column4
Row1 15%
Row2 1
Row3 3
Row4 7500
Row5 -428.4557
Row6
Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/IPMT&oldid=456"