public static
float

#
ACCRINT( mixed $issue, mixed $firstinter, mixed $settlement, float $rate, float $par = 1000, integer $frequency = 1, mixed $basis = 0 )
ACCRINT
Returns the discount rate for a security.
Parameters
 $issue
 The security's issue date.
 $firstinter
 The security's first interest date.
 $settlement
 The security's settlement date.
 $rate
 The security's annual coupon rate.
 $par
 The security's par value.
 $frequency
 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
 $basis
Returns
float float

public static
float

#
ACCRINTM( mixed $issue, mixed $settlement, float $rate, float $par = 1000, integer $basis = 0 )
ACCRINTM
Returns the discount rate for a security.
Parameters
 $issue
 The security's issue date.
 $settlement
 The security's settlement date.
 $rate
 The security's annual coupon rate.
 $par
 The security's par value.
 $basis
 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
Returns
float float

public static

#
AMORDEGRC( mixed $cost, mixed $purchased, mixed $firstPeriod, mixed $salvage, mixed $period, mixed $rate, mixed $basis = 0 )

public static

#
AMORLINC( mixed $cost, mixed $purchased, mixed $firstPeriod, mixed $salvage, mixed $period, mixed $rate, mixed $basis = 0 )

public static

#
COUPDAYBS( mixed $settlement, mixed $maturity, mixed $frequency, mixed $basis = 0 )

public static

#
COUPDAYS( mixed $settlement, mixed $maturity, mixed $frequency, mixed $basis = 0 )

public static

#
COUPDAYSNC( mixed $settlement, mixed $maturity, mixed $frequency, mixed $basis = 0 )

public static

#
COUPNCD( mixed $settlement, mixed $maturity, mixed $frequency, mixed $basis = 0 )

public static

#
COUPNUM( mixed $settlement, mixed $maturity, mixed $frequency, mixed $basis = 0 )

public static

#
COUPPCD( mixed $settlement, mixed $maturity, mixed $frequency, mixed $basis = 0 )

public static
float

#
CUMIPMT( float $rate, integer $nper, float $pv, integer $start, integer $end, integer $type = 0 )
CUMIPMT
Returns the cumulative interest paid on a loan between start_period and
end_period.
Parameters
 $rate
 Interest rate per period
 $nper
 Number of periods
 $pv
 Present Value
 $start
 The first period in the calculation. Payment periods are numbered beginning with
1.
 $end
 The last period in the calculation.
 $type
 Payment type: 0 = at the end of each period, 1 = at the beginning of each period
Returns
float float

public static
float

#
CUMPRINC( float $rate, integer $nper, float $pv, integer $start, integer $end, integer $type = 0 )
CUMPRINC
Returns the cumulative principal paid on a loan between start_period and
end_period.
Parameters
 $rate
 Interest rate per period
 $nper
 Number of periods
 $pv
 Present Value
 $start
 The first period in the calculation. Payment periods are numbered beginning with
1.
 $end
 The last period in the calculation.
 $type
 Payment type: 0 = at the end of each period, 1 = at the beginning of each period
Returns
float float

public static
float

