Search moodle.org's
Developer Documentation

See Release Notes

  • Bug fixes for general core bugs in 4.3.x will end 7 October 2024 (12 months).
  • Bug fixes for security issues in 4.3.x will end 21 April 2025 (18 months).
  • PHP version: minimum PHP 8.0.0 Note: minimum PHP version has increased since Moodle 4.1. PHP 8.2.x is supported too.
/lib/phpspreadsheet/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Calculation/Financial/CashFlow/Constant/Periodic/ -> Cumulative.php (source)

[Source view]

Differences Between: [Versions 400 and 403]

(no description)

File Size: 142 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])

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:
return: float|string

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])

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:
return: float|string