Search moodle.org's
Developer Documentation

See Release Notes
Long Term Support Release

  • Bug fixes for general core bugs in 4.1.x will end 13 November 2023 (12 months).
  • Bug fixes for security issues in 4.1.x will end 10 November 2025 (36 months).
  • PHP version: minimum PHP 7.4.0 Note: minimum PHP version has increased since Moodle 4.0. PHP 8.0.x is supported too.
/lib/phpspreadsheet/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Calculation/Financial/Securities/ -> Rates.php (source)

[Source view]

Differences Between: [Versions 400 and 401]

(no description)

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

Defines 1 class

Rates:: (2 methods):
  discount()
  interest()


Class: Rates  - X-Ref

discount($settlement,$maturity,$price,$redemption,$basis = FinancialConstants::BASIS_DAYS_PER_YEAR_NASD)   X-Ref
DISC.

Returns the discount rate for a security.

Excel Function:
DISC(settlement,maturity,price,redemption[,basis])

param: mixed $settlement The security's settlement date.
param: mixed $maturity The security's maturity date.
param: mixed $price The security's price per $100 face value
param: mixed $redemption The security's redemption value per $100 face value
param: mixed $basis The type of day count to use.
return: float|string

interest($settlement,$maturity,$investment,$redemption,$basis = FinancialConstants::BASIS_DAYS_PER_YEAR_NASD)   X-Ref
INTRATE.

Returns the interest rate for a fully invested security.

Excel Function:
INTRATE(settlement,maturity,investment,redemption[,basis])

param: mixed $settlement The security's settlement date.
param: mixed $maturity The security's maturity date.
param: mixed $investment the amount invested in the security
param: mixed $redemption the amount to be received at maturity
param: mixed $basis The type of day count to use.
return: float|string