Prepare a second depreciation schedule for double-declining-balance method, using the Excel function DDB. The DDB function cannot be used in the last year of the asset's useful life.

DATA Cost $ 460,000.00 Residual Value $ 40,000.00 Useful Life (Years) 4 Useful Life (Hours) 10,000 Gain End of Year 1 $ 12,000.00 Straight Line Year 1 2 3 4 Depreciable Cost $ 420,000.00 $ 420,000.00 $ 420,000.00 $ 420,000.00 Accumulated Rate Depreciation Book Value Expense Depreciation 25.00 $ 105,000.00 $ 105,000.00 $ 355,000.00 25.00 $ 105,000.00 $ 210,000.00 $ 250,000.00 25.00 $ 105,000.00 $ 315,000.00 145,000.00 25.00 $ 105,000.00 $ 420,000.00 S 40,000.00 $367,000.00 The minimum amount to sell the factory equipment in order to have a gain of $12,000 at the end of Year 1? Double Declining Balance Book Value Year Beginning of Year 1 $ 460,000.00 2 S 230.000.00 3 $ 115,000.00 4 $ 57,000.00 Depreciation Accumulated Book Value Rate Expense Depreciation End of Year 50.00 $ 230,000.00 $ 230,000.00 $ 230,000.00 50.00 $ 115,000.00 $ 345,000.00 $ 115,000.00 50.00 $ 57,500.00 $ 402.500.00 57,500.00 30.43 $ 17,500.00 $ 420,000.00 $ 40,000.00 S 242,000.00 The minimum amount to sell the factory equipment in order to have a gain of $12,000 at the end of Year 1? Units of Production Year Depreciation Per Unit 1 $ 42.00 2 $ 42.00 3 $ 42.00 4 $ 42.00 Accumulated Depreciation Machine Hours Book Value Expense Depreciation 2.900 $ 121,800.00 $ 121,800.00 $ 338,200.00 2,400 $ 100.800.00 $ 222.600.00 $ 237,400.00 2,980 $ 125,160.00 $ 347.760.00 $ 112.240.00 1.920 $ 80,640.00 $ 428,400.00 $ 31,600.00 $ 350.200.00 The minimum amount to sell the factory equipment in order to have a gain of $12,000 at the end of Year 1? Double Declining Balance using DDB function Depreciation Year Accumulated Expense Depreciation Book Value 1 2 M[ 3 4 Date Account and Explanation CR