Advanced Excel - Financial Functions

Advertisements

Excel Financial functions perform many of the common financial calculations, such as the calculation of yield, interest rates, duration, valuation and asset depreciation.

S.No.	Function and Description
1	ACCRINT Returns the accrued interest for a security that pays periodic interest
2	ACCRINTM Returns the accrued interest for a security that pays interest at maturity
3	AMORDEGRC Returns the depreciation for each accounting period
4	AMORLINC Returns the depreciation for each accounting period (the depreciation coefficient depends on the life of the assets)
5	COUPDAYBS Returns the number of days from the beginning of the coupon period to the settlement date
6	COUPDAYS Returns the number of days in the coupon period that contains the settlement date
7	COUPDAYSNC Returns the number of days from the settlement date to the next coupon date
8	COUPNCD Returns the next coupon date after the settlement date
9	COUPNUM Returns the number of coupons payable between the settlement date and maturity date
10	COUPPCD Returns the previous coupon date before the settlement date
11	CUMIPMT Returns the cumulative interest paid between two periods
12	CUMPRINC Returns the cumulative principal paid on a loan between two periods
13	DB Returns the depreciation of an asset for a specified period, using the fixed-declining-balance method
14	DDB Returns the depreciation of an asset for a specified period, using the double-declining-balance method or some other method that you specify
15	DISC Returns the discount rate for a security
16	DOLLARDE Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number
17	DOLLARFR Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction
18	DURATION Returns the annual duration of a security with periodic interest payments
19	EFFECT Returns the effective annual interest rate
20	FV Returns the future value of an investment
21	FVSCHEDULE Returns the future value of an initial principal after applying a series of compound interest rates
22	INTRATE Returns the interest rate for a fully invested security
23	IPMT Returns the interest payment for an investment for a given period
24	IRR Returns the internal rate of return for a series of cash flows
25	ISPMT Calculates the interest paid during a specific period of an investment
26	MDURATION Returns the Macauley modified duration for a security with an assumed par value of $100
27	MIRR Returns the internal rate of return where positive and negative cash flows are financed at different rates
28	NOMINAL Returns the annual nominal interest rate
29	NPER Returns the number of periods for an investment
30	NPV Returns the net present value of an investment based on a series of periodic cash flows and a discount rate
31	ODDFPRICE Returns the price per $100 face value of a security with an odd first period
32	ODDFYIELD Returns the yield of a security with an odd first period
33	ODDLPRICE Returns the price per $100 face value of a security with an odd last period
34	ODDLYIELD Returns the yield of a security with an odd last period
35	PDURATION Returns the number of periods required by an investment to reach a specified value
36	PMT Returns the periodic payment for an annuity
37	PPMT Returns the payment on the principal for an investment for a given period
38	PRICE Returns the price per $100 face value of a security that pays periodic interest
39	PRICEDISC Returns the price per $100 face value of a discounted security
40	PRICEMAT Returns the price per $100 face value of a security that pays interest at maturity
41	PV Returns the present value of an investment
42	RATE Returns the interest rate per period of an annuity
43	RECEIVED Returns the amount received at maturity for a fully invested security
44	RRI Returns an equivalent interest rate for the growth of an investment
45	SLN Returns the straight-line depreciation of an asset for one period
46	SYD Returns the sum-of-years’ digits depreciation of an asset for a specified period
47	TBILLEQ Returns the bond-equivalent yield for a Treasury bill
48	TBILLPRICE Returns the price per $100 face value for a Treasury bill
49	TBILLYIELD Returns the yield for a Treasury bill
50	VDB Returns the depreciation of an asset for a specified or partial period using a declining-balance method
51	XIRR Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic
52	XNPV Returns the net present value for a schedule of cash flows that is not necessarily periodic
53	YIELD Returns the yield on a security that pays periodic interest
54	YIELDDISC Returns the annual yield for a discounted security, for example, a Treasury bill
55	YIELDMAT Returns the annual yield of a security that pays interest at maturity

Previous Page Print Page