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.

Sidebar