deepcalc
DocsFinancial

Financial

Interest, cash flow, depreciation and valuation.

FunctionWhat it does
ACCRINT Accrued interest for a security paying periodic interest.
ACCRINTM Accrued interest for a security paying at maturity.
AMORDEGRC Depreciation per period, French accounting, degressive.
AMORLINC Depreciation per period, French accounting, linear.
COUPDAYBS Days from coupon period start to settlement.
COUPDAYS Days in the coupon period containing settlement.
COUPDAYSNC Days from settlement to the next coupon date.
COUPNCD Next coupon date after settlement.
COUPNUM Number of coupons between settlement and maturity.
COUPPCD Previous coupon date before settlement.
CUMIPMT Returns cumulative interest paid on loan.
CUMPRINC Returns cumulative principal paid on loan.
DB Returns fixed-declining balance depreciation.
DDB Returns double-declining balance depreciation.
DISC Discount rate of a security.
DOLLARDE Converts fractional dollar to decimal.
DOLLARFR Converts decimal dollar to fractional.
DURATION Returns the Macaulay duration of a security.
EFFECT Returns effective annual interest rate.
EUROCONVERT Converts between currencies with a fixed euro rate.
FV Returns future value of an investment.
FVSCHEDULE Future value under a schedule of compound rates.
INTRATE Interest rate of a fully invested security.
IPMT Returns interest payment for a period.
IRR Calculates internal rate of return.
ISPMT Returns interest for even-principal payment.
MDURATION Modified Macauley duration.
MIRR Returns modified internal rate of return.
NOMINAL Returns annual nominal interest rate.
NPER Returns number of periods for investment.
NPV Calculates net present value of investment.
ODDFPRICE Returns the price of a security with an odd first period.
ODDFYIELD Yield of a security with an odd first period.
ODDLPRICE Price of a security with an odd last period.
ODDLYIELD Yield of a security with an odd last period.
PDURATION Returns periods to reach target value.
PMT Returns periodic payment for an annuity.
PPMT Returns principal payment for a period.
PRICE Returns the price per $100 face value of a security paying periodic interest.
PRICEDISC Price of a discounted security.
PRICEMAT Price of a security paying interest at maturity.
PV Returns present value of an investment.
RATE Returns interest rate per period.
RECEIVED Amount received at maturity for a fully invested security.
RRI Returns equivalent interest rate for growth.
SLN Returns straight-line depreciation per period.
SYD Returns sum-of-years-digits depreciation.
TBILLEQ Returns bond-equivalent yield for treasury bill.
TBILLPRICE Returns price per $100 for treasury bill.
TBILLYIELD Returns yield for a treasury bill.
VDB Depreciation over a period, declining balance with switch.
XIRR Returns internal rate for irregular cash flows.
XNPV Returns net present value for irregular cash flows.
YIELD Returns the yield of a security paying periodic interest.
YIELDDISC Annual yield of a discounted security.
YIELDMAT Annual yield of a security paying interest at maturity.