Skip to main content

Worksheet on Depreciation

Worksheet on Depreciation

ROEHAMPTON ROEHAMPTON INSTITUTE LONDON ROEHAMPTON
An Institute Of The University Of Surrey
ROEHAMPTON

Worksheet written by PGCE Business students at the Roehampton Institute.

What is Depreciation?

Fixed assets (eg: cars, fixtures and fittings, plant and machinery etc) can be used again and again until they wear out. During this time the value of many assets fall. This is called depreciation. Some fixed assets (eg: land and property) do not depreciate although they still have to be maintained and repaired.

Write down 5 fixed assets that you might expect to find in a school or college:

1



2



3



4



5





Give 3 reasons (explain each) why fixed assets might fall in value:

1







2







3









Methods of Depreciation

1 Straight line method

This is the most common method used to work out depreciation. It assumes that the net cost of an asset should be written off in equal amounts over its life. The accountant needs to know the cost of the asset, its estimated 'scrap' (or residual) value and its expected life in years. The formula used is:

Original cost - scrap value
Expected life (years)

Assume you buy a vehicle for £12,000 and it has an expected life of 4 years. Its 'scrap' value is estimated to be £4,000. What is the depreciation allowance per year?



To see how this works in practice, go to the Exchange and Mart homepage (http://www.exchangeandmart.co.uk) and carry out the following steps:-

  • go to the used car price guide
  • choose a 3 models of cars that have been around for a few years
  • fill in the table below with their value on the most recent date available, and the oldest date available
  • work out the depreciation allowance each year
Model / make Price in year ________ Price in year ________ Depreciation allowance

How much does the rate of depreciation differ?









Go back to the Exchange and Mart homepage (http://www.exchangeandmart.co.uk) and try another three cars. Try to find ones that you would expect to depreciate at different rates.

Model / make Price in year ________ Price in year ________ Depreciation allowance

Did you succeed in finding different depreciation rates? If you did, why do you think this happened?











2 Reducing balance method

This method assumes that the depreciation charge in the early years of an asset's life should be higher than in later years. The asset must, therefore, be written off using the same percentage rate each year.

A vehicle is bought for £28,000 and has a life of 4 years. Using the reducing balance method (a 40% charge is to be made each year) calculate book value of the vehicle at the end of every year.

Year Depreciation allowance
(each year) (£)
Book value (£)
1 11,200 (28,000 x 40%) 16,800
2 6,720 (16,800 x 40%)
3 4,032
4 2,419

Plot a graph on the axes below using the information you calculated above (book value y axis, years x axis).

Note: y to the sky, so this means x axis goes along the bottom!

Axes

Would you expect cars to depreciate according to the straight line, or the reducing balance method? Why?











To test this, go back to the Exchange and Mart homepage (http://www.exchangeandmart.co.uk) and once again choose a model of car, but this time take the value for each year. Fill the results in in the table below, and work out in the last column the percentage by which the car has depreciated each year:-

Model _________________ Price each year Change in price Depreciation (%)
Year:
Year:
Year:
Year:
Year:
Year:
Year:
Year:
Year:
Year:

Now plot this on the graph below, with the same axes as before:-

Axes

Which method of depreciation would therefore have been the most effective?



Extension activity

Go to the J Sainsbury annual report (http://www.jsainsbury.co.uk/index.asp?pageid=20) and print out the accounts.

In your own words, using your knowledge in this area so far, try and interpret this information and write below an explanation of the figures on the assumption that the person reading knows nothing about depreciation.
























Comments

Popular posts from this blog

Interactive Worksheet: The Accounting Equation

by Ken Delaney-Moore, Sheffield Hallam University Aims: This worksheet deals with: The accounting equation. The accounting concepts of 'business entity' and 'dual aspect'. The effects of transactions on the balance sheet. After having completed the worksheet you should be better able to perform to syllabus specifications relating to these points. When you are done, please fill-in the on-line evaluation form in order for us to monitor the quality of the materials we provide for you. Tell us what we're doing right and wrong. It takes very little time, and your opinions are valued - thank you. A business start-up Imagine that 'Jim Sayers' puts £5,000 of his personal savings into a business bank accoun...

MEMBUAT DATABASE APLIKASI AKUNTANSI DENGAN MICROSOFT ACCESS 2007

Microsoft Office Access 2007 merupakan aplikasi pembuatan database yang diciptakan Raksasa Microsoft Corporation, Hingga saat ini banyak sekali perusahaan menggunakan aplikasi ini dalam membuat database untuk keperluan bisnisnya, baik dengan menggunakan 100% access, maupun dengan memanfaatkan enginenya dan menggabungkan dengan aplikasi visual lainnya seperti Visual Basic, dsb. Access 2007 merupakan dipenyempurnaan dari access 2003. Berikut ini kita akan mencoba membuat database sederhana untuk keperluan akuntansi. Untuk membuat aplikasi database akuntansi tentu diperlukan banyak tabel, query, dan report yang harus dipersiapkan. Apalagi jika akuntansi untuk perusahaan dagang, dan manufaktur. Untuk lebih memudahkan bagi pemula yang ingin belajar membuat aplikasi dengan menggunakan Microsoft office access 2007, maka disini saya akan mencoba membahas aplikasi database akuntansi sederhana untuk perusahaan jasa. dalam menyusun suatu database tentu sebelumnya kita harus menyusun normalisas...

The Current Ratio

The Current Ratio The current ratio is also known as the working capital ratio and is normally presented as a real ratio. That is, the working capital ratio looks like this: Current Assets: Current Liabilities = x: y eg 1.75: 1 The Carphone Warehouse is our business of choice, so here is the information to help us work out its current ratio. Consolidated Balance Sheet 31 March 2001 25 March 2000 £'000 £'000 Total Current Assets 315,528 171,160 Creditors: Amounts falling due within one year 222,348 173,820 As we saw in the brief review of accounts section with Tesco's financial statements, the phrase current liabilities is the same as Creditors: Amounts falling due within one year . Here's the table to fill in. OK, so we've done this one for you! Current Ratio For the Carphone Warehouse 31 March 2001 Current Assets: Current Liabilities 315,528: 222,348 1.42: 1 25 March 2000 Current Assets: Current Liabilities 171,160: 173,820 0.98: 1 Math...