Financial Functions

[Rishabh SuranaModerator]

ACCRINT >>>  Returns the accrued interest for a security that pays interest on a periodic basis

ACCRINTM >>>  Returns the accrued interest for a security that pays interest at maturity

AMORDEGRC >>>  Returns the linear depreciation of an asset for each accounting period, on a prorated basis

AMORLINC >>>  Returns the depreciation of an asset for each accounting period, on a prorated basis

DB >>>  Returns the depreciation of an asset based on the fixed-declining balance method

DDB >>>  Returns the depreciation of an asset based on the double-declining balance method

FV >>>  Returns the future value of an investment

IPMT >>>  Returns the interest payment for an investment

IRR >>>  Returns the internal rate of return for a series of cash flows

ISPMT >>>  Returns the interest payment for an investment

MIRR >>>  Returns the modified internal rate of return for a series of cash flows

NPER >>>  Returns the number of periods for an investment

NPV >>>  Returns the net present value of an investment

PMT >>>  Returns the payment amount for a loan

PPMT >>>  Returns the payment on the principal for a particular payment

PV >>>  Returns the present value of an investment

RATE >>>  Returns the interest rate for an annuity

SLN >>>  Returns the depreciation of an asset based on the straight-line depreciation method

SYD >>>  Returns the depreciation of an asset based on the sum-of-years’ digits depreciation method

VDB >>>  Returns the depreciation of an asset based on a variable declining balance depreciation method

XIRR >>>  Returns the internal rate of return for a series of cash flows that may not be periodic

Sent from my SM-A605G using Actuarial Info mobile app

[Author]

Posts