financial

Accrint

Returns the accrued interest of a security with periodic payments. Function signature ACCRINT(datestart: String, datefirstpayment: String, dateend: String, rate: Number, redemption: Number, frequency: Number, basis: String = us_nasd) => Number ...

Updated on : 19 May 2022

Amorlinc

Returns the depreciation for an accounting period. If the asset was purchased during the period, returns the prorated depreciation. This provision is for users of the French accounting system. Function signature AMORLINC(cost: Number, purchased...

Updated on : 19 May 2022

Coupdaybs

Calculates how many days there are until the given settlement days from the first interest payment/coupon. Function signature COUPDAYBS(settlement: String, maturity: String, frequency: Number, basis: String = us_nasd) => Number Examples ...

Updated on : 19 May 2022

Coupdays

Given a settlement date, calculates how many days are in the containing interest payment/coupon period. Function signature COUPDAYS(settlement: String, maturity: String, frequency: Number, basis: String = us_nasd) => Number Examples d...

Updated on : 19 May 2022

Coupdaysnc

Calculates how many days are between the given settlement date and the next interest payment/coupon. Function signature COUPDAYSNC(settlement: String, maturity: String, frequency: Number, basis: String = us_nasd) => Number Examples da...

Updated on : 19 May 2022

Coupncd

Calculates the next interest payment/coupon date after the given settlement date. Function signature COUPNCD(settlement: String, maturity: String, frequency: Number, basis: String = us_nasd) => String Examples date1 = "2010-02-01T13:0...

Updated on : 19 May 2022

Coupnum

Calculates the number of interest payments/coupons between the given settlement data and the investment's maturity date. Function signature COUPNUM(settlement: String, maturity: String, frequency: Number, basis: String = us_nasd) => Number ...

Updated on : 19 May 2022

Couppcd

Calculates the last interest payment/coupon date prior to the settlement date. Function signature COUPPCD(settlement: String, maturity: String, frequency: Number, basis: String = us_nasd) => String Examples date1 = "2010-02-01T13:06:1...

Updated on : 19 May 2022

Cumipmt

Calculates the cumulative interest for an investment over multiple payment periods. This is done based on a constant interest rate and periodic payments with constant amounts. Function signature CUMIPMT(rate: Number, numberofperiods: Number, pr...

Updated on : 19 May 2022

Cumprinc

Calculates the cumulative principle paid on an investment over multiple payment periods. This is done based on a constant interest rate and periodic payments with constant amounts. Function signature CUMPRINC(rate: Number, numberofperiods: Numb...

Updated on : 19 May 2022

Currency_decimal

Given a decimal fraction representation of a number and the fractional unit used, returns a regular decimal number. For example, 213.03 might mean 213 and 3/8 or 213 and 3/32, depending on the source data. Function signature CURRENCY_DECIMAL(...

Updated on : 19 May 2022

Currency_functional

Given a decimal number and a fractional unit, returns a number in the decimal fraction format. Function signature CURRENCY_FRACTIONAL(decimalprice: Number, unit: Number) => Number Examples

Updated on : 19 May 2022

Declining_balance

Calculates an assets depreciation over a period of time utilising the arithmetic declining balance method. Function signature DECLINING_BALANCE(cost: Number, salvage: Number, life: Number, period: Number, month: Number = 12) => Number Ex...

Updated on : 19 May 2022

Dics

Calculates a security's discount rate based on price. Function signature DISC(settlement: String, maturity: String, price: Number, redemption: Number, basis: String = us_nasd) => Number Examples date1 = "2010-01-02T13:06:15+03:00" dat...

Updated on : 19 May 2022

Double_declining_balance

Calculates an assets depreciation over a period of time utilising the double-declining balance method. Function signature DOUBLE_DECLINING_BALANCE(cost: Number, salvage: Number, life: Number, period: Number, factor: Number = 2) => Number ...

Updated on : 19 May 2022

Effect

Calculates annual effective interest rate when provided with the nominal rate and the number of compounding periods per year. Function signature EFFECT(nominalrate: Number, periodsperyear: Number) => Number Examples

Updated on : 19 May 2022

Future_value_schedule

Calculates a given principal's future value using a specified collection of potentially varying interest rates. Function signature FUTURE_VALUE_SCHEDULE(principal: Number, rateschedule: Array) => Number Examples

Updated on : 19 May 2022

Future_value

Calculates an annuity investment's future value. This is done based on a constant interest rate and periodic payments of constant amounts. Function signature FUTURE_VALUE(rate: Number, periods: Number, paymentamount: Number, presentvalue: Numbe...

Updated on : 19 May 2022

Intrate

Calculates the effective interest rate when an investment is bought for one value and sold for another where no interest or dividends were generated by the investment. Function signature INTRATE(buydate: String, selldate: String, buyprice: Numb...

Updated on : 19 May 2022

Investment_duration

Calculates how many compounding periods are required for an investment with a given current value that appreciates at a given rate in order to reach a specified target value. Function signature INVESTMENT_DURATION(settlement: String, maturity: ...

Updated on : 19 May 2022

Investment_Mduration

Calculates the modified Macaulay duration of a security that pays periodic interest based on a given expected yield. Function signature INVESTMENT_MDURATION(settlement: String, maturity: String, rate: Number, yield: Number, frequency: Number, b...

Updated on : 19 May 2022

Investment_Pduration

Calculates how many periods an investment needs to grow to a given value at a given rate. Function signature INVESTMENT_PDURATION(rate: Number, presentvalue: Number, futurevalue: Number) => Number Examples

Updated on : 19 May 2022

IPMT

Calculates the cumulative interest payments on an investment. This is done based on a constant interest rate and periodic payments of constant amounts. Function signature IPMT(rate: Number, period: Number, numberofperiods: Number, presentvalue:...

Updated on : 19 May 2022

IRR

Calculates an investment's internal rate of return using a series of periodic cash flows. Function signature IRR(сashflowamounts: Array, rateguess: Number = 0.1) => Number Examples array1 = [-20000,-1000,9000,15000] array2 = [-100000,...

Updated on : 19 May 2022

ISPMT

Given a particular period, calculates an investment's interest paid. This is done based on a constant interest rate and periodic payments of constant amounts. Function signature ISPMT(rate: Number, period: Number, numberofperiods: Number, prese...

Updated on : 19 May 2022

Mirr

Given a series of periodic cash flows, and the difference between the interest rate paid on financing versus the return received on reinvested income, calculates the modified internal rate of return as a decimal number. Function signature MIRR(...

Updated on : 19 May 2022

Net_present_value

Calculates an investment's net present value using discount rate and a series of periodic cash flows. Function signature NET_PRESENT_VALUE(discountrate: Number, cashflows: Array) => Number Examples

Updated on : 19 May 2022

Nominal

Calculates the annual nominal interest using the number of compounding periods per year and the effective rate. Function signature NOMINAL(effectiverate: Number, periodsperyear: Number) => Number Examples

Updated on : 19 May 2022

NPER

Calculates how many payment periods are needed for an investment. This is done based on a constant interest rate and periodic payments of constant amounts. Function signature NPER(rate: Number, paymentamount: Number, presentvalue: Number, futur...

Updated on : 19 May 2022

PMT

Calculates an annuity investment's periodic payment. This is done based on a constant interest rate and periodic payments of constant amounts. Function signature PMT(rate: Number, numberofperiods: Number, presentvalue: Number, futurevalue: Numb...

Updated on : 19 May 2022

PPMT

Calculates an investment's payment on interest. This is done based on a constant interest rate and periodic payments of constant amounts. Function signature PPMT(rate: Number, period: Number, numberofperiods: Number, presentvalue: Number, futur...

Updated on : 19 May 2022

Present_value

Calculates an annuity investment's present value. This is done based on a constant interest rate and periodic payments of constant amounts. Function signature PRESENT_VALUE(rate: Number, periods: Number, paymentamount: Number, futurevalue: Numb...

Updated on : 19 May 2022

Price

For a security that pays periodic interest, given the expected yield, calculates the security's price. Function signature PRICE(settlement: String, maturity: String, rate: Number, yield: Number, redemption: Number, frequency: Number, basis: Str...

Updated on : 19 May 2022

Pricedisc

For a discount security (i.e. one that doesn't bear interest), given the expected yield, calculates the security's price. Function signature PRICEDISC(settlement: String, maturity: String, discount: Number, redemption: Number, basis: String = u...

Updated on : 19 May 2022

Pricemat

For a security that pays interest at maturity, given the expected yield, calculates the security's price. Function signature PRICEMAT(settlement: String, maturity: String, issue: String, rate: Number, yield: Number, basis: String = us_nasd) => ...

Updated on : 19 May 2022

Rate

Calculates an annuity investment's interest rate. This is done based on a constant interest rate and constant-rate periodic payments. Function signature RATE(numberofperiods: Number, paymentperperiod: Number, presentvalue: Number, futurevalue: ...

Updated on : 19 May 2022

Received

For a fixed-income security investment, given the purchase date, calculates the amount received at maturity. Function signature RECEIVED(settlement: String, maturity: String, investment: Number, discount: Number, basis: String = us_nasd) => Num...

Updated on : 19 May 2022

RRI

Given a number of periods and target value, calculates the interest rate an investment needs to reach that value. Function signature RRI(periods: Number, presentvalue: Number, futurevalue: Number) => Number Examples

Updated on : 19 May 2022

SLN

Calculates an asset's depreceiation over one period using the straigh-line method. Function signature SLN(cost: Number, salvage: Number, life: Number) => Number Examples

Updated on : 19 May 2022

SYD

Calculates an asset's depreciation using the sum of years digits method for a specified period. Function signature SYD(cost: Number, salvage: Number, life: Number, period: Number) => Number Examples

Updated on : 19 May 2022

TBillprice

Returns a US Treasury Bill's price based on discount rate. Function signature TBILLPRICE(settlement: String, maturity: String, discount: Number) => Number Examples

Updated on : 19 May 2022

TBillyield

Returns a US Treasury Bill's yield based on price. Function signature TBILLYIELD(settlement: String, maturity: String, price: Number) => Number Examples

Updated on : 19 May 2022

VDB

Calculates an asset's depreciation for a given period. Function signature VDB(cost: Number, salvage: Number, life: Number, startperiod: Number, endperiod: Number, factor: Number = 2, noswitch: Boolean) => Number Examples

Updated on : 19 May 2022

XIRR

Calculates an investment's internal rate of return, using a series of cash flows that are potentially irregular. Function signature XIRR(сashflowamounts: Array, сashflowdates: Array, rateguess: Number = 0.1) => Number Examples values1...

Updated on : 19 May 2022

XNPV

Calculates an investment's net present value, using a series of cash flows that are potentially irregular. Function signature XNPV(discount: Number, сashflowamounts: Array, сashflowdates: Array) => Number Examples cash1 = [1,2,3,4,5] ...

Updated on : 19 May 2022

Yielddisc

Given the price at which a discount (i.e. not bearing interest) security was bought, calculates its annual yield. Function signature YIELDDISC(settlement: String, maturity: String, price: Number, redemption: Number, basis: String = us_nasd) => ...

Updated on : 19 May 2022

Yieldmat

Given the price at which a security paying interest at maturity was bought, calculates its annual yield. Function signature YIELDMAT(settlement: String, maturity: String, issue: String, rate: Number, price: Number, basis: String = us_nasd) => N...

Updated on : 19 May 2022