angela plante APE - AutoSave CW A D S HW3 - AGR 333 (1) Protected View Excel To Scarch File Home Insert Draw Page Layout Formulas Data Review View Help PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit it's safer to stay in Protected view 0 X Comments Share Enable Editing L M N Accumulated Book Value Depreciation t=2.10) {t=2.10) Accumulated Depreciation It=1.25) Book Value (t51.25) Year Year 1 New Holland SP.260R Sprayer Depreciation 2 MSRP $324,487 3 Useful life 4 years (830 engine hours) 4 Salvage value $75,000 5 Declining Balance Depreciation Formula = Book Value at Beginning of Year'R'! 6 R = 100%/4 = 7% 7 t=1.25.2.10 10 STUDENT INPUT 17 DIRECTIONS Compute the rate of straight line depreciation. R. Using the formula given in 18 the slides Using the speed rates t=1.25 and t=2.10. complete the depreciation calculations in 19 cells J2:J6, M2:M6, K2:K7 and N2:N7 Answer in the green cell, A11 (marked "student input"), what speed seems more realistic (1.25, 2.10, or neither of them), and 20 give reasoning for why that is your answer. Sprayer Depreciation 1 A Type here to search OB e a 90 x a - 1 + 1104 d 231 PM . 649 372/20203