- Picture and text skills
- Case
Returns the cumulative principal amount repaid on a loan during the given start_period to end_period period.
Syntax
CUMPRINC(rate, nper, pv, start_period, end_period, type)
CUMPRINC function syntax has the following parameters:
Rate: required, interest rate.
Nper: required, the 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 end period in the calculation.
Type: required, payment time type.
Type | Time type |
---|---|
0 (zero) | Final payment |
1 | Initial payment |
Description
■ Please make sure that the units used for specifying rate and nper are consistent. If you want to make monthly payments on a four-year loan at an annual interest rate of 12 percent, then
rate should be 12%/12 and nper should be 4*12. If one payment was made annually on the same loan, rate would be 12% and nper would be 4.
■
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/jing-tong-CUMPRINC-han-shu-qing-song-ji-suan-dai-kuan-ben-jin.html
评论列表(196条)
测试