IPMT
Returns the interest payment for a given period for an investment based on periodic, constant payments and a constant interest rate.
Syntax
IPMT(rate, per, nper, pv, [fv], [type])
Arguments
| Argument |
Description |
Required |
rate |
The interest rate per period. |
Required |
per |
The period for which you want to find the interest. |
Required |
nper |
The total number of payment periods. |
Required |
pv |
The present value, or lump-sum amount. |
Required |
fv |
The future value, or cash balance you want to attain after the last payment is made. Default is 0. |
Optional |
type |
When payments are due. 0 = end of period, 1 = beginning of period. Default is 0. |
Optional |
Examples
Interest payment for first period
=IPMT(0.1/12, 1, 3*12, 8000)
Result ⇒
-66.6667
Interest for specific loan period
=IPMT(0.08/12, 10, 10*12, 200000)
Result ⇒
-1265.9636
Monthly interest from cell references
=IPMT(A1/12, A2, A3, A4)
Result ⇒
-40.0711
Related Functions
Other Financial functions:
- CUMIPMT - Returns the cumulative interest paid between start_period and end_period
- CUMPRINC - Returns the cumulative principal paid on a loan between start_period and end_period
- DB - Returns the depreciation of an asset for a specified period using the fixed-declining balance method
- DISC - Returns the discount rate for a security
- EFFECT - Returns the effective annual interest rate
- FV - Returns the future value of an investment.
- FVSCHEDULE - Returns the future value of an initial principal after applying a series of compound interest rates
- IRR - Returns the internal rate of return for a series of cash flows
- NOMINAL - Returns the annual nominal interest rate
- NPER - Returns the number of periods for an investment
- NPV - Calculates the net present value of a series of cash flows at a given discount rate
- PMT - Calculates the payment for a loan based on constant payments and a constant interest rate.
- PPMT - Returns the payment on the principal for a given period for an investment based on periodic, constant payments and a constant interest rate.
- PV - Returns the present value of an investment.
- RATE - Returns the interest rate per period of a loan or investment.
- SLN - Returns the straight-line depreciation of an asset for one period
- XIRR - Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic
- XNPV - Returns the net present value for a schedule of cash flows that is not necessarily periodic
← Back to Formula Reference