Microsoft Office Tutorials and References
In Depth Information
The amount invested in the security.
The amount to be received at maturity.
The day count basis to use.
INTRATE is calculated as follows:
The INTRATE function
returns the interest rate
of a security that’s fully
IPM IPMT returns the interest payment for a period of time based on an investment with periodic
constant payments and a constant interest rate.
The IPMT function returns an interest payment over a period of time. As shown in Figure 6.20,
the interest rate per period is 7%. Period 1 is the period in which to find the payment when
spread out over a total of 36 payments. The present value or lump sum amount that the future
payments is worth right now is $10,000. As you see, the future value of the loan in this case is
0 and the payment is at the end of each period. So the interest payment for the first period of
the loan in the example equals $70.
The interest rate per period.
The period for which you want to find the interest. This must be in the
range of 1 to Nper .
The number of payment periods in an annuity.
The present value that a series of payments is worth right now. If omitted,
Excel assumes zero.
The future value or cash balance you want to attain upon the last payment.
The timing of the payment. When the payments are due.