db - Depreciation using Fixed Declining Balance Method DB...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Depreciation using Fixed Declining Balance Method – DB The depreciation charge or expense of an asset for any one specific period of time using the complex-declining balance method can be calculated using Excel’s DB function. See the table below for a detailed list of the exercises and problems in the text that can be solved using this function. Syntax =DB(cost,salvage,life,period,month) Cost – initial cost of the asset Salvage – value of the asset at the end of depreciation Life – number of periods over which the asset is being depreciated Period – is the period and must use the same units as Life Month – number of months in the first year. Assumed 12 if left blank General Example The following general example shows how the DB function can be used. Notice that the DB function appears in the formula bar. 1
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Using the DB Function in a Spreadsheet To calculate the depreciation charge for one period using the declining-balance method, create a worksheet by following Steps 1 to 7. Or, to use the DB function right away, select the DB worksheet in the Excel Functions Templates workbook. All fields have been formatted for you (currency, percentage, number of decimals displayed). Step 1 : Enter the title DB Function in cell A1. You will replace DB Function with your project title when you use the spreadsheet for a particular question or situation. Step 2
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 5

db - Depreciation using Fixed Declining Balance Method DB...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online