- Picture and text skills
- Case
Returns the amount of interest accrued on a loan over the given start_period to end_period period.
Grammar
CUMIPMT(rate, nper, pv, start_period, end_period, type)
The CUMIPMT function syntax has the following parameters:
Rate: required. interest rate.
Nper: required. Total number of payment periods.
pv: required. Present value.
Start_period: required. The first period in the calculation. Payment periods start counting from 1.
End_period: required. The final period in the calculation.
Type: required. Payment time type.
Description
Make sure you specify rate and nper in the same units.
If you want to make monthly payments on a four-year loan at an annual interest rate of 10 percent, use 10%/12 for rate and 4*12 for nper.
If you make one payment per year on the same loan, use 10% for rate and 4 for nper.
If rate ≤ 0, nper ≤ 0, or pv ≤ 0, CUMIPMT returns the #NUM! error value.
If start_period < 1, end_period < 1, or start_period > end_period, CUMIPMT returns the #NUM! error value.
If type is not a number 0 or 1, CUMIPMT returns the #NUM! error value.
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-CUMIPMT-han-shu-liang-ge-fu-kuan-qi-zhi-jian-lei-ji-li-xi.html
支付宝扫一扫 
评论列表（196条）
测试