Excel Spreadsheets Functions: Financial

 613-749-4695 [email protected]
 Tips and Ideas on Excel Table of Contents on Excel Tips and Ideas on Macros Table of Contents on VBA Quick Links

 This page is offered to you as reference Click here for more on the interesting Excel spreadsheets functions of financial  category

# Excel Lesson 24D of 24: Excel Spreadsheets  Financial Functions (53)

Here is the list of the 53 functions of the financial  category. Follow the links below to discover formulas using 4 of them.

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

 Next Chapter: Information Functions in Excel Excel Table of Contents or use the quick links below

 Discover Even More in 50 Excel spreadsheets

 613-749-4695 [email protected]
 Tips and Ideas on Excel Table of Contents on Excel Tips and Ideas on Macros Table of Contents on VBA Quick Links

Excel Spreadsheets Functions: Financial