File Home insert Page Layout Formulas Data Review View Add-ins Help Tell me what you want to do PROTECTED VIEW Be careful-files from the Internet can contain vinuses. Unless you need to edit, it's safer to stay in Protected ViewEnable Editing 41 f. Requirement 1 2Use Excel to prepare depreciation schedules for straight-line, double-declining-balance, and units-of-production methods 3(Always use cell references and formulas where appropriate to receive full credit. Enter all amounts as positive values, Do not use a minus sign or parentheses for any values) 5 Requirement 2 Prepare a second depreciation schedule for double-declining-balance method, using the Excel function DOB. The DDB function cannot be used in the last year of the asset's useful life 7(Always use cell references and formulas where appropriate to receve full credit. Enter all amounts as positive values. Do not use a minus sign or parentheses for any values.) Requirement 3 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 Always use cell references and formulas where appropriate to repeive full credit. Enter all amounts as positive values, Do not use a minus sign or parentheses for any values.) 10$6,000? 13For calculations in each of the four tables below refer only to the values calculated in the same table or provided in the DATA table. Cost Residual Value useful Life (Years Useful Life (Hours) 5 400,000.00 20,000.00 S 8,000 6,000.00 ain End of Year 1 Straight Line Depreciation Accumulated Book Value instruction ENTERANSWERS