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!