methods: Straight line, Units of Production and with steps(excel form)

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 one, 40,000 hours in year two, 20,000 hours in year 3, and 10,000 hours in year 4. Date Asset Depreciation for the Year Depreci Useful Depreciation Accumulated Cost Life Expense Depreciation Book Value Cost Date Asset Cost Depreciation for the Year Depreci Number of Depreciation Accumulated per Unit Units Expense Depreciation Book Value