Question

From the following details, calculate depreciation of machinery under written down value method using spreadsheet.

Name of asset	Machinery
Date of purchase	10-5-2009
Date of installation	20-5-2009
Purchase cost	200000
Installation cost	30000
Pre operating cost	20000
Salvage value	10,000
Expected life of asset	8 years
1st year end date	31/3/2010

Answer 1

Step 1 – Open a new blank worksheet in LibreOffice Calc. 

Step 2 – Enter the given data in respective cells.

Output:

Depreciation

75854.17