SpreadJS 14
Formula Reference / Formula Functions / Financial Functions
In This Topic
    Financial Functions
    In This Topic

    Spread provides the following financial functions, listed alphabetically.

    Function Description
    ACCRINT This function calculates the accrued interest for a security that pays periodic interest.
    ACCRINTM This function calculates the accrued interest at maturity for a security that pays periodic interest.
    AMORDEGRC This function returns the depreciation for an accounting period, taking into consideration prorated depreciation, and applies a depreciation coefficient in the calculation based on the life of the assets.
    AMORLINC This function calculates the depreciation for an accounting period, taking into account prorated depreciation.
    COUPDAYBS This function calculates the number of days from the beginning of the coupon period to the settlement date.
    COUPDAYS This function returns the number of days in the coupon period that contains the settlement date.
    COUPDAYSNC This function calculates the number of days from the settlement date to the next coupon date.
    COUPNCD This function returns a date number of the next coupon date after the settlement date.
    COUPNUM This function returns the number of coupons due between the settlement date and maturity date.
    COUPPCD This function returns a date number of the previous coupon date before the settlement date.
    CUMIPMT This function returns the cumulative interest paid on a loan between the starting and ending periods.
    CUMPRINC This function returns the cumulative principal paid on a loan between the start and end periods.
    DB This function calculates the depreciation of an asset for a specified period using the fixed‑declining balance method.
    DDB This function calculates the depreciation of an asset for a specified period using the double-declining balance method or another method you specify.
    DISC This function calculates the discount rate for a security.
    DOLLARDE This function converts a fraction dollar price to a decimal dollar price.
    DOLLARFR This function converts a decimal number dollar price to a fraction dollar price.
    DURATION This function returns the Macaulay duration for an assumed par value of $100.
    EFFECT This function calculates the effective annual interest rate for a given nominal annual interest rate and the number of compounding periods per year.
    FV This function returns the future value of an investment based on a present value, periodic payments, and a specified interest rate.
    FVSCHEDULE This function returns the future value of an initial principal after applying a series of compound interest rates. Calculate future value of an investment with a variable or adjustable rate.
    INTRATE This function calculates the interest rate for a fully invested security.
    IPMT This function calculates the payment of interest on a loan.
    IRR This function returns the internal rate of return for a series of cash flows represented by the numbers in an array.
    ISPMT This function calculates the interest paid during a specific period of an investment.
    MDURATION This function calculates the modified Macaulay duration of a security with an assumed par value of $100.
    MIRR This function returns the modified internal rate of return for a series of periodic cash flows.
    NOMINAL This function returns the nominal annual interest rate for a given effective rate and number of compounding periods per year.
    NPER This function returns the number of periods for an investment based on a present value, future value, periodic payments, and a specified interest rate.
    NPV This function calculates the net present value of an investment by using a discount rate and a series of future payments and income.
    ODDFPRICE This function calculates the price per $100 face value of a security with an odd first period.
    ODDFYIELD This function calculates the yield of a security with an odd first period.
    ODDLPRICE This function calculates the price per $100 face value of a security with an odd last coupon period.
    ODDLYIELD This function calculates the yield of a security with an odd last period.
    PDURATION This function returns the number of periods required by an investment to reach a specified value.
    PMT This function returns the payment amount for a loan given the present value, specified interest rate, and number of terms.
    PPMT This function returns the amount of payment of principal for a loan given the present value, specified interest rate, and number of terms.
    PRICE This function calculates the price per $100 face value of a periodic interest security.
    PRICEDISC This function returns the price per $100 face value of a discounted security.
    PRICEMAT This function returns the price at maturity per $100 face value of a security that pays interest.
    PV This function returns the present value of an investment based on the interest rate, number and amount of periodic payments, and future value. The present value is the total amount that a series of future payments is worth now.
    RATE This function returns the interest rate per period of an annuity.
    RECEIVED This function returns the amount received at maturity for a fully invested security.
    RRI This function returns an equivalent interest rate for the growth of an investment.
    SLN This function returns the straight-line depreciation of an asset for one period.
    SYD This function returns the sum-of-years' digits depreciation of an asset for a specified period.
    TBILLEQ This function returns the equivalent yield for a Treasury bill (or T-bill).
    TBILLPRICE This function returns the price per $100 face value for a Treasury bill (or T-bill).
    TBILLYIELD This function returns the yield for a Treasury bill (or T-bill).
    VDB This function returns the depreciation of an asset for any period you specify using the variable declining balance method.
    XIRR This function calculates the internal rate of return for a schedule of cash flows that may not be periodic.
    XNPV This function calculates the net present value for a schedule of cash flows that may not be periodic.
    YIELD This function calculates the yield on a security that pays periodic interest.
    YIELDDISC This function calculates the annual yield for a discounted security.
    YIELDMAT This function calculates the annual yield of a security that pays interest at maturity.