excel financial function.docx - Financial Functions ACCRINT(WS Returns the accrued interest for a security that pays interest on a periodic basis

excel financial function.docx - Financial Functions...

This preview shows page 1 - 2 out of 2 pages.

Financial Functions ACCRINT (WS) Returns the accrued interest for a security that pays interest on a periodic basis ACCRINTM (WS) Returns the accrued interest for a security that pays interest at maturity AMORDEGRC (WS) Returns the linear depreciation of an asset for each accounting period, on a prorated basis AMORLINC (WS) Returns the depreciation of an asset for each accounting period, on a prorated basis DB (WS) Returns the depreciation of an asset based on the fixed-declining balance method DDB (WS, VBA) Returns the depreciation of an asset based on the double-declining balance method FV (WS, VBA) Returns the future value of an investment IPMT (WS, VBA)Returns the interest payment for an investment IRR (WS, VBA) Returns the internal rate of return for a series of cash flows ISPMT (WS) Returns the interest payment for an investment MIRR (WS, VBA)Returns the modified internal rate of return for a series of cash flows NPER (WS, VBA)Returns the number of periods for an investment NPV (WS, VBA)
Image of page 1
Image of page 2

You've reached the end of your free preview.

Want to read both pages?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture