Steph L.

asked • 09/15/13

ACCOUNTING DEPRECIATION QUESTION, URGENT HELP NEEDED!

Calculating Depreciation 
 
 
**ABOUT FIXED ASSET**
COST:150,000
SALVAGE VALUE: 12,000
LIFE: 5 YEARS
UNITS OF OUTPUT: 138,000
 
UNITS OF OUTPUT IN YEARS 1-5
YEAR 1: 60,000
YEAR 2: 50,000
YEAR 3: 20,000
YEAR 4: 5,000
YEAR 5: 3,000
 
I NEED TO KNOW STRAIGHT LINE DEPRECIATION, UNITS OF OUTPUT, AND DOUBLE DECLINING BALANCE. IN ALL THREE FORMS, I NEED THE CALCULATIONS, ANNUAL DEPRECIATION, ACCUMULATED DEPRECIATION, AND BOOK VALUE FOR YEARS 1-5. THIS IS TO BE INPUTTED INTO AN EXCEL SHEET.
 
 
 
 
I AM REALLY IN NEED OF AN ANSWER BECAUSE I NEED TO USE THIS AS AN EXAMPLE TO TEACH MYSELF SO I CAN DO THE ACTUAL WORK TONIGHT. PLEASE HELP!  

2 Answers By Expert Tutors

By:

Sherryse H. answered • 10/29/14

Accounting, Income Tax, Excel

Alan B. answered • 09/18/13

Be Successful in Microsoft Office, Personal Finance, Business, or Golf

Still looking for help? Get the right answer, fast.

Ask a question for free

Get a free answer to a quick problem.
Most questions answered within 4 hours.

OR

Find an Online Tutor Now

Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.