Use Sophia to knock out your gen-ed requirements quickly and affordably. Learn more
×

Case Study: Depreciation

Author: Sophia

what's covered
This lesson will cover performing a depreciation calculation using several different methods, in the context of a case study using a hypothetical company. Specifically, this lesson will cover:

Table of Contents

1. Case Study: Legacy Clothing

The subject company for our case study is called Legacy Clothing. Legacy Clothing is a sole proprietorship, which is a type of company that is owned by a single individual, and where that individual and the business are legally treated as the same.

The purpose of Legacy Clothing as a business is to own and operate clothing/merchandise stores. It is similar to a department store chain, selling men's, women's, and children's clothing and other related items.

Legacy Clothing has locations throughout Washington, DC, and they have a staff of 50 people employed in their stores.

Legacy Clothing
Type of company Sole proprietorship
Business purpose Own and operate clothing/merchandise stores
Business location(s) Washington, D.C.
Staff of 50 people

Legacy Clothing needs to calculate depreciation. As a company, they have long-term assets such as buildings, equipment, etc. Those assets are used over multiple periods, so those assets provide benefits to multiple periods.

Legacy Clothing needs to allocate the cost of those assets over those multiple usage periods. This allows them to achieve matching--the matching of cost and benefits. They are matching the cost of the asset through depreciation expense, and the benefit being received through revenue--in other words, matching expense with revenue.


2. Case Study: Straight Line Depreciation

Now let's look at performing some depreciation calculations for our subject company, Legacy Clothing, starting with a straight line depreciation calculation. The information we need to know in order to perform straight line depreciation is our total cost, residual value, as well as the useful life.

As you can see in the spreadsheet below, the formula for straight line depreciation is cost minus residual value divided by the number of years of the useful life.

formula to know
Straight Line Depreciation
Straight space Line space Depreciation equals fraction numerator Cost minus Residual space Value over denominator Number space of space Years space of space Useful space Life end fraction

2a. Buildings

The first calculation that we're going to perform is straight line depreciation on the asset buildings. So, let's go ahead and put the information in for our subject company.

We have buildings with a cost of $500,000, and we assume there is no residual value for those buildings. We're also going to assume those buildings have a useful life of 25 years.

  • Total cost: $500,000
  • Residual value: $0
  • Asset's useful life: 25 years
Plugging in this information--cost minus residual value divided by the number of years of useful life--we get our straight line depreciation of $17,000. This is going to be our depreciation expense every year under straight line depreciation.

Straight space Line space Depreciation table attributes columnalign left end attributes row cell equals fraction numerator Cost minus Residual space Value over denominator Number space of space Years space of space Useful space Life end fraction end cell row cell equals fraction numerator $ 500 comma 000 minus $ 0 over denominator 25 end fraction end cell row cell equals fraction numerator $ 500 comma 000 over denominator 25 end fraction end cell row cell equals $ 20 comma 000 end cell end table

Now, we can break our our annual depreciation expense into monthly depreciation by dividing by 12, the number of months in a year.

Monthly space Depreciation equals fraction numerator $ 20 comma 000 over denominator 12 end fraction equals $ 1 comma 666.67

Also, if we wanted to know the total accumulated depreciation in any point throughout this asset's life, we can look at a specific number of months. For instance, in this case, after 60 months, or five years, our total accumulated depreciation is going to be $83,333.40, which is our monthly depreciation multiplied by 60.

60 minus Month space Depreciation equals $ 1 comma 666.67 cross times 60 equals $ 100 comma 000.20

2b. Equipment

Now we're going to perform the same straight line calculation, but in this case, for equipment, another fixed asset that we need to depreciate. Again, we need to know total cost, residual value, and the useful life.

We have $200,000 worth of equipment and a residual value of $10,000 for that equipment. That equipment has a useful life of 10 years.

  • Total cost: $200,000
  • Residual value: $10,000
  • Asset's useful life: 10 years
So, if we look at our straight line depreciation formula, cost minus residual value divided by the number of years of useful life, we can plug in that information, $190,000 divided by 10. This means that our straight line depreciation every year is going to be $19,000.

