AutoSave Search Depreciation case project - Excel Ton Review View File Insert Home Formulas Draw Data Page Layout Help Home General Calibri Out In Copy Paste * Format Painter - 11 AA == 25 Wrap Text A.A. Merge & Center Conditionat Tomas Cell Formatting Table Styles $ % 94,88 BTU FH Number Styles Alignment 6 Font Cipboard B4 1. Using the table I started for you below, compute the depreciation expense, accumulated depreciation and book value for > E G F D H A B 1 Watkins Production purchased a new computerized machine at a cost of $450,000. The machine has a residual value of $64,000 and an expected life of 5 years. 12 3 1. Using the table I started for you below, compute the depreciation expense, accumulated depreciation and book value for all years of the machine's expected life using the double-declining balance method of depreciation (need to use a formula in the cells to show the calculations behind the values). For year 4, do not double the depreciation ratio and for year 5, use the previous year book value and the known ending residual value to calculate that last year of depreciation expense (remember, the depreciation expense in the final year cannot cause the final book value to be lower than the known residual value!). (16 points) 4 5 6 17 8 9 End of Year Depreciation Expense Accumulated Depreciation Book Value 0 $ 450,000 1 2 3 4 TO 11 12 5 14 4 15 16 17 18 19 20 21