Sullivan Ranch Corporation has purchased a new tractor. The following information is given: S 150,000 10,000 Cost: Estimated Residual: Estimated Life in years Estimated Life in hours: Actual Hours 1200 Year 1 Year 2 Year 3 Year 4 360 270 350 220 1. Prepare the following Straight Line depreciation schedule by using the excel
SLN 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. IVAN RANCH CORPORAT Depreciation Accumulated De Year Book Value Ex ation Tota
2. Prepare the following U Use absolute cell references when a n deprec iation schedule by entering formulas. ppropriate VAN RANCH CORPORAT Depreciation Accumulated Year Book Value atio Tota
3. Prepare the following Double-Declining-Balance depreciation schedule by using the Excel DDB FUNCTION (fx) to c Depreciation Expense for Years 1-4 in the Depreciation Expense column. Enter formulas or absolute cell references for the remaining cells IVAN RANCH CORPORAT Depreciation Accumulated De Year Book Value Ex ation Total