DEPRECIATION METHODS
Initial Value: Estimated Salvage Value: Useful Life: Estimated productive capacity (time units): 100,000 10,000 5 40,000
Straight-Line Method
Year 1 2 3 4 5 Depreciable Amount 90,000.00 90,000.00 90,000.00 90,000.00 90,000.00 Depreciation Rate 20.00% 20.00% 20.00% 20.00% 20.00% Depreciation Expense 18,000 18,000 18,000 18,000 18,000
Double -Declining Balance Method
Year 1 2 3 4 5 Depreciable Amount 100,000.00 60,000.00 36,000.00 21,600.00 12,960.00 Depreciation Rate 40.00% 40.00% 40.00% 40.00% 22.84% Depreciation Expense 40,000 24,000 14,400 8,640 2,960
Units of Production Method
Year 1 2 3 4 Depreciable Amount 90,000 90000 90000 90000 Depreciation Per Unit 2.25 2.25 2.25 2.25 Hours Used 10,000 10,000 5,000 15,000
Accumulated Depreciation 18,000 36,000 54,000 72,000 90,000
Year-End Book Value 82,000 64,000 46,000 28,000 10,000
Accumulated Depreciation 40,000 64,000 78,400 87,040 90,000
Year-End Book Value 60,000 36,000 21,600 12,960 10,000
Depreciation Expense 22,500 22,500 11,250 33,750
Accumulated Depreciation 22,500 45,000 56,250 90,000
Year-End Book Value 77,500 55,000 43,750 10,000
Double Rate 1 2 3 4 5 6 7 8 9 10 1 minus FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE
0.4 0.6 TRUE 60000 36000 21600 12960 7776 200000 200000 200000 200000 200000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000
Follow the steps to enable your Depreciation Calculator.
>> This template is prepared for calculating and simulating depreciation using 3 different methods: 1. 2. 3. >> 1) Single Line Method Double -Declining Balance Method Units of Production Method
Your Depreciation Calculator is ready to use. Following steps are for online use. Visit the site below: http://www.spreadsheetweb.com/getting_started.htm You will only need the username and password to create your Depreciation Calculator.
2)
Visit the site below: http://trial.spreadsheetweb.com/spreadsheetweb/ Login to page with your new account information.
3) >> >>
Click "Add Web Application" to upload this file. Your Depreciation Calculator will be created automatically. You can simply use the Depreciation Calculator from that link or place it on your website. Your Depreciation Calculator will look like: http://www1.spreadsheetweb.com/SpreadSheetWeb/Output.aspx?ApplicationId=cbf74d5c-d602-4937-a2a1-a0cc71de0a76 In order to see more online applications created with PSW you can check the link below: http://www.spreadsheetweb.com/demos.htm
Copyright (c) 2009 Pagos, Inc. http://www.pagos.com/
7-a2a1-a0cc71de0a76