Excel Formulas

Showing page 20 of 21
COUPDAYS
Financial

Returns the number of days in the coupon period that contains the settlement date

COUPDAYSNC
Financial

Returns the number of days from the settlement date to the next coupon date

COUPNCD
Financial

Returns the next coupon date after the settlement date

COUPNUM
Financial

Returns the number of coupons payable between the settlement date and maturity date

COUPPCD
Financial

Returns the previous coupon date before the settlement date

CUMIPMT
Financial

Returns the cumulative interest paid between two periods

CUMPRINC
Financial

Returns the cumulative principal paid between two periods

DB
Financial

Returns the depreciation of an asset using the declining balance method

DDB
Financial

Returns the depreciation of an asset using the double-declining balance method

DISC
Financial

Returns the discount rate for a security

DOLLARDE
Financial

Converts a dollar price expressed as a fraction into a decimal number

DOLLARFR
Financial

Converts a dollar price expressed as a decimal number into a fraction

DURATION
Financial

Returns the annual duration of a security with periodic interest payments

EFFECT
Financial

Returns the effective annual interest rate

FV
Financial

Returns the future value of an investment

FVSCHEDULE
Financial

Returns the future value of an initial principal after applying a series of compound interest rates

INTRATE
Financial

Returns the interest rate for a fully invested security

IPMT
Financial

Returns the interest payment for a given period for an investment

IRR
Financial

Returns the internal rate of return for a series of cash flows

ISPMT
Financial

Calculates the interest paid during a specific period of an investment

Page 20 of 21