# financial functions

interest, cash flow, depreciation and valuation.

56 functions.

- [ACCRINT](https://deepcalc.com/functions/accrint.md) — accrued interest for a security paying periodic interest
- [ACCRINTM](https://deepcalc.com/functions/accrintm.md) — accrued interest for a security paying at maturity
- [AMORDEGRC](https://deepcalc.com/functions/amordegrc.md) — depreciation per period, French accounting, degressive
- [AMORLINC](https://deepcalc.com/functions/amorlinc.md) — depreciation per period, French accounting, linear
- [COUPDAYBS](https://deepcalc.com/functions/coupdaybs.md) — days from coupon period start to settlement
- [COUPDAYS](https://deepcalc.com/functions/coupdays.md) — days in the coupon period containing settlement
- [COUPDAYSNC](https://deepcalc.com/functions/coupdaysnc.md) — days from settlement to the next coupon date
- [COUPNCD](https://deepcalc.com/functions/coupncd.md) — next coupon date after settlement
- [COUPNUM](https://deepcalc.com/functions/coupnum.md) — number of coupons between settlement and maturity
- [COUPPCD](https://deepcalc.com/functions/couppcd.md) — previous coupon date before settlement
- [CUMIPMT](https://deepcalc.com/functions/cumipmt.md) — returns cumulative interest paid on loan
- [CUMPRINC](https://deepcalc.com/functions/cumprinc.md) — returns cumulative principal paid on loan
- [DB](https://deepcalc.com/functions/db.md) — returns fixed-declining balance depreciation
- [DDB](https://deepcalc.com/functions/ddb.md) — returns double-declining balance depreciation
- [DISC](https://deepcalc.com/functions/disc.md) — discount rate of a security
- [DOLLARDE](https://deepcalc.com/functions/dollarde.md) — converts fractional dollar to decimal
- [DOLLARFR](https://deepcalc.com/functions/dollarfr.md) — converts decimal dollar to fractional
- [DURATION](https://deepcalc.com/functions/duration.md) — returns the Macaulay duration of a security
- [EFFECT](https://deepcalc.com/functions/effect.md) — returns effective annual interest rate
- [EUROCONVERT](https://deepcalc.com/functions/euroconvert.md) — converts between currencies with a fixed euro rate
- [FV](https://deepcalc.com/functions/fv.md) — returns future value of an investment
- [FVSCHEDULE](https://deepcalc.com/functions/fvschedule.md) — future value under a schedule of compound rates
- [INTRATE](https://deepcalc.com/functions/intrate.md) — interest rate of a fully invested security
- [IPMT](https://deepcalc.com/functions/ipmt.md) — returns interest payment for a period
- [IRR](https://deepcalc.com/functions/irr.md) — calculates internal rate of return
- [ISPMT](https://deepcalc.com/functions/ispmt.md) — returns interest for even-principal payment
- [MDURATION](https://deepcalc.com/functions/mduration.md) — modified Macauley duration
- [MIRR](https://deepcalc.com/functions/mirr.md) — returns modified internal rate of return
- [NOMINAL](https://deepcalc.com/functions/nominal.md) — returns annual nominal interest rate
- [NPER](https://deepcalc.com/functions/nper.md) — returns number of periods for investment
- [NPV](https://deepcalc.com/functions/npv.md) — calculates net present value of investment
- [ODDFPRICE](https://deepcalc.com/functions/oddfprice.md) — returns the price of a security with an odd first period
- [ODDFYIELD](https://deepcalc.com/functions/oddfyield.md) — yield of a security with an odd first period
- [ODDLPRICE](https://deepcalc.com/functions/oddlprice.md) — price of a security with an odd last period
- [ODDLYIELD](https://deepcalc.com/functions/oddlyield.md) — yield of a security with an odd last period
- [PDURATION](https://deepcalc.com/functions/pduration.md) — returns periods to reach target value
- [PMT](https://deepcalc.com/functions/pmt.md) — returns periodic payment for an annuity
- [PPMT](https://deepcalc.com/functions/ppmt.md) — returns principal payment for a period
- [PRICE](https://deepcalc.com/functions/price.md) — returns the price per $100 face value of a security paying periodic interest
- [PRICEDISC](https://deepcalc.com/functions/pricedisc.md) — price of a discounted security
- [PRICEMAT](https://deepcalc.com/functions/pricemat.md) — price of a security paying interest at maturity
- [PV](https://deepcalc.com/functions/pv.md) — returns present value of an investment
- [RATE](https://deepcalc.com/functions/rate.md) — returns interest rate per period
- [RECEIVED](https://deepcalc.com/functions/received.md) — amount received at maturity for a fully invested security
- [RRI](https://deepcalc.com/functions/rri.md) — returns equivalent interest rate for growth
- [SLN](https://deepcalc.com/functions/sln.md) — returns straight-line depreciation per period
- [SYD](https://deepcalc.com/functions/syd.md) — returns sum-of-years-digits depreciation
- [TBILLEQ](https://deepcalc.com/functions/tbilleq.md) — returns bond-equivalent yield for treasury bill
- [TBILLPRICE](https://deepcalc.com/functions/tbillprice.md) — returns price per $100 for treasury bill
- [TBILLYIELD](https://deepcalc.com/functions/tbillyield.md) — returns yield for a treasury bill
- [VDB](https://deepcalc.com/functions/vdb.md) — depreciation over a period, declining balance with switch
- [XIRR](https://deepcalc.com/functions/xirr.md) — returns internal rate for irregular cash flows
- [XNPV](https://deepcalc.com/functions/xnpv.md) — returns net present value for irregular cash flows
- [YIELD](https://deepcalc.com/functions/yield.md) — returns the yield of a security paying periodic interest
- [YIELDDISC](https://deepcalc.com/functions/yielddisc.md) — annual yield of a discounted security
- [YIELDMAT](https://deepcalc.com/functions/yieldmat.md) — annual yield of a security paying interest at maturity

## navigate

- [function index](https://deepcalc.com/functions.md)
- [error values](https://deepcalc.com/errors.md) · [concepts](https://deepcalc.com/concepts.md) · [limits](https://deepcalc.com/limits.md)

source: https://deepcalc.com/functions/financial-functions