Financial
class Financial (View source)
Constants
FINANCIAL_MAX_ITERATIONS 

FINANCIAL_PRECISION 

Methods
ACCRINT.
ACCRINTM.
AMORDEGRC.
AMORLINC.
COUPDAYBS.
COUPDAYS.
COUPDAYSNC.
COUPNCD.
COUPNUM.
COUPPCD.
CUMIPMT.
CUMPRINC.
DB.
DDB.
DISC.
DOLLARDE.
DOLLARFR.
EFFECT.
FV.
FVSCHEDULE.
INTRATE.
IPMT.
IRR.
ISPMT.
MIRR.
NOMINAL.
NPER.
NPV.
PDURATION.
PMT.
PPMT.
No description
PRICEDISC.
PRICEMAT.
PV.
RATE.
RECEIVED.
RRI.
SLN.
SYD.
TBILLEQ.
TBILLPRICE.
TBILLYIELD.
No description
XNPV.
YIELDDISC.
YIELDMAT.
Details
at line 149
static floatstring
ACCRINT(mixed $issue, mixed $firstinterest, mixed $settlement, float $rate, float $par = 1000, int $frequency = 1, int $basis = 0)
ACCRINT.
Returns the accrued interest for a security that pays periodic interest.
Excel Function: ACCRINT(issue,firstinterest,settlement,rate,par,frequency[,basis])
at line 202
static floatstring
ACCRINTM(mixed $issue, mixed $settlement, float $rate, float $par = 1000, int $basis = 0)
ACCRINTM.
Returns the accrued interest for a security that pays interest at maturity.
Excel Function: ACCRINTM(issue,settlement,rate[,par[,basis]])
at line 261
static float
AMORDEGRC(float $cost, mixed $purchased, mixed $firstPeriod, mixed $salvage, float $period, float $rate, int $basis = 0)
AMORDEGRC.
Returns the depreciation for each accounting period. This function is provided for the French accounting system. If an asset is purchased in the middle of the accounting period, the prorated depreciation is taken into account. The function is similar to AMORLINC, except that a depreciation coefficient is applied in the calculation depending on the life of the assets. This function will return the depreciation until the last period of the life of the assets or until the cumulated value of depreciation is greater than the cost of the assets minus the salvage value.
Excel Function: AMORDEGRC(cost,purchased,firstPeriod,salvage,period,rate[,basis])
at line 339
static float
AMORLINC(float $cost, mixed $purchased, mixed $firstPeriod, mixed $salvage, float $period, float $rate, int $basis = 0)
AMORLINC.
Returns the depreciation for each accounting period. This function is provided for the French accounting system. If an asset is purchased in the middle of the accounting period, the prorated depreciation is taken into account.
Excel Function: AMORLINC(cost,purchased,firstPeriod,salvage,period,rate[,basis])
at line 406
static floatstring
COUPDAYBS(mixed $settlement, mixed $maturity, int $frequency, int $basis = 0)
COUPDAYBS.
Returns the number of days from the beginning of the coupon period to the settlement date.
Excel Function: COUPDAYBS(settlement,maturity,frequency[,basis])
at line 465
static floatstring
COUPDAYS(mixed $settlement, mixed $maturity, mixed $frequency, int $basis = 0)
COUPDAYS.
Returns the number of days in the coupon period that contains the settlement date.
Excel Function: COUPDAYS(settlement,maturity,frequency[,basis])
at line 539
static floatstring
COUPDAYSNC(mixed $settlement, mixed $maturity, mixed $frequency, int $basis = 0)
COUPDAYSNC.
Returns the number of days from the settlement date to the next coupon date.
Excel Function: COUPDAYSNC(settlement,maturity,frequency[,basis])
at line 599
static mixed
COUPNCD(mixed $settlement, mixed $maturity, mixed $frequency, int $basis = 0)
COUPNCD.
Returns the next coupon date after the settlement date.
Excel Function: COUPNCD(settlement,maturity,frequency[,basis])
at line 656
static intstring
COUPNUM(mixed $settlement, mixed $maturity, mixed $frequency, int $basis = 0)
COUPNUM.
Returns the number of coupons payable between the settlement date and maturity date, rounded up to the nearest whole coupon.
Excel Function: COUPNUM(settlement,maturity,frequency[,basis])
at line 725
static mixed
COUPPCD(mixed $settlement, mixed $maturity, mixed $frequency, int $basis = 0)
COUPPCD.
Returns the previous coupon date before the settlement date.
Excel Function: COUPPCD(settlement,maturity,frequency[,basis])
at line 770
static floatstring
CUMIPMT(float $rate, int $nper, float $pv, int $start, int $end, int $type = 0)
CUMIPMT.
Returns the cumulative interest paid on a loan between the start and end periods.
Excel Function: CUMIPMT(rate,nper,pv,start,end[,type])
at line 818
static floatstring
CUMPRINC(float $rate, int $nper, float $pv, int $start, int $end, int $type = 0)
CUMPRINC.
Returns the cumulative principal paid on a loan between the start and end periods.
Excel Function: CUMPRINC(rate,nper,pv,start,end[,type])
at line 871
static floatstring
DB(float $cost, float $salvage, int $life, int $period, int $month = 12)
DB.
Returns the depreciation of an asset for a specified period using the fixeddeclining balance method. This form of depreciation is used if you want to get a higher depreciation value at the beginning of the depreciation (as opposed to linear depreciation). The depreciation value is reduced with every depreciation period by the depreciation already deducted from the initial cost.
Excel Function: DB(cost,salvage,life,period[,month])
at line 941
static floatstring
DDB(float $cost, float $salvage, int $life, int $period, float $factor = 2.0)
DDB.
Returns the depreciation of an asset for a specified period using the doubledeclining balance method or some other method you specify.
Excel Function: DDB(cost,salvage,life,period[,factor])
at line 1005
static floatstring
DISC(mixed $settlement, mixed $maturity, int $price, int $redemption, int $basis = 0)
DISC.
Returns the discount rate for a security.
Excel Function: DISC(settlement,maturity,price,redemption[,basis])
at line 1050
static floatstring
DOLLARDE(float $fractional_dollar = null, int $fraction = 0)
DOLLARDE.
Converts a dollar price expressed as an integer part and a fraction part into a dollar price expressed as a decimal number. Fractional dollar numbers are sometimes used for security prices.
Excel Function: DOLLARDE(fractional_dollar,fraction)
at line 1088
static floatstring
DOLLARFR(float $decimal_dollar = null, int $fraction = 0)
DOLLARFR.
Converts a dollar price expressed as a decimal number into a dollar price expressed as a fraction. Fractional dollar numbers are sometimes used for security prices.
Excel Function: DOLLARFR(decimal_dollar,fraction)
at line 1125
static floatstring
EFFECT(float $nominal_rate = 0, int $npery = 0)
EFFECT.
Returns the effective interest rate given the nominal rate and the number of compounding payments per year.
Excel Function: EFFECT(nominal_rate,npery)
at line 1161
static floatstring
FV(float $rate = 0, int $nper = 0, float $pmt = 0, float $pv = 0, int $type = 0)
FV.
Returns the Future Value of a cash flow with constant payments and interest rate (annuities).
Excel Function: FV(rate,nper,pmt[,pv[,type]])
at line 1196
static float
FVSCHEDULE(float $principal, float[] $schedule)
FVSCHEDULE.
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)
at line 1231
static floatstring
INTRATE(mixed $settlement, mixed $maturity, int $investment, int $redemption, int $basis = 0)
INTRATE.
Returns the interest rate for a fully invested security.
Excel Function: INTRATE(settlement,maturity,investment,redemption[,basis])
at line 1276
static floatstring
IPMT(float $rate, int $per, int $nper, float $pv, float $fv = 0, int $type = 0)
IPMT.
Returns the interest payment for a given period for an investment based on periodic, constant payments and a constant interest rate.
Excel Function: IPMT(rate,per,nper,pv[,fv][,type])
at line 1319
static floatstring
IRR(float[] $values, float $guess = 0.1)
IRR.
Returns the internal rate of return for a series of cash flows represented by the numbers in values. These cash flows do not have to be even, as they would be for an annuity. However, the cash flows must occur at regular intervals, such as monthly or annually. The internal rate of return is the interest rate received for an investment consisting of payments (negative values) and income (positive values) that occur at regular periods.
Excel Function: IRR(values[,guess])
at line 1386
static
ISPMT(...$args)
ISPMT.
Returns the interest payment for an investment based on an interest rate and a constant payment schedule.
Excel Function: =ISPMT(interest_rate, period, number_payments, PV)
interest_rate is the interest rate for the investment
period is the period to calculate the interest rate. It must be betweeen 1 and number_payments.
number_payments is the number of payments for the annuity
PV is the loan amount or present value of the payments
at line 1429
static floatstring
MIRR(float[] $values, float $finance_rate, float $reinvestment_rate)
MIRR.
Returns the modified internal rate of return for a series of periodic cash flows. MIRR considers both the cost of the investment and the interest received on reinvestment of cash.
Excel Function: MIRR(values,finance_rate, reinvestment_rate)
at line 1471
static floatstring
NOMINAL(float $effect_rate = 0, int $npery = 0)
NOMINAL.
Returns the nominal interest rate given the effective rate and the number of compounding payments per year.
at line 1498
static floatstring
NPER(float $rate = 0, int $pmt = 0, float $pv = 0, float $fv = 0, int $type = 0)
NPER.
Returns the number of periods for a cash flow with constant periodic payments (annuities), and interest rate.
at line 1533
static float
NPV(...$args)
NPV.
Returns the Net Present Value of a cash flow series given a discount rate.
at line 1566
static floatstring
PDURATION(float $rate = 0, float $pv = 0, float $fv = 0)
PDURATION.
Calculates the number of periods required for an investment to reach a specified value.
at line 1595
static float
PMT(float $rate = 0, int $nper = 0, float $pv = 0, float $fv = 0, int $type = 0)
PMT.
Returns the constant payment (annuity) for a cash flow with a constant interest rate.
at line 1630
static float
PPMT(float $rate, int $per, int $nper, float $pv, float $fv = 0, int $type = 0)
PPMT.
Returns the interest payment for a given period for an investment based on periodic, constant payments and a constant interest rate.
at line 1653
static
PRICE($settlement, $maturity, $rate, $yield, $redemption, $frequency, $basis = 0)
at line 1714
static float
PRICEDISC(mixed $settlement, mixed $maturity, int $discount, int $redemption, int $basis = 0)
PRICEDISC.
Returns the price per $100 face value of a discounted security.
at line 1760
static float
PRICEMAT(mixed $settlement, mixed $maturity, mixed $issue, int $rate, int $yield, int $basis = 0)
PRICEMAT.
Returns the price per $100 face value of a security that pays interest at maturity.
at line 1818
static float
PV(float $rate = 0, int $nper = 0, float $pmt = 0, float $fv = 0, int $type = 0)
PV.
Returns the Present Value of a cash flow with constant payments and interest rate (annuities).
at line 1870
static float
RATE(float $nper, float $pmt, float $pv, float $fv = 0.0, int $type = 0, float $guess = 0.1)
RATE.
Returns the interest rate per period of an annuity. RATE is calculated by iteration and can have zero or more solutions. If the successive results of RATE do not converge to within 0.0000001 after 20 iterations, RATE returns the #NUM! error value.
Excel Function: RATE(nper,pmt,pv[,fv[,type[,guess]]])
at line 1934
static float
RECEIVED(mixed $settlement, mixed $maturity, int $investment, int $discount, int $basis = 0)
RECEIVED.
Returns the price per $100 face value of a discounted security.
at line 1970
static floatstring
RRI(float $nper = 0, float $pv = 0, float $fv = 0)
RRI.
Calculates the interest rate required for an investment to grow to a specified future value .
at line 1997
static floatstring
SLN(mixed $cost, mixed $salvage, mixed $life)
SLN.
Returns the straightline depreciation of an asset for one period
at line 2027
static floatstring
SYD(mixed $cost, mixed $salvage, mixed $life, mixed $period)
SYD.
Returns the sumofyears' digits depreciation of an asset for a specified period.
at line 2059
static float
TBILLEQ(mixed $settlement, mixed $maturity, int $discount)
TBILLEQ.
Returns the bondequivalent yield for a Treasury bill.
at line 2098
static float
TBILLPRICE(mixed $settlement, mixed $maturity, int $discount)
TBILLPRICE.
Returns the yield for a Treasury bill.
at line 2153
static float
TBILLYIELD(mixed $settlement, mixed $maturity, int $price)
TBILLYIELD.
Returns the yield for a Treasury bill.
at line 2186
static
XIRR($values, $dates, $guess = 0.1)
at line 2260
static float
XNPV(float $rate, array $values, array $dates)
XNPV.
Returns the net present value for a schedule of cash flows that is not necessarily periodic. To calculate the net present value for a series of cash flows that is periodic, use the NPV function.
Excel Function: =XNPV(rate,values,dates)
at line 2310
static float
YIELDDISC(mixed $settlement, mixed $maturity, int $price, int $redemption, int $basis = 0)
YIELDDISC.
Returns the annual yield of a security that pays interest at maturity.
at line 2361
static float
YIELDMAT(mixed $settlement, mixed $maturity, mixed $issue, int $rate, int $price, int $basis = 0)
YIELDMAT.
Returns the annual yield of a security that pays interest at maturity.