please answer all portions with excel formulas/cell references

Please answer all questions in excel formulas/ cell references

omework Chapter ruong Term Assets U 1. Prepare depreciation schedules using Straight-Line Units-of-Production, and Double Declining Balance Depreciation Finance Depreciation Schedules - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign in Paste & B u . " A Alignment Number Colle conna Conditional Formatan Format Cell - w Sullivan Ranch Corporation has purchased a new tractor. The following 1 sl van Ranch Corporation has purchased a new tractor. The follow f ormation is en $ $ 150,000 10.000 Estimated Residual s Estimated life in years: Estimated ute in hours: ActualHous 1200 360 10 11 Year Year 4 350 220 Prepare the following Straight line depreciation schedule using the excel SIN FUNCTION (fx to calculate the Depreciation Expense for Years 1-4 in the Depreciation Expense column Enter formulas or absolute cell references for the remaining cells