Financial functions

Status

Not started

Status	Column 1	Title
Not started	Function	Description
Not started	ACCRINT	Returns the accrued interest for a security that pays periodic interest
Not started	ACCRINTM	Returns the accrued interest for a security that pays interest at maturity
Not started	AMORDEGRC	Returns the depreciation for each accounting period by using a depreciation coefficient
Not started	AMORLINC	Returns the depreciation for each accounting period
Not started	COUPDAYBS	Returns the number of days from the beginning of the coupon period to the settlement date
Not started	COUPDAYS	Returns the number of days in the coupon period that contains the settlement date
Not started	COUPDAYSNC	Returns the number of days from the settlement date to the next coupon date
Not started	COUPNCD	Returns the next coupon date after the settlement date
Not started	COUPNUM	Returns the number of coupons payable between the settlement date and maturity date
Not started	COUPPCD	Returns the previous coupon date before the settlement date
Not started	CUMIPMT	Returns the cumulative interest paid between two periods
Not started	CUMPRINC	Returns the cumulative principal paid on a loan between two periods
Not started	DB	Returns the depreciation of an asset for a specified period by using the fixed-declining balance method
Not started	DDB	Returns the depreciation of an asset for a specified period by using the double-declining balance method or some other method that you specify
Not started	DISC	Returns the discount rate for a security
Not started	DOLLARDE	Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number
Not started	DOLLARFR	Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction
Not started	DURATION	Returns the annual duration of a security with periodic interest payments
Not started	EFFECT	Returns the effective annual interest rate
Not started	FV	Returns the future value of an investment
Not started	FVSCHEDULE	Returns the future value of an initial principal after applying a series of compound interest rates
Not started	INTRATE	Returns the interest rate for a fully invested security
Not started	IPMT	Returns the interest payment for an investment for a given period
Not started	IRR	Returns the internal rate of return for a series of cash flows
Not started	ISPMT	Calculates the interest paid during a specific period of an investment
Not started	MDURATION	Returns the Macauley modified duration for a security with an assumed par value of $100
Not started	MIRR	Returns the internal rate of return where positive and negative cash flows are financed at different rates
Not started	NOMINAL	Returns the annual nominal interest rate
Not started	NPER	Returns the number of periods for an investment
Not started	NPV	Returns the net present value of an investment based on a series of periodic cash flows and a discount rate
Not started	ODDFPRICE	Returns the price per $100 face value of a security with an odd first period
Not started	ODDFYIELD	Returns the yield of a security with an odd first period
Not started	ODDLPRICE	Returns the price per $100 face value of a security with an odd last period
Not started	ODDLYIELD	Returns the yield of a security with an odd last period
Not started	PDURATION (2013)	Returns the number of periods required by an investment to reach a specified value
Not started	PMT	Returns the periodic payment for an annuity
Not started	PPMT	Returns the payment on the principal for an investment for a given period
Not started	PRICE	Returns the price per $100 face value of a security that pays periodic interest
Not started	PRICEDISC	Returns the price per $100 face value of a discounted security
Not started	PRICEMAT	Returns the price per $100 face value of a security that pays interest at maturity
Not started	PV	Returns the present value of an investment
Not started	RATE	Returns the interest rate per period of an annuity
Not started	RECEIVED	Returns the amount received at maturity for a fully invested security
Not started	RRI (2013)	Returns an equivalent interest rate for the growth of an investment
Not started	SLN	Returns the straight-line depreciation of an asset for one period
Not started	SYD	Returns the sum-of-years' digits depreciation of an asset for a specified period
Not started	TBILLEQ	Returns the bond-equivalent yield for a Treasury bill
Not started	TBILLPRICE	Returns the price per $100 face value for a Treasury bill
Not started	TBILLYIELD	Returns the yield for a Treasury bill
Not started	VDB	Returns the depreciation of an asset for a specified or partial period by using a declining balance method
Not started	XIRR	Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic
Not started	XNPV	Returns the net present value for a schedule of cash flows that is not necessarily periodic
Not started	YIELD	Returns the yield on a security that pays periodic interest
Not started	YIELDDISC	Returns the annual yield for a discounted security; for example, a Treasury bill
Not started	YIELDMAT	Returns the annual yield of a security that pays interest at maturity

Financial functions

Untitled