Depreciation Schedule: A Beginner’s Guide

Depreciation Schedule: A Beginner’s Guide

Deskera
Deskera
Table of Contents
Table of Contents

Not all assets that a business owns are held for sale.

Property, buildings, equipment, vehicles, machinery, and other fixed assets, are purchased to conduct day-to-day operating activities, over an extended period of time.

Because of this extended usage time, and their high monetary value, these long-term assets don’t get fully charged right when they’re bought. Rather, their cost is spread out over their estimated useful life.

In financial accounting, this cost is known as a depreciation expense.

The chart or table where businesses keep track of the depreciation expense for each asset over the years is known as a depreciation schedule.

In this guide, we’ll be explaining why a depreciation schedule is important, what assets you can depreciate, what are the different types of depreciation methods you can use, and everything else you need to know about creating a depreciation schedule for your small business accounting.

This article covers in-depth:

What Is Depreciation?

Depreciation represents how much an asset’s value has been used up. More specifically, it’s a method that allocates the costs of a fixed asset, over its expected useful life.

So, as it is purely an estimation, depreciation is a non-cash expense simply used for accounting purposes. The matching principle in financial accounting requires that business expenses incurred during one accounting period be recorded in the same period in which the related revenues are earned.

For instance, say a piece of manufacturing machinery is used to produce merchandise for three years. To comply with the matching principle, the company needs to match the cost of that machinery with the revenues generated from selling the merchandise. This is where depreciation comes into play - every year, for three years, the business has to devalue the machinery by recording an estimated depreciation expense.

The specific amount of depreciation expense to be recognized each year depends on the business, as there are many depreciation methods they can choose from. We’ll go through each, as well as explain their pros and cons, further down the guide.

If you want to learn how to record your depreciation expense, and all other financial transactions, as journal entries into your accounting books, head over to our guide on journalizing transactions.

What Kind of Assets Can You Depreciate?

For an asset to be depreciable it needs to fit the following criteria:

  1. You can’t claim the entire value of that asset in one single year.
  2. Your business needs to own the asset. Rented property, buildings, or equipment can’t be depreciated.
  3. You must use the asset to generate profit.
  4. The useful life or life expectancy of the asset must be greater than a year. Inventory, for instance, is typically purchased to be sold for less than a year, and thus can’t be depreciated.

More concretely, some common fixed assets that fit these criteria include vehicles, office equipment, real estate (except land), machinery, computers, and so forth.

What Is a Depreciation Schedule?

A depreciation schedule is a table you create to keep track of the depreciation of the expense of each of your fixed assets over the years. The main goal of a depreciation schedule is to give you the ability to track what depreciation you've already recognized and stay on top of your finances.

Typically, the schedule will list the following information:

  • Name and description of the asset, e.g: Property & Equipment
  • Date of purchase
  • Cost of the asset
  • Estimated/expected useful life
  • Salvage value/residual value, which is the estimated value that a fixed asset will have at the end of its useful life. Sometimes, the residual value may equal zero, in which case the value isn’t taken into account.
  • Current year depreciation
  • Accumulated depreciation, which is the total amount an asset has been depreciated up until a certain year or point.
  • The depreciation method used. According to the Generally Accepted Accounting Principles (GAAP), you can choose from four depreciation methods: straight-line method, double-declining balance, sum-of-the-years’-digits, and units of production.
  • Net book value, which is the price at which a business records an asset on its balance sheet.

These elements vary, depending on the amount of detail you want your schedule to provide, as well as the method you use to calculate the depreciation.

Methods of Depreciation

As mentioned, GAAP supports four main methods of depreciation: the straight-line method, the double-declining balance, the sum-of-the-years’-digits, and the units of production.

1.  Straight-Line Method

The straight-line method is the simplest and most widespread way to depreciate fixed assets. Under this method, the value of your asset is split and depreciated evenly each year.

To calculate it, take the cost of an asset and then subtract it with the salvage value.

Then divide the resulting number by the total of years the asset is expected to be useful, as shown in the formula below:

Depreciation Expense = (Cost of Fixed Asset - Salvage Value) / Useful Life

To illustrate how the straight-line method works, let’s take a concrete example.

Assume Company A purchases equipment for $17,000, with an estimated salvage value of $2,000, and useful life of 5 years.

Step One: First, you need to calculate the depreciation expense for every year.

Following the depreciation expense formula above:

Depreciation Expense = ($17,000 - $2,000) / 5 = $3,000

Step Two: Now, you can build a depreciation schedule. The depreciation schedule for the entire five years in this example would look like this:

Pro: the straight-line method is the easiest to use.

However, it has a few cons:

