Use app×
Join Bloom Tuition
One on One Online Tuition
JEE MAIN 2025 Foundation Course
NEET 2025 Foundation Course
CLASS 12 FOUNDATION COURSE
CLASS 10 FOUNDATION COURSE
CLASS 9 FOUNDATION COURSE
CLASS 8 FOUNDATION COURSE
0 votes
275 views
in Use of Spread Sheet in Business Application by (25.6k points)
closed by

From the following details, calculate depreciation underwritten down value Method.

Name of Asset Filling machine Packing machine
Purchase cost 877000 123000
Date of purchase 11/7/2008 3/5/06
Installation date 17/7/2008 07/5/06
Installation expenses 11000 8000
Pre operation expenses 3000 2500
Salvage value 45000 17000
Life in years 7 7
1st year closing date 31/3/2009 31/3/2007

1 Answer

+1 vote
by (27.3k points)
selected by
 
Best answer

Procedure: 

Step 1 – Open a new blank worksheet in LibreOffice Calc

Step 2 – Enter the following data in the respective cells.

Output :

Depreciation – Filling Machine 2,31,882.75
Depreciation – Packing Machine 31,205.63

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

...