Depreciation-2 Q- IV ## # * ABU X Arial 10 BAGI BIUD A A A1 x fx W18 = = = 2 2017 A#FF# E 27-O 5 % ) 3 ***** * * * X FREE Points Possible: 18 Use cell references linking) and Excel formulas when possible. Save your file with your name in the file name. Submit the file in canvas. Specialized equipment coating $470,000 with a five year life and an estimated $45,000 salvage value is installed in OTW s Company's factory on January 1. The factory manager estimates the machine will produce 85,000 units of product durire 10 its life. It actually produces the following units: year 1, 20,000; year 2, 15,000; year 3, 25,000, and year 4, 10 lequipment 11 was broken and replacement part did not arrhe until wear-end): year 5, 22 000. The total number of units produced by the 12 end of year 5 exceeds the original estimate this dillerence was not predicted. (The machine must not be depreciated below its estimated salvege value.) Cost Salvage Value - Depreciable Cost Straight Line - Salvage Value Useful Life in Years Depreciation Fxpense per Year Depreciation Experse Accumulated End-of-Year Book Activity Based Cost - Salvage Value Uselul Lile in Units Depreciation Expense per Unit - End of Year Boak Year Units per Year Depreciation Expense per Unit Depreciation Expense per Year Accumulated Depreciation Value Depreciation + # 2 - + 100% Depreciation-2 , X Arial v 10 x As | Bily y Avay y | al :xxx W18 | 2. 7.0. = = = === v === y 4 g, || y X ' | Double Declining Balance - Double Declinire Balance Rate Useful Ule in Years Double Dedining Depreciation End of Yaar Beak Back Value Fense per Year Accumulated Depreciation | 92 | Note: for year 5 you must make the year and book value equal to the Residual Value Therefore you will need to take the beginning book value less the Residual Value TO 171 73 When you have completed al three schedules answer the following question: 74 What do you have about the Roox Value alia ord of the son year for all the methods? 76 Type answer hereses 191 Depreciation + -- Depreciation-2 Q- IV ## # * ABU X Arial 10 BAGI BIUD A A A1 x fx W18 = = = 2 2017 A#FF# E 27-O 5 % ) 3 ***** * * * X FREE Points Possible: 18 Use cell references linking) and Excel formulas when possible. Save your file with your name in the file name. Submit the file in canvas. Specialized equipment coating $470,000 with a five year life and an estimated $45,000 salvage value is installed in OTW s Company's factory on January 1. The factory manager estimates the machine will produce 85,000 units of product durire 10 its life. It actually produces the following units: year 1, 20,000; year 2, 15,000; year 3, 25,000, and year 4, 10 lequipment 11 was broken and replacement part did not arrhe until wear-end): year 5, 22 000. The total number of units produced by the 12 end of year 5 exceeds the original estimate this dillerence was not predicted. (The machine must not be depreciated below its estimated salvege value.) Cost Salvage Value - Depreciable Cost Straight Line - Salvage Value Useful Life in Years Depreciation Fxpense per Year Depreciation Experse Accumulated End-of-Year Book Activity Based Cost - Salvage Value Uselul Lile in Units Depreciation Expense per Unit - End of Year Boak Year Units per Year Depreciation Expense per Unit Depreciation Expense per Year Accumulated Depreciation Value Depreciation + # 2 - + 100% Depreciation-2 , X Arial v 10 x As | Bily y Avay y | al :xxx W18 | 2. 7.0. = = = === v === y 4 g, || y X ' | Double Declining Balance - Double Declinire Balance Rate Useful Ule in Years Double Dedining Depreciation End of Yaar Beak Back Value Fense per Year Accumulated Depreciation | 92 | Note: for year 5 you must make the year and book value equal to the Residual Value Therefore you will need to take the beginning book value less the Residual Value TO 171 73 When you have completed al three schedules answer the following question: 74 What do you have about the Roox Value alia ord of the son year for all the methods? 76 Type answer hereses 191 Depreciation +