There are numerous method of depreciating the fixed assets. One of them is Double declining balance. In our earlier post regarding double declining,we learnt how to do it using manual work. But, now our focus is to use Microsoft Excel to work out all the calculation for DDB depreciation. We use the following formula in Excel:

**Formula**

DDB( cost, salvage, life, period, [factor] )

**Example**

ZL is a manufacturing concern. It has fixed asset of $ 500,000. It is considering depreciating the fixed asset using the DDP method. The useful life of the asset is 05 years with a salvage value of $ 20,000. Prepare a depreciation schedule using MS Excel via double declining method.

**Solution**

We have inputted Initial cost, salvage value and useful life in cell B1, B2 & B3. In cell B6, we have inputted the DDB formula to calculate the depreciation expense. Later, we drag it down to calculate the remaining periods's depreciation expense.

Formula, we used is as follows:

=DDB($B$1,$B$2,$B$3,A6)

Contents

Financial Ratios
Accounting Cycle
Accounting Principles
Financial Accounting Basics
Financial Statements Reporting
Bad Debts
Current Assets
Long-term Assets
Voucher System
Partnership
Depreciation
Work Sheet - 10 Column Work Sheet
Difference Between Reserve and Fund
Accounting for Leases
Capital reduction and reconstruction
Absorption of Company
Amalgamation
Accounting for Installment Sales
Basis of Recording Profit and Loss
Branch Accounting
Construction Contracts
Revenue Recognition
Accounting for Groups
Financial Analysis
Events After the Balance Sheet Date
Deferred Tax
Cost Accounting
Activity Based Costing (ABC)
Throughput Accounting
Relevant Cost
Break Even Analysis
Standard Costing
Inventory Management
Payroll Accounting
Royalty Accounting
Statistics
Master Budget
Salary Income
Microsoft Excel Tutorial
How to Count Number of Records between Two Dates
How to sum values in excel based on a criteria
Finding the first login and last logout time of employees
How to Print Salary Slips Using VLookup Formula in Excel
How to Calculate Net Present Value (NPV) in Excel
Income tax calculation excel sheet for salaried individuals
How to Calculate Pay Back Period in Excel
How to Calculate Declining Balance in Excel Using Formula
How to Calculate Double Declining Balance in Excel
How to Calculate Number of Payments on A Loan In Excel Using NPER
Count the Number of Excel Records That Fall Between Two Dates
How to Count Cells between Two Numbers in Excel
How to Prepare Exam Result in Excel 3D Sum Multiple Worksheets
How to Count Specific Text in Excel
Other Topics
Share or Stock Valuation Model
Financial Management Topics
Kinds of Endorsement
Letter of Credit, Kinds and Its Advantages/ Utilities
Modern Functions of a Commercial Banks
Difference Between Secured And Unsecured Loan
Excel conditional formatting red if negative green if positive
How to Remove Extra Spaces in Excel
Result Card or Result Sheet Creation Using Excel
Basic Accounting MCQS Multiple Choice Questions