Straight space Line space Depreciation table attributes columnalign left end attributes row cell equals fraction numerator Cost minus Residual space Value over denominator Number space of space Years space of space Useful space Life end fraction end cell row cell equals fraction numerator $ 200 comma 000 minus $ 10 comma 000 over denominator 10 end fraction end cell row cell equals fraction numerator $ 190 comma 000 over denominator 10 end fraction end cell row cell equals $ 19 comma 000 end cell end table

Again, we can break that amount into monthly depreciation by dividing the straight line number by 12.

Monthly space Depreciation equals fraction numerator $ 19 comma 000 over denominator 12 end fraction equals $ 1 comma 583.33

In addition, we can figure out the total accumulated depreciation at any point in time by plugging in the number of months that we're looking for. So, after 48 months, if we take our monthly depreciation and multiply it by 48, we would get $75,999.84.

48 minus Month space Depreciation equals $ 1 comma 583.33 cross times 48 equals $ 75 comma 999.84

watch


3. Case Study: Double Declining Balance Depreciation

Now let's turn our attention to another method of depreciation, double declining balance. We need the same information as before: total cost, residual value, as well as the useful life.

Also before we start, recall the formula for the depreciation expense with double declining balance:

formula to know
Double Declining Balance
Depreciation space Expense equals Book space Value cross times Rate space of space Depreciation

3a. Buildings

Let's start with our buildings, using the same information as before.

step by step
  1. Determine Straight Line Rate of Depreciation. Our buildings cost $500,000 with a useful life of 25 years, so the straight line depreciation was $20,000. Turning this into a percent, the straight line deprecation percentage is $20,000 divided by $500,000, or 4%. This means that every year, 4% of that asset would be depreciated.

    Straight space Line space Depreciation open parentheses $ close parentheses equals 500 comma 000 divided by 25 equals 20 comma 000
Straight space Line space Depreciation open parentheses percent sign close parentheses equals fraction numerator 20 comma 000 over denominator 500 comma 000 end fraction equals 0.04 equals 4 percent sign

    View this spreadsheet in Google Sheets
  2. Double Straight Line Depreciation Rate. Now, to calculate the double declining rate, we simply take that 4% straight line depreciation rate and multiply it by 2 to get a double declining balance percentage of 8%.

    Double space Declining space Balance space open parentheses percent sign close parentheses equals Straight space Line space Deprecation space open parentheses percent sign close parentheses cross times 2 equals 4 percent sign cross times 2 equals 8 percent sign

    View this spreadsheet in Google Sheets
  3. Apply Double Declining Rate to Initial Value. Now we need to prepare our depreciation table, starting with the year. So, if we look at year one, beginning book value is 500,000. We have a depreciation rate of 8%, so our depreciation expense is $40,000.

    Depreciation space Expense equals Book space Value cross times Depreciation space Rate equals 500 comma 000 cross times 8 percent sign equals 40 comma 000

    Table named Buildings for Legacy Clothing. The items and entries for double declining balance depreciation has six columns with entries as follows: Year 1, Book value (beginning of year) $500,000, Depreciation rate 8%, Depreciation expense $40,000.
    View this spreadsheet in Google Sheets
  4. Document Accumulated Depreciation. For this column, add up the total accumulated depreciation. For the first year, the accumulated depreciation will be the same value as the depreciation expense. For subsequent years, as you will see in a later step, you will add the depreciation expense for that year to the accumulated depreciation.

    Table named Buildings for Legacy Clothing. The items and entries for double declining balance depreciation has six columns with entries as follows: Year 1, Book value (beginning of year) $500,000, Depreciation rate 8%, Depreciation expense $40,000, Accumulated depreciation $40,000.
    View this spreadsheet in Google Sheets
  5. Subtract Depreciation Expense from Book Value. When we subtract the depreciation expense of $40,000 from the initial book value of $500,000, the book value at the end of the year, then, would be $460,000.

    Book space Value space left parenthesis End space of space Year right parenthesis equals Book space Value space left parenthesis Beg. space of space Year right parenthesis minus Depreciation space Expense equals 500 comma 000 minus 40 comma 000 equals 460 comma 000

    Table named Buildings for Legacy Clothing. The items and entries for double declining balance depreciation has six columns with entries as follows: Year 1, Book value (beginning of year) $500,000, Depreciation rate 8%, Depreciation expense $40,000, Accumulated depreciation $40,000, Book value (end of year) $460,000.
    View this spreadsheet in Google Sheets
  6. Carry Over Book Value and Repeat. Note that this ending book value of year one becomes our beginning book value in year two, and we go through the same process of multiplying it by the depreciation rate to get to the depreciation expense.

    As you can also see below, we add the current year's depreciation expense to the accumulated depreciation from the prior year to get the current year's accumulated depreciation. For instance, in Year 2, there was a depreciation expense of $36,800 and that got added to the accumulated deprecation of $40,000 from the previous year for a total accumulated depreciation of $76,800.

    Finally, notice that in year 30, because this asset has a 30-year useful life and no residual value, we would record $67,589 of depreciation expense in order to bring the book value at the end of 30 years to zero.

    Table named Buildings for Legacy Clothing. The items and entries for double declining balance depreciation has six columns with entries as follows: Year 1, Book value (beginning of year) $500,000, Depreciation rate 8%, Depreciation expense $40,000, Accumulated depreciation $40,000, Book value (end of year) $460,000; Year 2, Book value (beginning of year) $460,000,
