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

usefulness of variance analysisformula for reducing balance depreciationprepare an amortization schedulestated annual interest ratelower of cost and net realizable valueaccounting concepts conventions and principlespoc calculationoverhead volume varianceexamples of goodwill in accountingcalculate gearing ratio from balance sheetpresent value of annuitiesprepaid expenses in trial balanceroa calculationbond cash flow calculatorjournal entries for bank reconciliation exampleformula of profitability indexvoucher template wordfunctional format income statementmulti step income statementexcel balance sheet formulabad debts expense journal entryaccounting entries for accruals and prepaymentsfob on an invoicepresent value annuity table pdfdebtor turnover ratiohow to calculate manufacturing overhead costreceivables turnover rateperpetual system journal entriessample payment voucher formatnet realisable value methodtreasury stock account typegraduated annuityzero coupon bond journal entrypremium on bonds payabledeclared dividends journal entryfinancial accounting ratios formulascash accounting vs accrual accounting examplesaccount receivable interview questionsnpv calculation example in excelinfinite annuity formulabalance sheet prepaid rentpv of perpetuityhow to calculate current liabilitiesaccounts payable a credit or debitnpv perpetuitysales ledger samplecash dividend declaredreceipt ledgerbank reconciliation formulageneral ledger reconciliation templatepv annuity tableactivity ratio formulahow to calculate inventory varianceuneven cash flowformula for diminishing value depreciationexample of accumulated depreciationadjusting entries worksheethorizontal analysis accounting examplemonthly ledger templatebad debts accounting entrydifference between accounts payable and notes payablehow to do trial balance from ledgerpaid dividends to stockholders journal entryweighted average ending inventoryhow to calculate stock value in excelaccounting concepts conventions and principlesdeferred tax accounting journal entriesjv accounting termaccrued liability journal entrylearn accounting entriesdeferred tax in cash flow statementprepayments and accrualsinventory on hand adjusting entrycalculating ratios in excelpayment voucher format sampleaccrued expenses in balance sheet