Hequ Use Excel to prepare depreciation schedules for straight-line. double-declining-balance. and units-of-production methods. [Always use cell references and formulas where appropriate to receive full credit. If you copy paste from the Instructions tab or if you type the numbers in, you will be marked Requirement 2 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 [Always use cell references and formulas where appropriate to receive full credit. If you copy paste from the Instructions tab or if you type the numbers in, you will be marked Requirement 3 At December 31, 2018, Fraser River is trying to determine if it should sell the factory equipment. Fraser River will only sell the factory equipment if the company earns a gain of at least $6.000. For each of the depreciation methods, what is the minimum amount that Fraser River will sell the factory equipment for in order to have a gain of $6,000 [Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab or if you type the numbers in, you will be marked "For calculations in each of the four tables below refer only to the values calculated in the same table or p DATA Cost $400,000.00 Residual Value $ 20,000.00 Useful Life (Years) Useful Life (Hours) 8,000 Gain End of Year 1 $ 6,000.00 Straight Line Depreciabl Year Rate Depreciationccumulat Book Value e Cos n Expense ed $ 380,000.00 4.00 $ 380,000.00 4.00 $ 380,000.00 4.00 $ 380,000.00 4.00 The minimum amount to sell the factory equipment in order to have a gain of $6,000 at the end of Year 1? Double Declining Balance Double Declining Balance using DDB function Book Value Depreciatio Accumulat Book Value Accumulat Year Beginning Rate Depreciatio ed of Year n Expense Depreciatio End of Year Year ed Book Value n Expense Depreciatio WN A W N The minimum amount to sell the factory equipment in order to have a gain of $6,000 at the end of Year 1? Units of Production Year Depreciatio Machine Depreciationccumulat Book Value n Per Unit Hours n Expense ed 2,400 1,800 2.480 1.320