Returns the future value of an investment based on an interest rate and a constant payment schedule.
How To Use: ACCRINT function
Returns the accrued interest for a security/investment that pays interest on a periodic basis.
Download Loan Amortization Excel Template
Loan Amortization is the gradual repayment of a debt over a period of time. In order to amortize a loan, your payments must be large enough to pay not only the interest that has accrued but also to the principal. As per Wiki – “In banking and finance, an amortizing loan is a loan where […]
How To Use: AMORLINC Function
Returns the depreciation for each accounting period. This function is provided for the French accounting system.
How To Use: AVERAGE Function
Returns the Average (arithmetic mean) of a list of supplied numbers.