FJ 0 2 1 Plant Assets, Natural Resources, and Intangibles 2 Using Excel to prepare depreciation schedules The Fraser River Corporation has purchased a new piece of factory equipment on January 1, 2018, and wishes to compare three depreciation 4 methods: straight-line, double-declining-balance, and units-of-production. The equipment costs $400,000 and has an estimated useful life of four years, or 8,000 machine hours. At the end of four years, the equipment is 5 estimated to have a residual value of $20,000. 6 Use the blue shaded areas on the ENTER-ANSWERS tab for inputs. 7 ALWAYS use cell references and formulas where appropriate to receive full credit. Copy/pasting values will NOT earn full points 10 Requirements 111 Use Excel to prepare depreciation schedules for straight-line, double-declining-balance, and units-of-production methods. 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 12 useful life 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? 13 14 15 16 For all requirements, enter all amounts as positive values. Do not use a minus sign or parentheses for any values