The calculation is purely based on guesswork and doesn’t take any other factors besides life expectancy into consideration. So, if for example, an asset depreciates more during the first year of its life than the last, or if a technological advancement causes it to become obsolete sooner, the straight-line method wouldn’t provide the most accurate calculation.

2.  Double-Declining Balance

With a double-declining balance depreciation method, you write off a larger depreciation expense in the early years, and then a smaller one as years go by. More specifically, the double-declining depreciation rate is double the straight-line depreciation rate. The technique is commonly used for assets that quickly lose their value during the early years of their estimated useful life, such as vehicles, computers, and electronics.

Let’s check out a practical example and see how the depreciation of an asset changes when using the double-declining method.

Company B purchases a $30,000 vehicle, that’s expected to depreciate over 3 years, and has a residual value of $2,000.

Step One: You need to find the accelerated depreciation rate. In the double-declining balance method, the accelerated depreciation rate is the normal depreciation rate multiplied by 2.

The normal depreciation rate equals:

Depreciation Rate = 1 / Useful Life  = 1 / 3 years = 0,3 or 30%

To find the accelerated depreciation rate, you need to multiply the normal rate by two:

Accelerated Depreciation Rate = Depreciation Rate x 2 = 0,3 x 2 = 0.6 or 60%

Step Two: Now, you’ll need to compute the depreciation expense for each year, and build the depreciation schedule. We use the acquisition cost (cost of buying the vehicle) as a depreciable amount. In other words, if there is a residual value, it is not deducted from the acquisition cost at the beginning, but rather at the last year.

Step Three: As we’ve mentioned, in the final year, you don't multiply the book value (depreciable amount) with an accelerated depreciation rate. You only deduct the residual value from the depreciable amount.

Now you may be wondering: why and when should I use the accelerated method?

Its huge advantage: If you want to pay less in taxes, this method is your best option.

Why? Well, as the double-declining method increases the amount of depreciation you record, it can substantially reduce both taxable income and tax payments for a certain time.

However, if you’re a publicly owned company that wants to appear more profitable in the eyes of investors and stakeholders then we’d recommend using the straight-line method, instead.

3.  Sum-of-the-Year’s-Digits

Another accelerated method businesses may use for assets that tend to lose most of their value during the beginning of their useful lives, is the sum-of-the-year’s-digits (SYD).

To use the method, first, you need to add up the years of the asset’s expected life. So, assume an asset that costs $225,000, has a five-year useful life. The calculation would be:

1 + 2 + 3 + 4 + 5 = 15

Then, for the first year you need to divide the asset’s useful life - in this case, 5 - by the sum of 15. Then you multiply that value by the total depreciable amount (which in our case is $225,000), as shown below:

5 years / 15 x $225,000 = $75,000

So, for the first year, depreciation would amount to $75,000. The formula stays the same for the subsequent years, the only thing that changes is the numerator - it’s reduced by one each year.

This is how the full depreciation schedule would look like:

The pro here is that businesses may benefit from the SYD method as the practice results in a larger tax guard in the first few years of the asset’s life, similar to the double-deciding balance.

4.  Units-of-Production

Depreciation under the units-of-output method is based on some measure of output rather than the passing of time. That’s why, when depreciation is based on units of output, more depreciation is recorded during the cycles when the assets are used up the most.

To calculate it, step one involves measuring the units of production rate.

The formula goes as follows:

Units of Production Rate = (Cost Basis – Salvage Value) / Estimated Units

So, if a business were to purchase a delivery truck that costs $10,000, with a salvage value of $1,000, which is expected to retire after it has been driven 30,000 miles, the units of production rate would be:

Units of Production Rate = ($10,000 - $1,000) / 30,000 = $0,3 Depreciation per Mile

Step two involves calculating the depreciation expense, which comes from multiplying the actual units produced with the units of production rate. If during the first year, the delivery truck drove $5,000 miles, then the depreciation expense would be:

Depreciation Expense = 5,000 miles x $0,3 = $1,500

The same calculations are repeated at the end of each year until the asset reaches its estimated salvage value.

Now, because the units-of-production method depends on the measures of output that a vehicle or equipment incurs during the year, you can’t create a depreciation schedule purely out of estimation. The schedule is generated at the end of each year, based on the exact percentage that an asset’s capacity was used up during that year.

What are the pros and cons of this type of depreciation?

Well, the units-of-production method ensures that expenses and revenues are properly connected, and comply with the matching principle. However, the method can only be used if the total number of output units can be approximated with great precision.

Additionally, the method is also limited to assets such as vehicles and certain types of machinery. Buildings, computers, and furniture, for example, do not have well-defined units of output and thus can’t be calculated through this depreciation method.

