- Picture and text skills
- Case
Calculate the interest to be paid over a specific investment period.
Syntax
ISPMT(rate,per,nper,pv)
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.
nper is the total investment period, that is, the item The total number of payment periods for the investment.
pv is the current value of the investment. For loans, pv is the loan amount.
Description
•Confirm the consistency of the specified rate and nper units. 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, negative numbers represent cash disbursements (such as deposits or withdrawals from others), and positive numbers represent cash receipts (such as dividends or deposits from others).
•For additional information about financial functions, please See PVfunction.
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-ISPMT-han-shu-ji-suan-te-ding-tou-zi-qi-yao-zhi-fu-li-xi.html
支付宝扫一扫 
评论列表（196条）
测试