# financial functions

Interest, cash flow, depreciation and valuation.

56 functions.

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

## navigate

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

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