Automate Your Depreciation Schedule with Accounting Software

Don’t want to manually calculate and record your depreciation schedules by hand or on Excel spreadsheets? Then go digital with cloud accounting software like Deskera!

With our Depreciation Schedule, it only takes a few seconds to set up and automate your asset depreciation.

All you have to do is enter the name of the fixed asset you want to depreciate, the method of depreciation, the time interval you want to expense it in, and press Post.

Deskera Depreciation Schedule
Deskera Depreciation Schedule

The software will then automatically create your depreciation schedule, and post the correct journal entry, with the corresponding debit and credit balances.

Automatic Depreciation Schedule Journal Entries with Deskera
Automatic Depreciation Journal Entries with Deskera

Give Deskera a try out yourself right away, by signing up for our completely free trial. No credit card details necessary.

Frequently Asked Questions

#1: Do All Fixed Assets Have to Be Depreciated?

Generally yes, but there are a few exceptions.

Every depreciable asset is a fixed asset, but not all fixed assets can be depreciated. Land, for example, is a fixed, non-depreciable asset as its value doesn’t diminish over time. Invaluable collectibles such as artwork or sculptures, can’t be depreciated either.

#2: What Causes Depreciation?

The main reason depreciation occurs is due to the wear and tear of assets. After a certain period of usage, an asset itself or its parts need to be replaced or upgraded.

Depreciation also occurs due to new technological advancements, which may cause inefficiencies and reduce the usability and popularity of older machinery and equipment.

Other possible causes of depreciation include the expiration of usage rights, the perishability of assets with a short life span, and the depletion of natural resources.

#3: What’s the Difference Between Depreciation and Amortization?

Accumulated depreciation is the process of depreciating tangible assets over their expected useful life. Whereas amortization spreads the cost of intangible goods that last more than a year, such as patents, trademarks, and copyrights.

#4: Is Accumulated Depreciation an Asset?

No, accumulated depreciation is not an asset. For an account to be considered an asset account, it needs to be able to provide economic benefit and earn the company a profit.

Accumulated depreciation is in fact, a contra-asset account, as it’s created to reduce the value of an asset. It’s used to recognize the loss of usability of a long-term entity so that expenses are recognized at the time they occur.

If you want to know more about the different types of accounts and how to record them, check out our double-entry bookkeeping guide with practical examples.

Key Takeaways

And that’s a wrap! We hope this guide helped you understand all of the basics of the depreciation schedule, and how you can create one for your small business’s assets.

For a quick recap, here are some of the main points we’ve covered:

  • Depreciation represents how much an asset’s value has been used up. For an asset to qualify as a depreciable one it needs to have a useful life greater than a year, the business has to own it, and it should be used to generate profit.
  • The depreciation schedule is the table that keeps track of the depreciation expense over the years. It includes elements such as the date of purchase, cost of the asset, estimated/expected useful life, salvage value, current year depreciation, accumulated depreciation, the depreciation method used, and the net book value.
  • There are four main methods of depreciation: the straight-line method, double-declining balance, sum-of-the-year’s-digits, and the units-of-production.
  • If you’re looking to decrease your taxable income and pay less in taxes at the end of the year, the double-declining and sum-of-the-year’s-digits are of best use. The opposite applies to the straight-line method.
  • For vehicles and other machinery that have a measure of output, the unit-of-production depreciation is the most accurate.
Closing Entries: Definition, Types, and Examples
Every financial transaction goes through an accounting cycle[https://www.deskera.com/blog/accounting-cycle/]: a multi-step process that records,summarizes, and organizes your transactions into financial statements. After most of the cycle is completed and financial statements[https://www.deskera.com/blog/financial-statements/…
What Is An Expense Report? Guide for Small Businesses
Sometimes, employees have to pay for business expenses[https://www.deskera.com/blog/business-expenses/] from their own pockets. Whether that’s fortravel accommodation, business lunches, or office supplies, part of your job asa business owner is to reimburse them for those expenses. That’s where …
The Basics of Cost Accounting
All types of businesses, whether they provide services, manufacture products, orsell merchandise have costs, and thus, require cost accounting to track theiractivities. In a nutshell, cost accounting is the process that helps managersunderstand what it costs to run a business. Cost accounting ke…


Hey! Try Deskera Now!

Everything to Run Your Business

Get Accounting, CRM & Payroll in one integrated package with Deskera All-in-One.

Great! Next, complete checkout for full access to Deskera Blog
Welcome back! You've successfully signed in
You've successfully subscribed to Deskera Blog
Success! Your account is fully activated, you now have access to all content
Success! Your billing info has been updated
Your billing was not updated