Financial Functions

These functions are used to calculate financial logic like depreciation, accrued interest, annuities, rates of return and future values

  • Family: PQL
  • Library: Spreadsheet
  • ◉ This function can be used with the Solve plug-in

    • Function List

    ACCRINT

    ACCRINTM

    AMORDEGRC

    AMORLINC

    COUPDAYBS

    COUPDAYS

    COUPDAYSNC

    COUPNCD

    ◉

    COUPNUM

    COUPPCD

    ◉

    CUMIPMT

    ◉

    CUMPRINC

    ◉

    DB

    DDB

    DISC

    DOLLARDE

    DOLLARFR

    DURATION

    EFFECT

    FV

    ◉

    FVSCHEDULE

    INTRATE

    ◉

    IPMT

    ◉

    IRR

    ◉

    ISPMT

    MDURATION

    MIRR

    ◉

    NOMINAL

    NPER

    ◉

    NPV

    ◉

    ODDFPRICE

    ODDFYIELD

    ODDLPRICE

    ODDLYIELD

    EURO

    EUROCONVERT

    PDURATION

    PMT

    ◉

    PPMT

    ◉

    PRICE

    PRICEDISC

    PRICEMAT

    PV

    ◉

    RATE

    RECEIVED

    RRI

    SLN

    ◉

    SYD

    TBILLEQ

    TBILLPRICE

    TBILLYIELD

    VDB

    ◉

    XIRR

    ◉

    XNPV

    ◉

    YIELD

    YIELDDISC

    YIELDMAT