1. Prepare depreciation schedules using Straight -Line. Activity Based, and Double-Declining Balance Depreciation. Finance Depreciation Schedules-Excel FILE HOME INSERTPAGE LAYOUT FORMULAS DATA REEW VIEW Sign In ?1? HAAlignment Number Conditional Format as Cell Cells Editing Paste B r u. |? Formatting Table Styles Font A1 Sullivan Ranch Corporation has purchased a new tractor. The following 1 Sullivan Ranch Corporatiord has purchased a new tractor. The following information is given: 3 Cost $ 150,000 Estimated Resaidua:1000 Estimated Residual: 5 Estimated Life in years 6 Estimated Life in hours: 1200 Actual Hours: Year 1 9 ear 2 cyear a 360 270 350 220 Prepare the following Straight Line depreciation schedule by using the excel SLN FUNCTION (fx) to calculate the 1a Depreciation Expense for Years 1-4 in the Depreciation Expense column. Enter formulas or absolute cell references for the remaining cells eoux value