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


annual leave accrual accountingppv variancewhat is unearned revenue on a balance sheetrate variance definitionjournalizing accountingdebtors turnover ratio meaningasset liability equationassignment of receivablesending inventory adjusting entryoutstanding checks bank reconciliationkenexa prove it accounting test answerscalculate the price of a zero coupon bondbond repayment schedulemicrosoft excel bookkeeping templatesowners equity formulafactory overhead accountingjournal entries for bank reconciliation examplecreditor ratiosum of the years digits formuladebtors turnover formulacalculating net realizable valuebasic bookkeeping principlesequation for roafixed asset ratio formulaamortization in income statementdays sales outstanding analysismargin vs markup calculatoraccrued income examplemulti step income statement definitionexcel calculate npvbad debt provision journal entrydeferred expenses meaningcredit and debit chartthe double declining balance methodformula for cost of goods sold in accountingmeaning of operating cyclesegment margin formulasuspense account is which type of accountdegree of operating leverage equationcost of goods manufactured templategross margin vs markup calculatoraccounts receivable interviewbond accounting entriespayment voucher template docstraight line depreciation useful lifepresent value and future value formulawhen is a trial balance preparedexcel function pmtsample voucher for paymentformula for growing annuitystatement of stockholders equity templateprojected balance sheet template excelformula present value of annuityequipment lease calculator excelstraight line amortization schedulehow to calculate dividends payableoverhead cost examplecash receipt book sampleformula dividend payout ratiocalculate future value annuitycash receipt sample wordpresent value of lump sum formulachanging from lifo to fifohow to calculate cogs from income statementannuity to present valueannuity interest rate formulajournal entry for accounts payablebond amortization schedule excelfifo equivalent units of productionaccount payable turnover days formulaaccounting amortization scheduleperforma of trial balancethe balance in the prepaid rent accountstandard general ledger chart of accountsbalance sheet prepaid expenses200 declining balance depreciation method