When a business buys a piece of equipment, a vehicle, or any long-term asset, that asset doesn’t retain its value forever. Over time, it wears out, becomes outdated, or simply gets used up. That gradual loss in value is called depreciation — and a depreciation schedule is the document that tracks it, year by year.
Whether you’re a business owner, an accountant, a financial analyst, or just someone trying to understand how company finances work, understanding depreciation schedules is fundamental. It touches everything — from the income statement and balance sheet to your annual tax filing.
In this guide, we break down exactly what a depreciation schedule is, why it matters, the methods used to calculate it and how to build one from scratch.
What Is Depreciation Schedule?
A depreciation schedule is a structured table or document that outlines how an asset’s value reduces over its useful life. It records how much of the asset’s cost has been “used up” in each accounting period and shows the remaining book value at any given point in time.
Think of it like this — if a company buys a machine for ₹10 lakh and expects it to last 10 years, the depreciation schedule maps out exactly how much of that ₹10 lakh will be recorded as an expense each year until the asset is fully depreciated.
“A depreciation schedule is the backbone of asset management in financial modeling — it ties the balance sheet, income statement, and cash flow statement together.”
In financial modeling, a depreciation schedule is required to forecast three things:
- The value of a company’s fixed assets on the balance sheet
- The depreciation expense on the income statement
- Capital expenditures (CapEx) on the cash flow statement
All tangible assets with a useful life of more than one year — buildings, machinery, vehicles, computers, furniture — need to be depreciated. This is a requirement under standard accounting principles like GAAP (Generally Accepted Accounting Principles) and India’s IndAS.
Why Is a Depreciation Schedule Important?
A depreciation schedule isn’t just a compliance document — it serves several critical business purposes.
Accurate Financial Reporting– Ensures expenses are matched to the period in which the asset generates revenue, following the matching principle.
Tax Deductions– Businesses can claim depreciation as a deductible expense, reducing their taxable income and overall tax liability.
Asset Management– Helps businesses track when assets need replacement, making capital budgeting decisions easier and more informed.
Investor & Lender Confidence– A properly maintained schedule signals financial discipline and transparency to investors, auditors and lenders.
Also Read – Free websites to talk to strangers
Key Components of a Depreciation Schedule
A standard depreciation schedule contains the following elements for each asset:
| Component | What It Means |
|---|---|
| Asset Description | Name and brief details of the asset (e.g., delivery truck, office building) |
| Purchase Date | The date when the asset was acquired |
| Original Cost / Purchase Price | The total amount paid to acquire and put the asset into service |
| Salvage Value | The estimated resale value at the end of the asset’s useful life |
| Useful Life | How long the asset is expected to remain productive (in years) |
| Depreciation Method | The formula used to calculate annual depreciation (e.g., straight-line, declining balance) |
| Annual Depreciation Expense | The amount deducted from the asset’s value each year |
| Accumulated Depreciation | Total depreciation charged from the purchase date to the current period |
| Net Book Value (NBV) | Original cost minus accumulated depreciation — the asset’s value on the balance sheet |
4 Main Types of Depreciation Methods
Not all assets lose value the same way. A manufacturing machine might wear out based on usage, while office furniture simply ages with time. The depreciation method you choose should reflect how the asset actually loses value. Here are the four most commonly used methods:
1. Straight-Line Depreciation
This is the simplest and most widely used method. It spreads the cost of the asset evenly across every year of its useful life. The annual depreciation expense stays constant throughout.
Formula:
Annual Depreciation = (Cost − Salvage Value) ÷ Useful Life (years)
Best for: Office furniture, buildings, or any asset that loses value steadily over time.
2. Declining Balance (Accelerated Depreciation)
This method front-loads the depreciation — the asset loses a larger portion of its value in the early years, with smaller amounts in later years. The most common version is the Double Declining Balance (DDB) method.
Formula:
Depreciation Expense = Beginning Book Value × (2 ÷ Useful Life)
Best for: Technology, vehicles, or assets that quickly lose value in early years (e.g., laptops, cars).
3. Units of Production Depreciation
This method ties depreciation directly to how much the asset is used, rather than the passage of time. More usage in a year = more depreciation that year. It’s a variable-rate method — the schedule is generated at the end of each year based on actual output.
Formula:
Depreciation per Unit = (Cost − Salvage Value) ÷ Total Estimated Units
Annual Depreciation = Depreciation per Unit × Units Produced That Year
Best for: Manufacturing machinery, mining equipment, or production vehicles where wear depends on actual use.
4. Sum-of-the-Years’ Digits (SYD)
This is an accelerated method that applies a declining fraction to the depreciable base each year. The fraction is calculated using the remaining useful life divided by the sum of all the years in the asset’s life.
Formula:
SYD = n(n+1) ÷ 2 (where n = useful life in years)
Annual Depreciation = (Remaining Life ÷ SYD) × (Cost − Salvage Value)
Best for: Assets with high early productivity that taper off, like specialized tools and certain vehicles.
Quick Comparison: Which Method to Use?
| Method | Depreciation Pattern | Ideal For | Complexity |
|---|---|---|---|
| Straight-Line | Equal each year | Buildings, furniture | Low |
| Declining Balance | Higher early, lower later | Tech, vehicles | Medium |
| Units of Production | Variable (usage-based) | Machinery, equipment | Medium |
| Sum-of-Years’ Digits | Accelerated fraction-based | Specialized assets | High |
How to Create a Depreciation Schedule: Step by Step
Building a depreciation schedule doesn’t have to be complicated. Here’s how to set one up, whether you’re doing it in Excel, accounting software or even a spreadsheet template.
- List All Depreciable Assets: Start by identifying every fixed asset that qualifies for depreciation — machinery, vehicles, computers, buildings and so on. Exclude land, as it does not depreciate.
- Gather Asset Details: For each asset, note down the purchase date, original cost, estimated salvage value, and expected useful life. These are the four building blocks of any depreciation calculation.
- Choose a Depreciation Method: Select the method that best reflects how the asset loses value. For most businesses, straight-line is the default. Use accelerated methods when the asset is most productive in its early years.
- Calculate Annual Depreciation: Apply the chosen formula to compute the depreciation expense for each year of the asset’s life.
- Track Accumulated Depreciation & Net Book Value: Each year, add the depreciation expense to the accumulated depreciation column and subtract it from the asset’s cost to get the current net book value (NBV).
- Reconcile with PP&E on the Balance Sheet: At the bottom of the schedule, compute the net change in PP&E: Beginning Balance + CapEx − Depreciation − Disposals = Ending Balance. This ties the schedule back to the balance sheet.
- Update the Schedule Regularly: Whenever a new asset is purchased, an old one is sold, or an asset is written off, update the schedule accordingly.
Also Read – Exploring the Anthropic Mythos AI Model
Example: Straight-Line Depreciation Schedule
Let’s walk through a simple, real-world example using the straight-line method.
Scenario: A company purchases an office printer for ₹2,20,000. It is expected to last 5 years and can be sold for ₹20,000 at the end of its useful life (salvage value).
Annual Depreciation = (₹2,20,000 − ₹20,000) ÷ 5 = ₹40,000 per year
| Year | Beginning Book Value | Depreciation Expense | Accumulated Depreciation | Net Book Value (End) |
|---|---|---|---|---|
| Year 1 | ₹2,20,000 | ₹40,000 | ₹40,000 | ₹1,80,000 |
| Year 2 | ₹1,80,000 | ₹40,000 | ₹80,000 | ₹1,40,000 |
| Year 3 | ₹1,40,000 | ₹40,000 | ₹1,20,000 | ₹1,00,000 |
| Year 4 | ₹1,00,000 | ₹40,000 | ₹1,60,000 | ₹60,000 |
| Year 5 | ₹60,000 | ₹40,000 | ₹2,00,000 | ₹20,000 (Salvage) |
At the end of Year 5, the printer’s net book value equals its salvage value of ₹20,000, and total depreciation of ₹2,00,000 has been recorded over the period.
Tax Depreciation vs. Book Depreciation: What’s the Difference?
Many businesses maintain two separate depreciation schedules — one for financial reporting (book depreciation) and one for tax purposes (tax depreciation). They don’t always match and that’s perfectly normal.
| Aspect | Book Depreciation | Tax Depreciation |
|---|---|---|
| Purpose | Financial reporting (GAAP / IndAS) | Tax filings (Income Tax Act) |
| Method Used | Any standard method (usually SLM) | Typically Written Down Value (WDV) method as per tax law |
| Rate Control | Management estimates useful life | Rates prescribed by tax authorities |
| Impact | Affects reported profit / EPS | Reduces taxable income |
| Timing Differences | May be slower | Often accelerated to maximise deductions early |
The timing difference between the two creates what accountants call a deferred tax liability or asset which appears on the balance sheet.
Also Read – Board of Directors Positions: Every Title, Role & Responsibility Explained
Key Takeaways
- A depreciation schedule tracks how a fixed asset loses value over its useful life.
- It connects all three financial statements: balance sheet, income statement, and cash flow statement.
- The four main methods are Straight-Line, Declining Balance, Units of Production, and Sum-of-Years’ Digits.
- The right method depends on the asset type, industry norms and whether the purpose is accounting or tax.
- Used assets can also be depreciated — the starting point is their value at the time of purchase.
- Tax and book depreciation schedules often differ and serve different purposes.
What is the purpose of a depreciation schedule?
A depreciation schedule serves multiple purposes: it ensures accurate financial reporting by matching the cost of an asset to the revenue it generates, enables businesses to claim tax deductions on depreciable assets, helps in planning asset replacements and provides transparency for investors and auditors who review a company’s balance sheet.
Which depreciation method is most commonly used?
The straight-line method is the most widely used depreciation method because of its simplicity and consistency. It spreads the asset’s cost equally across each year of its useful life, making it easy to forecast and audit. However, the declining balance method is also commonly used for tax purposes, as it allows businesses to claim larger deductions in the early years of an asset’s life.
Can used or second-hand assets be depreciated?
Yes. Used or second-hand assets can absolutely be depreciated. The depreciation is calculated based on the asset’s value at the time it was purchased by the current owner, not its original price when it was new. You would estimate the remaining useful life from the date of your purchase and apply your chosen method accordingly.
What is the difference between depreciation and accumulated depreciation?
Depreciation expense is the amount of value lost by an asset in a single accounting period (typically one year). Accumulated depreciation, on the other hand, is the total depreciation recorded from the date of purchase up to the current date. While depreciation expense appears on the income statement, accumulated depreciation is a contra-asset account on the balance sheet, reducing the asset’s gross value to arrive at its net book value.
What happens when an asset is fully depreciated?
When an asset is fully depreciated, its net book value on the balance sheet equals its salvage value (or zero, if there is no salvage value). At this point, no further depreciation expense is recorded. The asset may still be in use by the business, but it no longer appears as a depreciable expense. When eventually disposed of, any proceeds from the sale are compared against the book value to determine a gain or loss.
Is a depreciation schedule required for tax purposes in India?
Yes. Under the Indian Income Tax Act, businesses are required to calculate depreciation using the Written Down Value (WDV) method for most assets, at rates specified by the Act (Schedule II of the Companies Act 2013 for book purposes). Maintaining a proper depreciation schedule is not just good accounting practice — it is a legal necessity for claiming depreciation as a deductible expense and for passing tax audits.
How often should a depreciation schedule be updated?
A depreciation schedule should be reviewed and updated at least annually — typically at the end of each financial year. Additionally, it should be updated whenever a new asset is purchased, an existing asset is disposed of or sold, an asset undergoes a significant upgrade that extends its useful life, or there is a revision in the asset’s estimated useful life or salvage value.
What is salvage value in a depreciation schedule?
Salvage value (also called residual value or scrap value) is the estimated amount a business expects to recover from selling or scrapping an asset at the end of its useful life. It is subtracted from the asset’s original cost before calculating depreciation, as that portion of the cost is expected to be recovered, not expensed. For example, if a machine costs ₹5,00,000 and is expected to be sold for ₹50,000 after 10 years, the depreciable base is ₹4,50,000.
