A large industrial boiler costs R7 500 000 and has a useful life of 30 years. It is estimated that the salvage value (SV
Posted: Tue Apr 26, 2022 9:58 am
A large industrial boiler costs R7 500 000 and has a useful life
of 30 years. It is estimated that the salvage value (SV) at the end
of year 30 years is R600 000. Populate the relevant Microsoft Excel
spreadsheets within the attached workbook and calculate the annual
depreciation (dk), cumulative depreciation (d*k) and book value
(BVk) for years 1–30 using the:
1.1. Straight-line method
1.2. 200%declining balance method and
1.3. 150% declining balance method
Set all numeric entries and output in Excel to zero decimal
places.
of 30 years. It is estimated that the salvage value (SV) at the end
of year 30 years is R600 000. Populate the relevant Microsoft Excel
spreadsheets within the attached workbook and calculate the annual
depreciation (dk), cumulative depreciation (d*k) and book value
(BVk) for years 1–30 using the:
1.1. Straight-line method
1.2. 200%declining balance method and
1.3. 150% declining balance method
Set all numeric entries and output in Excel to zero decimal
places.