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 729
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 774
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 822
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 875
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 945
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 1009
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 1054
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 1092
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 1129
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 1165
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 1200
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 1235
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 1280
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 1323
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 1390
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 1433
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 1475
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 1502
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 1537
static float
NPV(...$args)
NPV.
Returns the Net Present Value of a cash flow series given a discount rate.
at line 1570
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 1599
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 1634
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 1657
static
PRICE($settlement, $maturity, $rate, $yield, $redemption, $frequency, $basis = 0)
at line 1718
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 1764
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 1822
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 1874
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 1938
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 1974
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 2001
static floatstring
SLN(mixed $cost, mixed $salvage, mixed $life)
SLN.
Returns the straightline depreciation of an asset for one period
at line 2031
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 2063
static float
TBILLEQ(mixed $settlement, mixed $maturity, int $discount)
TBILLEQ.
Returns the bondequivalent yield for a Treasury bill.
at line 2102
static float
TBILLPRICE(mixed $settlement, mixed $maturity, int $discount)
TBILLPRICE.
Returns the yield for a Treasury bill.
at line 2157
static float
TBILLYIELD(mixed $settlement, mixed $maturity, int $price)
TBILLYIELD.
Returns the yield for a Treasury bill.
at line 2190
static
XIRR($values, $dates, $guess = 0.1)
at line 2264
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 2314
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 2365
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.