Excel DB Function

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).

Excel DB Function November 6th, 2016Team
Read more

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.

Excel DDB Function November 6th, 2016Team
Read more

Excel SLN Function

The Excel SLN function is one of many Excel financial functions, and can be used to calculate the straight line depreciation of a long term asset. It has the syntax SLN (cost, salvage, life).

Excel SLN Function November 6th, 2016Team
Read more

Excel SYD Function

The Excel SYD function is used to calculate the sum of the years digits depreciation for a given accounting period. It is based on an assets cost. salvage value, and useful life.

Excel SYD Function November 6th, 2016Team
Read more

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.

Excel NOMINAL Function November 6th, 2016Team
Read more

Excel PV Function

The Excel PV function is one of many Excel financial functions, and can be used to calculate the present value in excel of a lump sum, an annuity, or an annuity due. It has the syntax PV (Rate, Nper, Pmt, FV, Type).

Excel PV Function November 6th, 2016Team
Read more

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.

Excel RATE Function November 6th, 2016Team
Read more

Excel FV Function

The Excel FV function is one of many Excel financial functions, and can be used to calculate the present value in excel of a lump sum, an annuity, or an annuity due. It has the syntax FV (Rate, Nper, Pmt, PV, Type).

Excel FV Function November 6th, 2016Team
Read more

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.

Excel NPV Function November 6th, 2016Team
Read more

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.

Excel NPER Function November 6th, 2016Team
Read more

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.

Excel PMT Function November 6th, 2016Team
Read more

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.

Excel IRR Function November 6th, 2016Team
Read more

You May Also Like


Related pages


trial balance is preparedretained profit meaningdeclining balance method depreciation calculatorwhat does freight collect meansoftware amortisationhow to compute ending retained earningscompute effective interest ratecredit noeformula of total asset turnover ratiodeferred tax asset journal entry examplepayroll suspense accountmanufacturing overhead costs includeoperating lease vs finance lease accountingjournal entry for salary paid in advanceunder the allowance method bad debt expense is recordedprepayments and accruals double entryturnover accounting formulafederal income tax expense adjusting entrydefine deferred taxhow to record depreciation expense journal entrybond sinking fund journal entryaccrual accounting versus cash accountingabc inventory systemhow to do a multi step income statementactual manufacturing overheadreceived invoice journal entryaccured expenseaccrual exampleswhat does purchase ledger meanstandard cost variance definitiondouble entry bookkeeping templatepayment ledger templatefuture value of annuity excelpayback calculationpetty cash fund definitionfreight prepaid definitionexcel balance sheet templatemarkup vs margin formulasingle entry system of accounting formatformula contribution marginwhat are accrued revenuesprepaid expense amortization schedulepresent worth factor tableformula for overhead costpresent value annuityoverhead journal entryjournal entry for goodwill impairmentprovision for doubtful debts meaninghow to calculate ddb depreciationaccounting unearned revenuedepreciation debit or creditsample chart of accounts for rental propertypayment terms examples invoicesprovision for doubtful receivablesmarkup percentage formulacalculating wipwhat is manufacturing overhead costaccumulated depreciation credit or debitbond amortization effective interest methodjournal entry for tdsstatement of retained earnings templatepresent value calculator annuity duepredetermined overhead allocation rateamortization table makert accounts assets and liabilitiesrent accrual journal entryinterview for accounts payable positionaccounts payable normal balancemargin and markup formuladeclining balance method formulapurchase ledger control account