SULLIVAN RANCH CORPORATION Depreciation Schedule-Straight Line Method End of year amounts Depreciation Accur Book Value 35,000 35.000 $ 115.000 35,000 70,000 $ 80,000 3 $ 35.000 105.000 45.000 4 $ 35.000 140.000 10.000 Total 25 Prepare the following Units-of-Production depreciation schedule by entering formulas. 26 Use absolute cell references when appropriate. SULLIVAN RANCH CORPORATION Depreciation edule Units of Production Method End of year amoun Depreciation Book Value sted Deprecaten 42.000 73 500 42.000 31 500 40,833 25,6675 114,333 140,000 .to Prepare the followine Double Declinin-Ralance denreciation schedule by usine the Excel DDR FUNCTION Cheat 1 Sullivan Ranch Corporation has purchased a new tractor. The following info 150.000 10.000 1200 3 Cost: 4 Estimated Residual: 5 Estimated Life in years: 6 Estimated Life in hours: 7 Actual Hours: 8 Year 1 Year 2 Year 3 11 Year 4 360 270 350 220 E3 $ $ 114,333 140,000 25.667 Total Prepare the following Double-Declining-Balance depreciation schedule by using the Excel DDB FUNCTION (fx) to 37 calculate Depreciation Expense for Years 1-4 in the Depreciation Expense column. Enter formulas or absolute cell references for the remaining cells. SULLIVAN RANCH CORPORATION Depreciation Schedule-Double-Declining Balance Method End of year amounts Depreciation Accumulated Year Book Value Expense Depreciation 1 $ 75.000 2 S 37.500 18.750 8.750