Search moodle.org's
Developer Documentation

See Release Notes

  • Bug fixes for general core bugs in 4.0.x will end 8 May 2023 (12 months).
  • Bug fixes for security issues in 4.0.x will end 13 November 2023 (18 months).
  • PHP version: minimum PHP 7.3.0 Note: the minimum PHP version has increased since Moodle 3.10. PHP 7.4.x is also supported.
/lib/phpspreadsheet/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Calculation/Financial/CashFlow/Constant/Periodic/ -> Cumulative.php (source)

[Source view]

Differences Between: [Versions 400 and 401] [Versions 400 and 402] [Versions 400 and 403]

(no description)

File Size: 141 lines (5 kb)
Included or required:0 times
Referenced: 0 times
Includes or requires: 0 files

Defines 1 class

Cumulative:: (2 methods):
  interest()
  principal()


Class: Cumulative  - X-Ref

interest($rate,$periods,$presentValue,$start,$end,$type = FinancialConstants::PAYMENT_END_OF_PERIOD)   X-Ref
CUMIPMT.

Returns the cumulative interest paid on a loan between the start and end periods.

Excel Function:
CUMIPMT(rate,nper,pv,start,end[,type])

return: float|string
param: mixed $rate The Interest rate
param: mixed $periods The total number of payment periods
param: mixed $presentValue Present Value
param: mixed $start The first period in the calculation.
param: mixed $end the last period in the calculation
param: mixed $type A number 0 or 1 and indicates when payments are due:

principal($rate,$periods,$presentValue,$start,$end,$type = FinancialConstants::PAYMENT_END_OF_PERIOD)   X-Ref
CUMPRINC.

Returns the cumulative principal paid on a loan between the start and end periods.

Excel Function:
CUMPRINC(rate,nper,pv,start,end[,type])

return: float|string
param: mixed $rate The Interest rate
param: mixed $periods The total number of payment periods as an integer
param: mixed $presentValue Present Value
param: mixed $start The first period in the calculation.
param: mixed $end the last period in the calculation
param: mixed $type A number 0 or 1 and indicates when payments are due: