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 refers to the systematic repayment of a debt over an extended period through a series of scheduled installments. To amortize a loan effectively, the periodic payments must be substantial enough to cover not only the interest that has accrued but also a portion of the principal amount. As per Wiki – “In banking […]
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.