accrint

Returns accrued interest on recurring interest-bearing securities

double

double accrint(Object issue, Object firstIneterest, Object settlement, double rate,double par, double frequency, double basis)

accrintm

Returns accrued interest on bonds that pay interest on the due date

double

accrintm(Object issue, Object maturity, double rate, double par,double basis)

amordegrc

Returns the depreciation value for each accounting period using the depreciation factor

double

amordegrc(double cost, Object date_purchased, Object first_period,

double salvage, int period, double rate, intbasis)

amorlinc

Returns the depreciation value for each billing period

double

amorlinc(double cost, Object date_purchased, Object first_period,

double salvage, int period, double rate, int basis)

coupdaybs

Returns the number of days from the beginning of the coupon period to the closing date

double

coupdaybs(Object settlement, Object maturity, double frequency, int basis)

coupdays

Returns the number of days during the offer period, including the settlement date

int

coupdays(Object settlement, Object maturity, double frequency, double basis)

coupdaysnc

Returns the number of days from the transaction date to the next coupon date

double

coupdaysnc(Object settlement, Object maturity, double frequency, double basis)

coupncd

Returns the next interest payment date after the transaction date

date

coupncd(Object settlement, Object maturity, double frequency, double basis)

coupnum

Returns the interest payable between the transaction date and the due date

int

coupnum(Object settlement, Object maturity, double frequency, double basis)

couppcd

Returns the previous coupon date before the transaction date

date

couppcd(Object settlement, Object maturity, double frequency, double basis)

cumipmt

Returns the accrued interest paid between two payment periods

double

cumipmt(double rate, int nper, double pv, double start,double end, int type)

cumprinc

Returns the principal paid for the loan between two payment periods

double

cumprinc(double rate, int nper, double pv, double start, double end,int type)

financialDb

Use the declining fixed balance method to return the depreciation value of an asset over a given period

double

financialDb

(double cost, double salvage, double life, double period, double month)

ddb

Returns the depreciation of an asset over a given period using double-declining balance or other specified methods

double 

ddb(double cost, double salvage, double life, double period, double factor)

disc

Return discount rate of bonds

double

disc(Object settlement, Object maturity, double pr, double redemption, double basis)

duration

Returns the annual maturity of a bond that pays interest on a regular basis

double

duration(Object settlement, Object maturity, double coupon, double yld, double frequency, double basis)

effect

Return effective annual interest rate

double

effect(double nominal_rate, double npery)

fv

Return the future value of an investment

double

fv(double rate, int nper, double pmt, double pv, int type)

fvschedule

Returns the future value of the initial principal calculated using a series of compound interest rates

double

fvschedule(double principal, Object scheduleObj)

intrate

Return the interest rate of fully invested bonds

double

intrate(Object settlement, Object maturity, double investment,double redemption, double basis)

ipmt

Returns the interest paid on a given period of investment

double

ipmt(double rate, int per, int nper, double pv, double fv, int type)

ispmt

Calculate the interest paid during a specific investment period

double

ispmt(double rate, int per, int nper, double pv)

mduration

Returns Macauley's correction deadline for a security with a face value of ¥100

double

mduration(Object settlement, Object maturity, double coupon, double yld,double frequency, double basis)

mirr

Returns the internal rate of return for positive and negative cash flows calculated at different rates

String

mirr(Object valuesObj, double finance_rate, double reinvest_rate)

nominal

Returns the annual nominal interest rate

double

nominal(double rate, double npery)

nper

Return period of investment

double

nper(double rate, double pmt, double pv, double fv, int type)

npv

Returns the net present value of investments based on a series of regular cash flow and discount rates

double 

npv(double rate, Object valuesObj)

pmt

Returns the amount of periodic payments for an annuity

double 

pmt(double rate, int nper, double pv, double fv, int type)

ppmt

Return the principal amount of an investment repayment within a given period

double

ppmt(double rate, int per, int nper, double pv, double fv, int type)

price

Returns the current price of each bond with a face value of ¥100 and regular interest payments

double

price(Object settlement, Object maturity, double rate, double yield,double redemption, double frequency, int basis)

pricedisc

Returns the current price of each discounted bond with a face value of ¥100

double

pricedisc(Object settlement, Object maturity, double discount,double redemption, double basis)

pricemat

Returns the current price of each bond with a face value of ¥100 and interest paid on the due date

double

pricemat(Object settlement, Object maturity, Object issue, double rate,double yield, double basis)

pv

Return the present value of the investment

double

pv(double rate, int nper, double pmt, double fv, int type)

received

Returns the amount of a fully-invested bond that was recovered on the due date

double

received(Object settlement, Object maturity, double investment, double discount, double basis)

sln

Returns per-period linear depreciation of fixed assets

double

sln(double cost, double salvage, int life)

syd

The depreciation of the total number of years of assets in a particular period

double

syd(double cost, double salvage, double life, double per)

tbilleq

Return of Treasury Bond Equivalent Bonds

double

tbilleq(Object settlement, Object maturity, double discount)

tbillprice

Returns the price of a Treasury bill with a face value of ¥100

double

tbillprice(Object settlement, Object maturity, double discount)

tbillyield

Returns on yield of Treasury bills

double

tbillyield(Object settlement, Object maturity, double par)

vdb

Use the declining balance method to return the depreciation value of an asset in a given period or part of the period

double

vdb(double cost, double salvage, double life, double start_period,double end_period, double factor, boolean flag)

xnpv

Returns the net present value of a set of cash flows. These cash flows do not necessarily occur on a regular basis

double

xnpv(double rate, Object valuesObj, Object datesObj)

yielddisc

Returns annual returns on discounted bonds; for example, short-term treasury bills

double

yielddisc(Object settlement, Object maturity, double pr, double redemption,double basis)

yieldmat

Returns annual returns on bonds that pay interest on the due date

double

yieldmat(Object settlement, Object maturity, Object issue, double rate, double pr, double basis)