****PLEASE SHOW EXCEL FORMULAS FOR EACH CELL OR COLUMN AND USE ABSOLUTE CELL REFERENCES WHEN APPROPRIATE***

Sullivan Ranch Corporation has purchased a new tractor. The following information is given: $ $ 150,000 10,000 1200 Cost: Estimated Residual: Estimated Life in years: Estimated Life in hours: Actual Hours: Year 1 Year 2 Year 3 Year 4 360 270 350 220 Prepare the following Activity-Based depreciation schedule by entering formulas. Use absolute cell references when appropriate. SULLIVAN RANCH CORPORATION Depreciation Schedule-Units-of-Production Method End of year amounts Depreciation Accumulated Year Book Value Expense Depreciation 2 3 TL 4 Total