K Excel Assignment #1 - Instructions and Te... On January 1, 2018 Friendly Farm Company purchased a new machine at a cost of $350,000. The machine has an estimated useful life of 4 years or 100,000 hours and residual value of $30,000. The machine will be used 30,000 hours in year 1, 40,000 hours in year 2, 20,000 hours in year 3 and 10,000 hours in year 4. Requirements: Prepare a depreciation schedule using each of the three methods: Straight line, Units of Production and Double Declining Balance. You may use the template I have attached here or you may create your own depreciation schedules using your textbook as a guideline. Do all mathematical computations in Excel when you can. Don't use a calculator and "type" the number in. That's not letting the spreadsheet do the work. Save the assignment with an xls or xlsx extension and upload the assignment in ASSIGNMENTS in Canvas. Done := DepreciationSchedules (1 of 3) SL UOP DDB Sheet3 Depreciation for the Year |Useful |Depreciable Cost |Depreciation Accumulated |Expense Date Book Asset |Depreciation Value Cost Life DepreciationSchedules (1 of 3) Done SL UOP DDB Sheet3 Depreciation for the Year |Number of Units Asset Depreciation Accumulated Expense Depreciation |per Unit Book Date |Depreciation Cost Value DepreciationSchedules (1 of 3) Done Sheet3 SL UOP DDB Depreciation for the Year DDB Depreciation Accumulated |Expense Book Date Book Asset Value |Depreciation Cost Rate Value