#
DB( float $cost, float $salvage, integer $life, integer $period, float $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.
Parameters
 $cost
 Initial cost of the asset.
 $salvage
 Value at the end of the depreciation. (Sometimes called the salvage value of the
asset)
 $life
 Number of periods over which the asset is depreciated. (Sometimes called the
useful life of the asset)
 $period
 The period for which you want to calculate the depreciation. Period must use the
same units as life.
 $month
 Number of months in the first year. If month is omitted, it defaults to 12.
Returns
float float

public static
float

#
DDB( float $cost, float $salvage, integer $life, integer $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.
Parameters
 $cost
 Initial cost of the asset.
 $salvage
 Value at the end of the depreciation. (Sometimes called the salvage value of the
asset)
 $life
 Number of periods over which the asset is depreciated. (Sometimes called the
useful life of the asset)
 $period
 The period for which you want to calculate the depreciation. Period must use the
same units as life.
 $factor
 The rate at which the balance declines. If factor is omitted, it is assumed to
be 2 (the doubledeclining balance method).
Returns
float float

public static
float

#
DISC( mixed $settlement, mixed $maturity, integer $price, integer $redemption, integer $basis = 0 )
DISC
Returns the discount rate for a security.
Parameters
 $settlement
 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
 The security's maturity date. The maturity date is the date when the security
expires.
 $price
 The security's price per $100 face value.
 $redemption
 the security's redemption value per $100 face value.
 $basis
 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
Returns
float float

public static
float

#
DOLLARDE( float $fractional_dollar = Null, integer $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.
Parameters
 $fractional_dollar
 Fractional Dollar
 $fraction
 Fraction
Returns
float float

public static
float

#
DOLLARFR( float $decimal_dollar = Null, integer $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.
Parameters
 $decimal_dollar
 Decimal Dollar
 $fraction
 Fraction
Returns
float float

public static
float

#
EFFECT( float $nominal_rate = 0, integer $npery = 0 )
EFFECT
Returns the effective interest rate given the nominal rate and the number of
compounding payments per year.
Parameters
 $nominal_rate
 Nominal interest rate
 $npery
 Number of compounding payments per year
Returns
float float

public static
float

#
FV( float $rate = 0, integer $nper = 0, float $pmt = 0, float $pv = 0, integer $type = 0 )
FV
Returns the Future Value of a cash flow with constant payments and interest
rate (annuities).
Parameters
 $rate
 Interest rate per period
 $nper
 Number of periods
 $pmt
 Periodic payment (annuity)
 $pv
 Present Value
 $type
 Payment type: 0 = at the end of each period, 1 = at the beginning of each period
Returns
float float

public static


public static
float

#
INTRATE( mixed $settlement, mixed $maturity, integer $investment, integer $redemption, integer $basis = 0 )
INTRATE
Returns the interest rate for a fully invested security.
Parameters
 $settlement
 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
 The security's maturity date. The maturity date is the date when the security
expires.
 $investment
 The amount invested in the security.
 $redemption
 The amount to be received at maturity.
 $basis
 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
Returns
float float

public static
float

#
IPMT( float $rate, integer $per, integer $nper, float $pv, float $fv = 0, integer $type = 0 )
IPMT
Returns the interest payment for a given period for an investment based on
periodic, constant payments and a constant interest rate.
Parameters
 $rate
 Interest rate per period
 $per
 Period for which we want to find the interest
 $nper
 Number of periods
 $pv
 Present Value
 $fv
 Future Value
 $type
 Payment type: 0 = at the end of each period, 1 = at the beginning of each period
Returns
float float

public static

#
IRR( mixed $values, mixed $guess = 0.1 )

public static

#
ISPMT( )
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

public static

#
MIRR( mixed $values, mixed $finance_rate, mixed $reinvestment_rate )

public static
float

#
NOMINAL( float $effect_rate = 0, integer $npery = 0 )
NOMINAL
Returns the nominal interest rate given the effective rate and the number of
compounding payments per year.
Parameters
 $effect_rate
 Effective interest rate
 $npery
 Number of compounding payments per year
Returns
float float

public static
float

#
NPER( float $rate = 0, integer $pmt = 0, float $pv = 0, float $fv = 0, integer $type = 0 )
NPER
Returns the number of periods for a cash flow with constant periodic payments
(annuities), and interest rate.
Parameters
 $rate
 Interest rate per period
 $pmt
 Periodic payment (annuity)
 $pv
 Present Value
 $fv
 Future Value
 $type
 Payment type: 0 = at the end of each period, 1 = at the beginning of each period
Returns
float float

public static
float

#
NPV( )
NPV
Returns the Net Present Value of a cash flow series given a discount
rate.
Returns
float float

public static
float

#
PMT( float $rate = 0, integer $nper = 0, float $pv = 0, float $fv = 0, integer $type = 0 )
PMT
Returns the constant payment (annuity) for a cash flow with a constant
interest rate.
Parameters
 $rate
 Interest rate per period
 $nper
 Number of periods
 $pv
 Present Value
 $fv
 Future Value
 $type
 Payment type: 0 = at the end of each period, 1 = at the beginning of each period
Returns
float float

public static
float

#
PPMT( float $rate, integer $per, integer $nper, float $pv, float $fv = 0, integer $type = 0 )
PPMT
Returns the interest payment for a given period for an investment based on
periodic, constant payments and a constant interest rate.
Parameters
 $rate
 Interest rate per period
 $per
 Period for which we want to find the interest
 $nper
 Number of periods
 $pv
 Present Value
 $fv
 Future Value
 $type
 Payment type: 0 = at the end of each period, 1 = at the beginning of each period
Returns
float float

public static

#
PRICE( mixed $settlement, mixed $maturity, mixed $rate, mixed $yield, mixed $redemption, mixed $frequency, mixed $basis = 0 )

public static
float

#
PRICEDISC( mixed $settlement, mixed $maturity, integer $discount, integer $redemption, integer $basis = 0 )
PRICEDISC
Returns the price per $100 face value of a discounted security.
Parameters
 $settlement
 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
 The security's maturity date. The maturity date is the date when the security
expires.
 $discount
 The security's discount rate.
 $redemption
 The security's redemption value per $100 face value.
 $basis
 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
Returns
float float

public static
float

#
PRICEMAT( mixed $settlement, mixed $maturity, mixed $issue, integer $rate, integer $yield, integer $basis = 0 )
PRICEMAT
Returns the price per $100 face value of a security that pays interest at
maturity.
Parameters
 $settlement
 The security's settlement date. The security's settlement date is the date after
the issue date when the security is traded to the buyer.
 $maturity
 The security's maturity date. The maturity date is the date when the security
expires.
 $issue
 The security's issue date.
 $rate
 The security's interest rate at date of issue.
 $yield
 The security's annual yield.
 $basis
 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
Returns
float float

public static
float

#
PV( float $rate = 0, integer $nper = 0, float $pmt = 0, float $fv = 0, integer $type = 0 )
PV
Returns the Present Value of a cash flow with constant payments and interest
rate (annuities).
Parameters
 $rate
 Interest rate per period
 $nper
 Number of periods
 $pmt
 Periodic payment (annuity)
 $fv
 Future Value
 $type
 Payment type: 0 = at the end of each period, 1 = at the beginning of each period
Returns
float float

public static

#
RATE( mixed $nper, mixed $pmt, mixed $pv, mixed $fv = 0.0, mixed $type = 0, mixed $guess = 0.1 )

public static
float

#
RECEIVED( mixed $settlement, mixed $maturity, integer $investment, integer $discount, integer $basis = 0 )
RECEIVED
Returns the price per $100 face value of a discounted security.
Parameters
 $settlement
 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
 The security's maturity date. The maturity date is the date when the security
expires.
 $investment
 The amount invested in the security.
 $discount
 The security's discount rate.
 $basis
 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
Returns
float float

public static
float

#
SLN( cost $cost, salvage $salvage, life $life )
SLN
Returns the straightline depreciation of an asset for one period
Parameters
 $cost
 cost of the asset
 $salvage
 at the end of the depreciation
 $life
 of periods over which the asset is depreciated
Returns
float float

public static
float

#
SYD( cost $cost, salvage $salvage, life $life, period $period )
SYD
Returns the sumofyears' digits depreciation of an asset for a specified
period.
Parameters
 $cost
 cost of the asset
 $salvage
 at the end of the depreciation
 $life
 of periods over which the asset is depreciated
 $period
 Period
Returns
float float

public static
float

#
TBILLEQ( mixed $settlement, mixed $maturity, integer $discount )
TBILLEQ
Returns the bondequivalent yield for a Treasury bill.
Parameters
 $settlement
 The Treasury bill's settlement date. The Treasury bill's settlement date is the
date after the issue date when the Treasury bill is traded to the buyer.
 $maturity
 The Treasury bill's maturity date. The maturity date is the date when the
Treasury bill expires.
 $discount
 The Treasury bill's discount rate.
Returns
float float

public static
float

#
TBILLPRICE( mixed $settlement, mixed $maturity, integer $discount )
TBILLPRICE
Returns the yield for a Treasury bill.
Parameters
 $settlement
 The Treasury bill's settlement date. The Treasury bill's settlement date is the
date after the issue date when the Treasury bill is traded to the buyer.
 $maturity
 The Treasury bill's maturity date. The maturity date is the date when the
Treasury bill expires.
 $discount
 The Treasury bill's discount rate.
Returns
float float

public static
float

#
TBILLYIELD( mixed $settlement, mixed $maturity, integer $price )
TBILLYIELD
Returns the yield for a Treasury bill.
Parameters
 $settlement
 The Treasury bill's settlement date. The Treasury bill's settlement date is the
date after the issue date when the Treasury bill is traded to the buyer.
 $maturity
 The Treasury bill's maturity date. The maturity date is the date when the
Treasury bill expires.
 $price
 The Treasury bill's price per $100 face value.
Returns
float float

public static

#
XIRR( mixed $values, mixed $dates, mixed $guess = 0.1 )

public 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)
Parameters
 $rate
 The discount rate to apply to the cash flows.
 $values
 float $values A series of cash flows that corresponds to a schedule of payments
in dates. The first payment is optional and corresponds to a cost or payment
that occurs at the beginning of the investment. If the first value is a cost or
payment, it must be a negative value. All succeeding payments are discounted
based on a 365day year. The series of values must contain at least one positive
value and one negative value.
 $dates
 mixed $dates A schedule of payment dates that corresponds to the cash flow
payments. The first payment date indicates the beginning of the schedule of
payments. All other dates must be later than this date, but they may occur in
any order.
Returns
float float

public static
float

#
YIELDDISC( mixed $settlement, mixed $maturity, integer $price, integer $redemption, integer $basis = 0 )
YIELDDISC
Returns the annual yield of a security that pays interest at maturity.
Parameters
 $settlement
 The security's settlement date. The security's settlement date is the date after
the issue date when the security is traded to the buyer.
 $maturity
 The security's maturity date. The maturity date is the date when the security
expires.
 $price
 The security's price per $100 face value.
 $redemption
 The security's redemption value per $100 face value.
 $basis
 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
Returns
float float

public static
float

#
YIELDMAT( mixed $settlement, mixed $maturity, mixed $issue, integer $rate, integer $price, integer $basis = 0 )
YIELDMAT
Returns the annual yield of a security that pays interest at maturity.
Parameters
 $settlement
 The security's settlement date. The security's settlement date is the date after
the issue date when the security is traded to the buyer.
 $maturity
 The security's maturity date. The maturity date is the date when the security
expires.
 $issue
 The security's issue date.
 $rate
 The security's interest rate at date of issue.
 $price
 The security's price per $100 face value.
 $basis
 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
Returns
float float
