wa Forum M2 Discussion mework Saved ? X HOME INSERT BB FILE X Fe Paste Sign In Calibri - 11 H Finance Depreciation Schedules - Excel PAGE LAYOUT FORMULAS DATA REVIEW VIEW A Alignment Number Conditional Format as Cell Formatting Table Styles Styles =SLN(SB$3.$B$4 SBS5) BIU- - Cells Editing Clipboard Font C20 X E A B D F 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: 4 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. 8 14 10 5 oints HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign in ce - 11 % M Paste Alignment Number Conditional Formatas Cell Cells Editing Formatting Table Styles Clipboard Font Styles C20 f-SLN($B$3$B$4 SBSS) B D E 12 Prepare the following Straight Line depreciation schedule by using the excel SLN FUNCTION(x) 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. 03:12:33 eBook Print References 15 16 SULLIVAN RANCH CORPORATION 17 Depreciation Schedule Strnitht Line Method IR End of year amounts 19 Year Depreciation Accumulated Expense Book Value Depreciation 30 1 357000 21 2 22 3 23 4 24 Total 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 Accumulated Depreciation 30 Year Book Valur Expenne Depreciation 31 32 2 Sheet Hy UU Porum M2 DIOCsion 27045 Homework Surved DB ? Finance Depreciation Schedules Excel FORMULAS DATA REVIEW BX FILE HOME INSERT PAGE LAYOUT VIEW Sign In x Calin 11 96 Paste BIU. GE Alignment Number Conditional Formatas Cell Formatting Table Styles Cells Editing Clipboard Font 215 es C20 =SLN(SB$3,$B$4:$B$5) B D E F 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 Accumulated Depreciation Year Expense Depreciation Book Value 31 1 32 2 33 3 34 4 35 Total 36 Prepare the following Double-Declining-Balance depreciation schedule by using the Excel DDB FUNCTION (Ex) 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 44 1 45 2 Sheet1 1 - UE Cells Editing Clipboard Font Formatting Table Styles Styles C20 f =SLN(SB$3.SBS4 SB$5) A D F 34 35 36 B 3 4 Total Prepare the following Double-Declining-Balance depreciation schedule by using the Excel DDB FUNCTION (Ex) 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 Accumulated 43 Depreciation Year Book Value Expense Depreciation 44 1 45 2 46 3 47 4 48 Total 49 50 51 52 Sheet1 +
