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. Dont use a calculator and type the number in. Thats not letting the spreadsheet do the work.

.

+ SL U OP | DDB L Sheet3 Date Asset Cost Depreciation for the Year Depreciable Useful Depreciation Accumulated Cost Life Expense Depreciation Book Value UUJU N N