Task 2 - Depreciation

You are required to calculate the depreciation for each year owned on the following piece of equipment in accordance with the organisations policies and procedures.

Equipment:             Coffee Machine

Purchase Price:     $12,000

Purchase Date:     1 July 2017

Life of equipment:    4 years

Depreciation rate:    25%

Resale value:             $2,000

Create an Excel spreadsheet for your calculations. 

a) Create one worksheet showing the Coffee Machine calculations

b) Save a second copy of the worksheet which can be used as a template for other assets. The second copy should contain your headings and formulas but no figures.