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

Double Declining Balance Depreciation Calculator

Depreciation is a business expense reflecting the wear and tear of long term assets as they are used within the business.

The Excel double declining balance depreciation calculator, available for download below, is used to compute the annual depreciation charge using the double declining method.

Double Declining Balance Depreciation Calculator June 14th, 2017Team
Read more

Declining Balance Depreciation

The declining balance method sometimes referred to as reducing balance, is a commonly used method of calculating the depreciation charge for an asset.

The depreciation charge is given by the declining balance method formula as follows:

Declining Balance Depreciation December 9th, 2016Team
Read more

You May Also Like

Related pages

bills receivable accountcorrecting entry accountingaccount payable journal entryhow to calculate marketable securities from balance sheetthe imprest systemannuity payment excelstandard cost variance analysistotal variable costs formulawhat is unearned revenuepetty cash fund balance sheetsample of ledger bookprepaid expenses treatment in balance sheetsolved example of bank reconciliation statementwrite off of accounts receivableliquidity ratio quick ratiohow would net income affect the accounting equationpresent value of a single sum calculatordays sales in receivables definitionannuity to present valuejournal entries for depreciationledger sheet examplefifo method inventoryasset depreciation calculatorassets turnover ratio calculatorreceivable turnover days formulabond issuance price calculatorinventory shrinkage definitiondeferred tax calculation templatesample voucher templatereceivables turnover ratio exampleis allowance for doubtful accounts a liabilitypetty cash float definitionjournal entry of depreciationcalculate direct materialsnper in exceladjusting entries accrued expensesgeneral ledger accounts receivablehow to identify debit and credit in accountingcash accounting versus accrual accountingpresent value of lease payments formuladefinition bookkeepingaccrued expenses on balance sheetdebtors days calculation formulauncredited chequesaccounting internal controls checklistwhat is profit markuphow to convert markup to marginwhat is indirect material costledgers in accountingdepreciation formula exceljob costing formulawhat are prepayments in accountingpredetermined overhead rate formulacreditors turnover ratiopresent value lump sum calculatornpv excelturnover calculation in balance sheetinstallment loan formulahow to calculate weighted average unit contribution margindouble entry bookkeeping practice questionsrelevance of variance analysis to budgeting and standard costingallowance for uncollectible accounts is classified aspayroll cash advanceaccounts ledgersthe first step in the accounting cycle isfactoring receivables definitionwhat is a growing annuityaccounting quizesuncleared chequehow to calculate purchase price variancecalculate margin excelpv of a perpetuity formulaaverage debtors collection periodoverhead cost example