Microsoft Office Tutorials and References
In Depth Information
IPMT
The amount invested in the security.
INVESTMENT
The amount to be received at maturity.
REDEMPTION
The day count basis to use.
BASIS
INTRATE is calculated as follows:
Figure 6.19
The INTRATE function
returns the interest rate
of a security that’s fully
invested.
A
The function
built with
INTRATE cell
referencing
IPM IPMT returns the interest payment for a period of time based on an investment with periodic
constant payments and a constant interest rate.
=IPMT(rate,per,nper,pv,fv,type)
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.
RATE
The period for which you want to find the interest. This must be in the
range of 1 to Nper .
PER
The number of payment periods in an annuity.
NPER
The present value that a series of payments is worth right now. If omitted,
Excel assumes zero.
PV
The future value or cash balance you want to attain upon the last payment.
FV
The timing of the payment. When the payments are due.
TYPE
Search JabSto ::




Custom Search