Please use the SLN function for question 1 and the DDB function for question 2.

? 5 1 A B F 2 8 Finance Depreciation Schedules - Excel FILE HOME INSERT PAGE FORMULAS DATA REVIEW VIEW Sign In Calibri 11 - A A % Paste BIU A Alignmentumbeconditio Format Cell Cells Formattiras Styles Clipboard Font Styles A1 X fix Sullivan Ranch Corporation has purchased a new tractor. The followi D E 1 Sullivan Ranch Corporation has purchased a new tractor. The following information is given: 2 3 Cost: $ 150,000 4 Estimated Residual: $ 10,000 5 Estimated Life in years: 6 Estimated Life in hours: 1200 7 Actual Hours: Year 1 360 9 Year 2 270 10 Year 3 350 11 Year 4 220 12 Prepare the following Straight Line depreciation schedule by using the excel SLN FUNCTION (fx) to calculate the 13 Depreciation Expense for Years 1-4 in the Depreciation Expense column. Enter formulas or absolute cell references for the remaining cells. 14 15 16 SULLIVAN RANCH CORPORATION Depreciation Schedule-Straight Line Method End of year amounts Depreciation Year Accumulated 19 Book Value Expense Depreciation 20 $ 35,000$ 35,000 $ 115,000 2 $ 35,000 $ 70,000 $ 80,000 3 $ 35,000S 105,000$ 45,000 Sheet1 READY + - +100% Attempt(s) Hint 17 18 1 21 22 + ? B 16 17 18 19 20 x] 5 Finance Depreciation Schedules - Excel o X FILE HOME INSERT PAGE FORMULAS DATA REVIEW VIEW Sign In Calibri 11 A % Paste BIU- A - Alignmehlumbeconditio.Format Cell Cells Formattiras Styles Clipboard Font Styles A1 fix Sullivan Ranch Corporation has purchased a new tractor. The followi D E F SULLIVAN RANCH CORPORATION Depreciation Schedule-Straight Line Method End of year amounts Depreciation Accumulated Year Book Value Expense Depreciation 1 $ 35,000 $ 35,000 $ 115,000 21 2 $ 35,000$ 70,000$ 80,000 22 3 $ 35,000$ 105,000 $ 45,000 23 4 $ 35,000$ 140,000$ 10,000 24 Total $ 140,000 25 Prepare the following Units-of-Production depreciation schedule by entering formulas. 26 Use absolute cell references when appropriate. 27 SULLIVAN RANCH CORPORATION 28 Depreciation Schedule-Units-of-Production Method 29 End of year amounts 30 Year Depreciation Accumulated Book Value Expense Depreciation 31 1 $ 42,000 $ 42,000S 108,000 2 $ 31,500$ 73,500 $ 76,500 3 $ 40,833 $ 114,333 $ 35,667 4 $ 25,667 140,000 $ 10,000 35 Total $ 140,000 36 Prepare the following Double-Declining-Balance depreciation schedule by using the Excel DDB FUNCTION (fx) to 37 calculate Denreciation Expense for Years 1-4 in the Depreciation Expense column. Enter formulas or absolute cell Sheet1 READY +100% Attempt(s) Hint 32 33 34 ? 5 X 1 X A E F 33 B 3 4 34 Finance Depreciation Schedules - Excel FILE HOME INSERT PAGE FORMULAS DATA REVIEW VIEW Sign In Calibri 11 - A A % Paste BIU A Alignmentumbeconditio Format Cell Cells Formattiras Styles Clipboard Font Styles A1 fox Sullivan Ranch Corporation has purchased a new tractor. The followi D $ 40,833$ 114,3335 35,667 $ 25,667$ 140,000 10,000 35 Total $ 140,000 36 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. 38 39 40 SULLIVAN RANCH CORPORATION 41 Depreciation Schedule-Double-Declining-Balance Method 42 End of year amounts Depreciation Accumulated 43 Year Book Value Expense Depreciation 1 $ 75,000 $ 75,000 2 $ 37,500 46 3 4 Total 44 45 47 48 49 50 51 52 Sheet1 + + READY Attempt(s) +100% Hint