In: Accounting
Please Solve the following problem | |||||||||
A Hospital just acquired new equipment. The equipment cost $4,250,000 and | |||||||||
the organization spent $135,000 on upgrading the physical plant where the equipment | |||||||||
will be located. The equipment is expected to have a 10-year useful life and a salvage | |||||||||
value of 10% ($425,000), Calculate the first five years of depreciation using | |||||||||
straight line, double declining balance, and sum-of-the-years digits. | |||||||||
Please show solutions to the following | |||||||||
below. | |||||||||
Asset Cost: | |||||||||
Salvage Value: | |||||||||
Asset Life: | |||||||||
Straight-line Depreciation Each Year | #DIV/0! | ||||||||
Asset Cost: | $0 | Asset Cost: | $0 | ||||||
Salvage Value: | $0 | Salvage Value: | $0 | ||||||
Asset Life: | 0 | Asset Life: | 0 | ||||||
Depreciation Year | Depreciation Year | ||||||||
Sum of the Years Digits Depreciation | #NUM! | Double Declining Balance Depreciation | #NUM! | ||||||
Straight Line | Double Declining Balance | Sum-of-the years Digits | |||||||
Annual | Accumulated | Annual | Accumulated | Annual | Accumulated | ||||
Year | Depreciation | Depreciation | Depreciation | Depreciation | Depreciation | Depreciation | |||
1 | $0 | $0 | $0 | ||||||
2 | $0 | $0 | $0 | ||||||
3 | $0 | $0 | $0 | ||||||
4 | $0 | $0 | $0 | ||||||
5 | $0 | $0 | $0 | ||||||
The Depreciation formulas for three methods are:
Straight line method: (Cost of the asset - Salvage Value) / Useful life of asset
Double depreciation method: Straight line depreciation x 2
Sum of years digits method: (Cost of asset - Salvage value) x Remaining useful life/Sum of useful years.
Cost of the asset: Cost of asset includes purchase price including the cost of installation.
So the cost of asset = $4250000 + $135000 = $4385000
Straight line method: (4385000 - 425000) / 10 = $396000
Double decline depreciation = Straight line method depreciation x 2 = $396000x2 = $792000
Year | Straight line method depreciation | Accumulated depreciation | Double depreciation method | Accumulated depreciation | Sum of years digits method | Accumulated depreciation |
1 | $396000 | $396000 | $792000 | $792000 | 3960000x10/55=$720000 | $720000 |
2 | $396000 | $792000 | $792000 | $1584000 | $3960000x9/55=$648000 | $1368000 |
3 | $396000 | $1188000 | $792000 | $2376000 | $3960000x8/55=$576000 | $1944000 |
4 | $396000 | $1584000 | $792000 | $3168000 | $3960000x7/55=$504000 | $2448000 |
5 | $396000 | $1980000 | $792000 | $3960000 | $3960000x6/55=$432000 | $2880000 |
PS: Please use "Thums Up" if you are contented with my solution and presentation.