Spread.NET 17 Formula Reference
Formula Overview / Functions in a Formula / Categories of Functions / Financial Functions
In This Topic
    Financial Functions
    In This Topic

    The functions that relate to financial calculations such as interest calculations are:

    ACCRINT ACCRINTM AMORDEGRC AMORLINC
    COUPDAYS COUPDAYBS COUPDAYSNC COUPNCD
    COUPNUM COUPPCD CUMIPMT CUMPRINC
    DB DDB DISC DOLLAR
    DOLLARDE DOLLARFR DURATION EFFECT
    EUROCONVERT FV FVSCHEDULE INTRATE
    IPMT IRR ISPMT MDURATION
    MIRR NOMINAL NPER NPV
    ODDFPRICE ODDFYIELD ODDLPRICE ODDLYIELD
    PDURATION PMT PPMT PRICE
    PRICEDISC PRICEMAT PV RATE
    RECEIVED RRI SLN SYD
    TBILLEQ TBILLPRICE TBILLYIELD VDB
    XIRR XNPV YIELD YIELDDISC
    YIELDMAT      

    For the financial functions that use it, refer to Day Count Basis.

    Return to the list of Categories of Functions.

    For the arguments of some of these functions and for the results of some of these functions, money paid out is represented by negative numbers and money you receive is represented by positive numbers. How the currency values are displayed depends upon how you set up the cell type and the format settings.