Single
in package
Table of Contents
Methods
- futureValue() : string|float
- FVSCHEDULE.
- interestRate() : float|string
- RRI.
- periods() : float|string
- PDURATION.
Methods
futureValue()
FVSCHEDULE.
public
static futureValue(mixed $principal, array<string|int, float> $schedule) : string|float
Returns the future value of an initial principal after applying a series of compound interest rates. Use FVSCHEDULE to calculate the future value of an investment with a variable or adjustable rate.
Excel Function: FVSCHEDULE(principal,schedule)
Parameters
- $principal : mixed
-
the present value
- $schedule : array<string|int, float>
-
an array of interest rates to apply
Return values
string|floatinterestRate()
RRI.
public
static interestRate([array<string|int, mixed>|float $periods = 0.0 ][, array<string|int, mixed>|float $presentValue = 0.0 ][, array<string|int, mixed>|float $futureValue = 0.0 ]) : float|string
Calculates the interest rate required for an investment to grow to a specified future value .
Parameters
- $periods : array<string|int, mixed>|float = 0.0
-
The number of periods over which the investment is made
- $presentValue : array<string|int, mixed>|float = 0.0
-
Present Value
- $futureValue : array<string|int, mixed>|float = 0.0
-
Future Value
Return values
float|string —Result, or a string containing an error
periods()
PDURATION.
public
static periods(mixed $rate, mixed $presentValue, mixed $futureValue) : float|string
Calculates the number of periods required for an investment to reach a specified value.
Parameters
- $rate : mixed
-
Interest rate per period
- $presentValue : mixed
-
Present Value
- $futureValue : mixed
-
Future Value
Return values
float|string —Result, or a string containing an error