Excel Financial Functions

This section will learn  how to use Excel’s  Financial Functions such as: Accrint, AccrintM, Amordegrc, Amorlinc, DB, etc.

ACCRINT – returns the accrued interest for a security that pays periodic interest.

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 by using a depreciation coefficient.

AMORLINC – returns the linear depreciation of an asset for each accounting period. This function is provided for French accounting system.

DB – returns the depreciation of an asset for a specified period using the fixed-declining balance method.

DDB – returns the depreciation of an asset for a specified period using the double-declining balance method or you can also use some other method to get the depreciation.

FV – used to calculate the future value of an investment based on a constant interest rate.

IPMT – used to calculate the interest payment for an investment based on a constant payment schedule and a constant interest rage.

IRR – returns the internal rate of return for a series of cash flows and the cash flows must be occurred at regular intervals (monthly or annually).

ISPMT – used to calculate the interest paid during a specific period of an investment.

MIRR – returns the modified internal rate of return for a series of cash flows and the cash flows must be occurred at regular intervals (monthly or annually).

NPER – returns the number of periods for an investment or loan based on periodic payment amount and a constant interest rate.

NPV – returns the net present value of an investment by using a discount rate and a series of future cash flows (future payments and income).

PMT – returns the payment amount for a loan or investment based on constant payments and a constant interest rate.

PPMT – returns the payment amount on the principal for a given period for a loan or investment based on constant payments and a constant interest rate.

RATE – returns the interest rate per payment period of an annuity.

PV – returns the present value of a loan or investment based on constant payments and a constant interest rate.

SLN – calculates the depreciation of an asset for one period based on the straight line depreciation.

SYD – calculates the sum-of-years’digits depreciation of an asset for a specified period.

VDB – calculates the depreciation of an asset for a specified period based on the double declining balance method.

XIRR – returns the internal rate of return for a series of cash flows that is not necessarily periodic.

Sidebar