The Excel DB function is one of many Excel financial functions, and can be used to calculate the declining balance depreciation of a long term asset. It has the syntax DB (cost, salvage, life, period, month).
Last modified August 23rd, 2019
Tag: Excel Function
Excel DDB Function
The Excel DDB function is one of many Excel financial functions, and can be used to calculate the declining balance depreciation of a long term asset. It has the syntax DDB (cost, salvage, life, period, factor).
By setting the factor parameter to either one or two, the function can be used to calculate either the declining balance depreciation or the double declining balance depreciation.
Last modified October 31st, 2019
Excel SLN Function
Excel SYD Function
Excel NOMINAL Function
The Excel NOMINAL function is used to calculate the nominal annual rate (i) required to give an effective annual rate (r), allowing for a given number of compounding periods each year (m). The effective rate allows for compounding, whereas the nominal rate does not allow for compounding.
Last modified January 12th, 2023
Excel PV Function
Excel RATE Function
The Excel RATE function is used to calculate the discount rate (i) in time value of money calculations. For example, it can calculate the interest rate on a loan given the value of the loan, the term and the periodic payments, it can be used to calculate the interest rate earned on a savings account, or the interest rate needed to generate annuity payments from a lump sum investment.
Last modified January 16th, 2020
Excel FV Function
Excel NPV Function
The Excel NPV function is used to calculate the present value of unequal cash flows in time value of money calculations.
To calculate the net present value of a project, the original investment at the start of the project needs to be deducted from the answer provided by the Excel NPV function.
Last modified January 19th, 2023
Excel NPER Function
The Excel NPER function is one of many Excel financial functions, and can be used to calculate the number of periods for a lump sum, annuity or annuity due to grow to a future value. In addition the function can also be used to calculate the number of periods it takes for a loan to be repaid.
Last modified July 16th, 2019
Excel PMT Function
The Excel PMT function is used to calculate the payment (Pmt) in time value of money calculations. For example, it can calculate the payments needed to clear a loan balance, the deposits to a savings account to grow to a future value, or annuity and annuity due payments from a lump sum investment.
Last modified October 31st, 2019
Excel IRR Function
The Excel IRR function is used to calculate internal rate of return for a range of cash flows in time value of money calculations, and has the syntax IRR (Values, Guess).
Care must be taken when using the Excel IRR function with cash flows that change sign multiple times though out the term of the project, as it can produce meaningless solutions.
Last modified January 17th, 2023