Depreciation rate 8%, Depreciation expense $36,800, Accumulated depreciation $76,800, Book value (end of year) $423,200; Year 3, Book value (beginning of year) $423,200, Depreciation rate 8%, Depreciation expense $33,856, Accumulated depreciation $110,656 Book value (end of year) $389,344; Year 4, Book value (beginning of year) $389,344, Depreciation rate 8%, Depreciation expense $31,148, Accumulated depreciation $141,804, Book value (end of year) $358,196; Year 5, Book value (beginning of year) $358,196, Depreciation rate 8%, Depreciation expense $28,656, Accumulated depreciation $170,460, Book value (end of year) $329,540. This continues to the final row: Year 25, Book value (beginning of year) $67,589, Depreciation rate 8%, Depreciation expense $67,589, Accumulated depreciation $500,000, Book value (end of year) is $0.
    View this spreadsheet in Google Sheets

3b. Equipment

Now we're going to do that same calculation for our equipment, and just like before, we need the total cost, residual value, and useful life.

step by step
  1. Determine Straight Line Rate of Depreciation. We're going to use the same information as before, inputting a total cost of $200,000, residual value of $10,000, and a useful life of 10 years, which results in a straight line depreciation percentage of 10%. Therefore, 10% of this equipment is being depreciated every year under the straight line method.

    Straight space Line space Depreciation open parentheses $ close parentheses equals 200 comma 000 divided by 10 equals 20 comma 000
