Rates
in package
Table of Contents
Methods
- discount() : float|string
- DISC.
- interest() : float|string
- INTRATE.
Methods
discount()
DISC.
public
static discount(mixed $settlement, mixed $maturity, mixed $price, mixed $redemption[, mixed $basis = FinancialConstants::BASIS_DAYS_PER_YEAR_NASD ]) : float|string
Returns the discount rate for a security.
Excel Function: DISC(settlement,maturity,price,redemption[,basis])
Parameters
- $settlement : mixed
-
The security's settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer.
- $maturity : mixed
-
The security's maturity date. The maturity date is the date when the security expires.
- $price : mixed
-
The security's price per $100 face value
- $redemption : mixed
-
The security's redemption value per $100 face value
- $basis : mixed = FinancialConstants::BASIS_DAYS_PER_YEAR_NASD
-
The type of day count to use. 0 or omitted US (NASD) 30/360 1 Actual/actual 2 Actual/360 3 Actual/365 4 European 30/360
Return values
float|stringinterest()
INTRATE.
public
static interest(mixed $settlement, mixed $maturity, mixed $investment, mixed $redemption[, mixed $basis = FinancialConstants::BASIS_DAYS_PER_YEAR_NASD ]) : float|string
Returns the interest rate for a fully invested security.
Excel Function: INTRATE(settlement,maturity,investment,redemption[,basis])
Parameters
- $settlement : mixed
-
The security's settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer.
- $maturity : mixed
-
The security's maturity date. The maturity date is the date when the security expires.
- $investment : mixed
-
the amount invested in the security
- $redemption : mixed
-
the amount to be received at maturity
- $basis : mixed = FinancialConstants::BASIS_DAYS_PER_YEAR_NASD
-
The type of day count to use. 0 or omitted US (NASD) 30/360 1 Actual/actual 2 Actual/360 3 Actual/365 4 European 30/360