Chapter 09 Homework (Application) CG 1. EX.09.01 2. EX.09.06 3. EX.09.07 ALCO 4. EX.09.09 ALGO 5. EX.09.12 ALGO eBook Show Me How Office 365 Calculator Partial-year depreciation Equipment acquired at a cost of $57,000 has an estimated residual value of $3,000 and an estimated useful life of 10 years. It was placed in service on May 1 of the current fiscal year, which ends on December 31. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open spreadsheet a. Determine the depreciation for the current fiscal year and for the following fiscal year by the straight-line method. Round your answers to the nearest 6. PR.09.05A BLANKSHEET dollar. 7. PR.09.06A. BLANKSHEET Depreciation 8. EX 09.11.EXCEL ALGO Year 1 $ Year 2 $ b. Determine the depreciation for the current fiscal year and for the following fiscal year by the double-declining-balance method. Do not round the double-declining balance rate. Round your answers to the nearest dollar. Depreciation Year 1 $ Year 2 $ x Excel template - Saved File Home Insert Formulas Data Review View Help Tell me what you want to do Comments X Cut 10. AA 29 490 Currency $. % 94 Paste Insert Delete Format Clear Conditional Format Formatting was Table Styles format Painter Cloud Sort & Find & Filter Select Editing Font Alignment Number Undo C13 F G H B D 1 Partial-year depreciation DATA Cost $57.000 5 Estimated residual value $3.000 6 Estimated useful life (in years) 10 Placed into service on May 1 End on the fiscal year December 31 9 Using formulas and cell references, perform the required analysis, and input your answers into the Amounts column. Transfer the numeric results for the green entry cells (C13C16) into the appropriate sin CNOW2 for grading 10 11 12 Amounts Formulas 13a Depreciation (Straight-line method) Year 1 14 Depreciation (Straight-line method). Year 2 15 . Depreciation (DO8 method), Year 1 16 Depreciation (DOB method). Year 2 fields Data +