File Home Insert Draw Page Layout Formulas Data Review View Help Calibri 11 General x out | Copy Format Painter AA == 2 Wrap Text A E Merge Center E B 10 $% 948-23 Conditional format as Formatting Table Sty! Coboard Font Alignment 5 Number > B D E F G H 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. 3 4 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 straight line method of depreciation (need to use a formula in the cells to show the calculations behind the values). (16 points) S 6 End of Year Depreciation Expense Accumulated Depreciation 0 1 Book Value $ 450,000 8 9 10 71 12 2 3 4 5 13 14 15 16 17 18 19 20 21 22 28 24