Microsoft® Excel® 2010 Formulas & Functions Inside Out

Financial Functions

Function	Description
ACCRINT	Returns the accrued interest for a security that pays periodic interest
ACCRINTM	Returns the accrued interest for a security that pays interest at maturity
AMORDEGRC	Returns the depreciation amount to apply to a billing cycle using a depreciation coefficient
AMORLINC	Calculates the linear depreciation amount for assets
COUPDAYBS	Returns the number of days from the beginning of the interest date to the settlement date
COUPDAYS	Returns the number of days of the interest period including the settlement date
COUPDAYSNC	Returns the number of days between the settlement date and the next interest date (coupon settled day)
COUPNCD	Returns the next interest date after the settlement date
COUPNUM	Returns the number ...