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.
