|
Returns the accrued interest for a security that pays interest at maturity.
|
ACCRINTM(issue, settlement, rate, par, [basis])
|
COUPDAYBS
|
|
Returns the number of days from the beginning of a coupon period until its settlement date.
|
COUPDAYBS(settlement, maturity, frequency, [basis])
|
COUPNCD
|
|
Returns the next coupon date after the settlement date.
|
COUPNCD(settlement, maturity, frequency, [basis])
|
COUPNUM
|
|
Returns the number of coupons payable between the settlement date and maturity date.
|
COUPNUM(settlement, maturity, frequency, [basis])
|
COUPPCD
|
|
Returns the previous coupon date before the settlement date.
|
COUPPCD(settlement, maturity, frequency, [basis])
|
CUMIPMT
|
|
Returns the cumulative interest paid on a loan between two periods.
|
CUMIPMT(rate, nper, pv, start_period, end_period, type)
|
CUMPRINC
|
|
Returns the cumulative principal paid on a loan between two periods.
|
CUMPRINC(rate, nper, pv, start_period, end_period, type)
|
DB
|
|
Returns the depreciation of an asset for a specified period using the fixed-declining balance method.
|
DB(cost, salvage, life, period, [month])
|
DDB
|
|
Returns the depreciation of an asset for a specified period using the double-declining balance method or some other method you specify.
|
DDB(cost, salvage, life, period, [factor])
|
DISC
|
|
Returns the discount rate for a security.
|
DISC(settlement, maturity, pr, redemption, [basis])
|
DOLLARDE
|
|
Converts a dollar price expressed as a fraction into a dollar price expressed as a decimal number.
|
DOLLARDE(fractional_dollar, fraction)
|
DOLLARFR
|
|
Converts a dollar price expressed as a decimal number into a dollar price expressed as a fraction.
|
DOLLARFR(decimal_dollar, fraction)
|
FVSCHEDULE
|
|
Returns the future value of an initial principal after applying a series of compound interest rates.
|
FVSCHEDULE(principal, schedule)
|
EFFECT
|
|
Returns the effective annual interest rate.
|
EFFECT(nominal_rate, npery)
|
FV
|
|
Calculates the future value of an investment based on a constant interest rate.
|
FV(rate,nper,pmt,[pv],[type])
|
INTRATE
|
|
Returns the interest rate for a fully invested security.
|
INTRATE(settlement, maturity, investment, redemption, [basis])
|
IPMT
|
|
Returns the interest payment for a given period for an investment based on periodic constant payments and a constant interest rate.
|
IPMT(rate, per, nper, pv, [fv], [type])
|
IRR
|
|
Calculates the internal rate of return for a series of cash flows.
|
IRR(values, [guess])
|
ISPMT
|
|
Calculates the interest paid during a specific period of a loan (or investment).
|
ISPMT(rate, per, nper, pv)
|
MIRR
|
|
Returns the modified internal rate of return for a series of periodic cash flows.
|
MIRR(values, finance_rate, reinvest_rate)
|
NOMINAL
|
|
Returns the annual nominal interest rate.
|
NOMINAL(effect_rate, npery)
|
NPER
|
|
Returns the number of periods for an investment based on periodic constant payments and a constant interest rate.
|
NPER(rate,pmt,pv,[fv],[type])
|
NPV
|
|
Calculates the net present value of an investment based on a discount rate and a series of future payments and income.
|
NPV(rate,value1,[value2],…)
|
PDURATION
|
|
Returns the number of periods required by an investment to reach a specified value.
|
PDURATION(rate, pv, fv)
|
PMT
|
|
Calculates the payment for a loan based on constant payments and a constant interest rate.
|
PMT(rate, nper, pv, [fv], [type])
|
PPMT
|
|
Returns the payment on the principal for a given period for an investment based on periodic constant payments and a constant interest rate.
|
PPMT(rate, per, nper, pv, [fv], [type])
|
PRICE
|
|
Returns the price per $100 face value of a security that pays periodic interest.
|
PRICE(settlement, maturity, rate, yld, redemption, frequency, [basis])
|
PRICEDISC
|
|
Returns the price per $100 face value of a discounted security.
|
PRICEDISC(settlement, maturity, discount, redemption, [basis])
|
PV
|
|
Calculates the present value of a loan or an investment based on a constant interest rate.
|
PV(rate, nper, pmt, [fv], [type])
|
RATE
|
|
Returns the interest rate per period of an annuity.
|
RATE(nper, pmt, pv, [fv], [type], [guess])
|
RECEIVED
|
|
Returns the amount received at maturity for a fully invested security.
|
RECEIVED(settlement, maturity, investment, discount, [basis])
|
RRI
|
|
Returns an equivalent interest rate for the growth of an investment.
|
RRI(nper, pv, fv)
|
SLN
|
|
Returns the straight-line depreciation of an asset for one period.
|
SLN(cost, salvage, life)
|
SYD
|
|
Returns the sum-of-years’ digits depreciation of an asset for a specified period.
|
SYD(cost, salvage, life, per)
|
TBILLEQ
|
|
Returns the bond-equivalent yield for a Treasury bill.
|
TBILLEQ(settlement, maturity, discount)
|
TBILLPRICE
|
|
Returns the price per $100 face value for a Treasury bill.
|
TBILLPRICE(settlement, maturity, discount)
|
TBILLYIELD
|
|
Returns the yield for a Treasury bill.
|
TBILLYIELD(settlement, maturity, pr)
|
VDB
|
|
Returns the depreciation of an asset for a specified or partial period using a declining balance method.
|
VDB(cost, salvage, life, start_period, end_period, [factor], [no_switch]).
|
XIRR
|
|
Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic.
|
XIRR(values, dates, [guess])
|
XNPV
|
|
Returns the net present value for a schedule of cash flows that is not necessarily periodic.
|
XNPV(rate, values, dates)
|
YIELD
|
|
Returns the yield on a security that pays periodic interest.
|
YIELD(settlement, maturity, rate, pr, redemption, frequency, [basis])
|
YIELDDISC
|
|
Returns the annual yield for a discounted security.
|
YIELDDISC(settlement, maturity, pr, redemption, [basis])
|
|