Straight space Line space Depreciation open parentheses percent sign close parentheses equals fraction numerator 20 comma 000 over denominator 200 comma 000 end fraction equals 0.1 equals 10 percent sign

    View this spreadsheet in Google Sheets
  2. Double Straight Line Depreciation Rate. Again, for double declining balance, we double that straight line depreciation rate to get 20%.

    Double space Declining space Balance space left parenthesis percent sign right parenthesis equals Straight space Line space Depreciation space left parenthesis percent sign right parenthesis cross times 2 equals 10 percent sign cross times 2 equals 20 percent sign

    View this spreadsheet in Google Sheets
  3. Apply Double Declining Rate to Initial Value. Now we can populate our double declining balance depreciation table, going through the same process. In year one, we have a beginning book value of $200,000, which is the equipment's cost.

    Under double declining balance, we have a depreciation rate of 20%, so we multiply the book value by that depreciation rate to arrive at a depreciation expense of $40,000.

    Depreciation space Expense equals Book space Value cross times Depreciation space Rate equals 200 comma 000 cross times 20 percent sign equals 40 comma 000
    Table named Equipment for Legacy Clothing. The items and entries for double declining balance depreciation has six columns with entries as follows: Year 1, Book value (beginning of year) $200,000, Depreciation rate 20%, Depreciation expense $40,000.
    View this spreadsheet in Google Sheets
  4. Document Accumulated Depreciation. Again, for the first year, the accumulated depreciation will be the same value as the depreciation expense. For subsequent years, as you will see in a later step, you will add the depreciation expense for that year to the accumulated depreciation.

    Table named Equipment for Legacy Clothing. The items and entries for double declining balance depreciation has six columns with entries as follows: Year 1, Book value (beginning of year) $200,000, Depreciation rate 20%, Depreciation expense $40,000, Accumulated depreciation $40,000.
    View this spreadsheet in Google Sheets
  5. Subtract Depreciation Expense from Book Value. To find the book value at the end of year one, subtract $40,000 from $200,000, which is $160,000.
    Book space Value space left parenthesis End space of space Year right parenthesis equals Book space Value space left parenthesis Beg. space of space Year right parenthesis minus Depreciation space Expense equals 200 comma 000 minus 40 comma 000 equals 160 comma 000

    Table named Equipment for Legacy Clothing. The items and entries for double declining balance depreciation has six columns with entries as follows: Year 1, Book value (beginning of year) $200,000, Depreciation rate 20%, Depreciation expense $40,000, Accumulated depreciation $40,000, Book value (end of year) $160,000.
    View this spreadsheet in Google Sheets
  6. Carry Over Book Value and Repeat. $160,000 becomes our beginning book value at the beginning of year two, and repeat this process for each following year.

    Notice, though, what happens when we get down to year 10. Because this asset has a useful life of 10 years, we do not record 20% depreciation. Instead, we would record whatever depreciation gets us to $10,000 residual value. Because we are in the last year of the asset's useful life, we don't depreciate it to zero. We can only depreciate it to the residual value, but not beyond that point.

    Table named Equipment for Legacy Clothing. The items and entries for double declining balance depreciation has six columns with entries as follows: Year 1, Book value (beginning of year) $200,000, Depreciation rate 20%, Depreciation expense $40,000, Accumulated depreciation $40,000, Book value (end of year) $160,000; Year 2, Book value (beginning of year) $160,000,
Depreciation rate 20%, Depreciation expense $32,000, Accumulated depreciation $72,000, Book value (end of year) $128,000; Year 3, Book value (beginning of year) $128,000, Depreciation rate 20%, Depreciation expense $25,600, Accumulated depreciation $97,600, Book value (end of year) $102,400; Year 4, Book value (beginning of year) $102,400, Depreciation rate 20%, Depreciation expense $20,480, Accumulated depreciation $118,080, Book value (end of year) $81.920; Year 5, Book value (beginning of year) $81,920, Depreciation rate 20%, Depreciation expense $16,384, Accumulated depreciation $134,464, Book value (end of year) $65,536. This continues to the final row: Year 10, Book value (beginning of year) $26,843, Depreciation rate 20%, Depreciation expense $16,843, Accumulated depreciation $190,000, Book value (end of year) is $10,000.
    View this spreadsheet in Google Sheets

watch

summary
Today we introduced our case study company called Legacy Clothing, a department store selling men's, women's, and children's clothing and other related items. We explored examples of calculating depreciation on two fixed assets, buildings and equipment, using two methods: straight line depreciation and double declining balance depreciation.

Source: THIS TUTORIAL WAS AUTHORED BY EVAN MCLAUGHLIN FOR SOPHIA LEARNING. PLEASE SEE OUR TERMS OF USE.

Formulas to Know
Double Declining Balance

Depreciation space Expense equals Book space Value cross times Rate space of space Depreciation

Straight Line Depreciation

Straight space Line space Depreciation equals fraction numerator Cost minus Residual space Value over denominator Number space of space Years space of space Useful space Life end fraction