File Home E19 Insert Draw Page Layout Formulas Data Review View PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit x fx B C D 1 BE9-4: Depreciation, straight-line for two years 2 3 4 5 6 7 8 9 10 Cost of truck Less: salvage value Depreciable value Useful life (in years) Depreciation per year (straight-line) #DIV/0! Year 1 depreciation Year 2 depreciation 11 12 13 BE9-7: Depreciation, units-of-activity method Cost of taxi Less: salvage value Depreciable value Miles to be driven over useful life 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 Depreciation per mile Year 1 depreciation Year 2 depreciation #DIV/0!