Question

On 1^st April 2000, a company purchased a Machinery for Rs. 20,00,000, The installation charge is 50,000, pre-operation expenses are 1,50,000 and its salvage value is calculated Rs. 1, 00,000. Life of machinery is estimated to 15 years. Calculate depreciation under straight line method.

Answer 1

Procedure: 

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

Step 2 – Enter the following data/formula in the following way.

Output:

Depreciation

1,40,000