-ide Insert Home Page Layout Formulas Data Review View PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to 14 8 X A B c Type of car: Porsche Cost of Car: $78,100 5 Useful life: 5 years 3 9 Residual Value: $3,100 10 1 Estimated Miles: 100,000 12 Miles by Year: 13 Year 1:28,000 14 Year 2:35,000 15 Year 3:25,000 16 Year 4: 12,000 17 18 19 20 STRAIGHT-UINE DEPRECIATION 21 22 Depreciation Accumulated Carrying 23 Expense Depreciation Value 24 Year 1 25 Year 2 26 Year 3 27 Year 4 28 Year 5 29 Year 6 30 Year 31 32 33 34 2 DOUBLE DECLINING BALANCE 3 4 Depreciation Accumulated -5 Expense Depreciation Carrying Value 36 Year 1 47 Year 2 48 Year 3 49 Year 4 50 Year 5 51 Year 6 52 Year 7 53 54 55 56 UNITS OF PRODUCTION METHOD 57 58 Depreciation Accumulated 59 Expense Depreciation Carrying Value 60 Year1 61 Year 2 62 Year 3 63 Year 4 64 Years 65 Year 66 Year 7 Sheet1 IF Type here to search O PA