Use this Depreciation Schedule Generator to estimate how an asset loses value over time. Enter the purchase cost, salvage value, and useful life to create a yearly depreciation schedule. Compare different depreciation methods and download the results for your records.
Asset Details
Depreciation Summary
Annual Depreciation (Year 1)
$1,800.00
Example schedule calculated using the default values.
Estimates are based on the asset details and method selected. Actual accounting treatment may vary by applicable rules.
Year-by-Year Depreciation Schedule
| Year | Opening Book Value | Depreciation | Accumulated Depreciation | Closing Book Value |
|---|---|---|---|---|
| 1 | $10,000.00 | $1,800.00 | $1,800.00 | $8,200.00 |
The final year’s depreciation is adjusted when necessary to avoid reducing the book value below the salvage value.
How to Use the Depreciation Schedule Generator
Using the calculator is simple. Enter the asset's purchase cost, estimated salvage value, and useful life. Choose a depreciation method, and the calculator will generate a year-by-year schedule showing depreciation expense, accumulated depreciation, and ending book value.
You can change the currency, compare different methods, and download the schedule as a CSV file for use in a spreadsheet.
Depreciation Calculation Examples
Example 1: Straight-Line Depreciation
Suppose you buy office equipment for $10,000, expect it to be worth $1,000 at the end of its useful life, and plan to use it for five years.
- Purchase cost: $10,000
- Salvage value: $1,000
- Useful life: 5 years
- Depreciable amount: $9,000
The annual depreciation is:
($10,000 − $1,000) ÷ 5 = $1,800 per year
Under the straight-line method, the asset depreciates by $1,800 each year. Its book value at the end of Year 5 is $1,000.
Example 2: Double-Declining Balance Depreciation
Using the same $10,000 asset with a $1,000 salvage value and a five-year useful life, the double-declining balance method applies a 40% rate to the beginning book value each year.
| Year | Depreciation | Ending book value |
|---|---|---|
| 1 | $4,000 | $6,000 |
| 2 | $2,400 | $3,600 |
| 3 | $1,440 | $2,160 |
| 4 | $864 | $1,296 |
| 5 | $296 | $1,000 |
This method records higher depreciation in the earlier years and lower depreciation later. In the final year, the remaining depreciable amount is recorded so the book value does not fall below the salvage value.
What Is a Depreciation Schedule?
A depreciation schedule shows how an asset's value is allocated as an expense over its useful life. It typically includes the beginning book value, depreciation expense for each period, accumulated depreciation, and ending book value.
Businesses use these schedules to plan expenses, maintain accounting records, and understand the estimated value of equipment, vehicles, furniture, and other long-term assets.
Which Depreciation Method Should You Choose?
- Straight-Line: Useful when you want to spread depreciation evenly across an asset's useful life.
- Declining Balance: Applies a chosen percentage to the asset's beginning book value.
- Double-Declining Balance: Records more depreciation in the earlier years.
- Sum-of-the-Years'-Digits: Also accelerates depreciation, with the largest expense in the first year.
The appropriate method depends on how the asset is expected to be used and the accounting rules that apply to your business.
Frequently Asked Questions
What is a depreciation schedule generator?
A depreciation schedule generator calculates estimated depreciation for an asset over its useful life. It displays yearly depreciation expenses, accumulated depreciation, and remaining book value.
How do you calculate straight-line depreciation?
Subtract the estimated salvage value from the purchase cost, then divide the result by the asset's useful life in years.
Formula: (Purchase Cost − Salvage Value) ÷ Useful Life.
What is salvage value?
Salvage value is the estimated amount an asset may be worth at the end of its useful life. It is deducted from the purchase cost when calculating the depreciable amount.
What is the difference between straight-line and declining balance depreciation?
Straight-line depreciation spreads the depreciable amount evenly over the asset's useful life. Declining balance methods generally record higher depreciation in the earlier years and lower amounts later.
Can I download my depreciation schedule?
Yes. Use the Download CSV button to export the schedule. You can open the CSV file in spreadsheet software such as Microsoft Excel or Google Sheets.
Can I use this calculator for tax depreciation?
The calculator provides general estimates. Tax depreciation rules, permitted methods, and useful-life requirements vary by country and asset type. Check the applicable tax rules or consult a qualified tax professional before using the figures for a tax return.
Disclaimer: This calculator is intended for general informational and planning purposes. Results may differ from figures required under specific accounting standards or tax regulations.
Related Calculators