- Picture and text skills
- Case
Returns the interest repayment amount on an investment for a given period based on a fixed interest rate and equal installments.
Syntax
IPMT(rate,per,nper,pv,fv,type)
For detailed description of parameters in function IPMT, please refer to functionPV.
■ rate is the interest rate of each period
■ per The number of periods used to calculate the interest amount must be between 1 and nper between.
■ nper is the total investment period, that is, the total number of payment periods for the investment.
■ pv is the present value, that is, the amount of money that has been recorded from the beginning of the investment, or the cumulative sum of the current value of a series of future payments, also called the principal .
■ fv is the future value, or the cash balance expected after the last payment.
If fv is omitted, its value is assumed to be zero (for example, the future value of a loan is zero).
■ type Number 0 or 1, used to specify whether the payment time of each period is at the beginning or end of the period.
Description
■ Please confirm the specified rate and nper units consistency. For example, the same four-year loan with an annual interest rate of 12%,
If you pay monthly, the rate should be 12%/12 and nper should be 4*12; if you pay annually, the rate should be 12% and nper should be 4.
■ For all parameters, expenditures, such as bank deposits, are expressed as negative numbers; receipts, For example, dividend income is expressed as a positive number.
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/biao-ge-cai-wu-han-shu-qiao-yong-IPMT-han-shu-ji-suan-dai-kuan-li-xi.html
评论列表(196条)
测试