Cost of Car: $78,100 Useful Life: 5 years Residual Value: $3,100 Estimated Miles: 100,000 Miles by Year: Year 1: 28,000 Year 2: 35,000 Year 3: 25,000 Year 4: 12,000 STRAIGHT-LINE DEPRECIATION Depreciation Expense |Carrying Value Accumulated Depreciation Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7

Input area: Installation cost Pretax salvage value Operating cost per year Initial NWC Tax rate Discount rate *Depreciation straight-line over life Output area: Annual depreciation charge Aftertax salvage value OCF NPV $ SA SA SA GA $ 385,000 $ 60,000 $ 135,000 35,000 21% 10% ᏌᏊ Ꮚ Ꮚ $ 77,000 $ 47,400 $ 122,820 5

Complete the table

Using the following information create a Double declining, depreciation schedule. Computer Equipment: $3,000 Residual Value: $150 Useful Life: 5 years Example: Straight line depreciation Scheadule.  year (beginning of year value) depreciation (end of year value) 1 $3,000 $570 $2,430 2 $2,430 $570 $1,860 3 $1,860 $570 $1,290 4 $1,290 $570 $720 5 $720 $570 $150

Book value Find the book value for the asset shown in the accompanying table, assuming that MACRS depreciation is being used Recovery period (years) 5 Elapsed time since purchase (years) 2 Asset A Installed cost $839,000 The remaining book value is $ (Round to the nearest dollar.) Data table (Click on the icon here in order to copy the contents of the data table below into a spreadsheet.) Rounded Depreciation Percentages by Recovery Year Using MACRS for First Four Property Classes Recovery year 1 2 3 4 5 6 7 8 3 years 33% 45% 15% 7% 9 10 11 Totals Percentage by recovery year* 5 years 7 years 20% 14% 32% 19% 12% 12% 5% 25% 18% 12% 9% 8% 7% 6% 6% 6% 4% 100% 100% 100% 100% *These percentages have been rounded to the nearest whole percent to simplify calculations while retaining realism. To calculate the actual depreciation for tax purposes, be sure to apply the actual unrounded percentages or directly apply double-declining balance (200%) depreciation using the half-year 10 years 10% 18%…

Depreciation Methods A company wants to buy a new refrigerated truck for $5,000,000. The truck can be used for 4 years, then it has a market value of $360,000. You are asked to calculate the depreciation for each year for each of the four classic depreciation methods: a) straight line b) Declining balance of 150% c) Units of production method (given: use in year 1: 450,000 km, year 2: 410,000 km, year 3: 380,000 km, year 4: 330,000 km) Please solve in Excel and show the formulas. Please answer fast i give upvote.

Equipment cost $15,000 and has a $1,000 residual value and an expected useful life of four years. What is the depreciation expense in Year 4 using the Double-Declining-Balance Method at the straight-line rate? Multiple Choice $700 $875 None of the other alternatives are correct $1,000 $937.50

A truck with a cost of $123,000 has an estimated residual value of $24,000, has an estimated useful life of 12 years, and is depreciated by the straight-line method. a.  Determine the amount of the annual depreciation.$ b.  Determine the book value at the end of the seventh year of use.$ c.  Assuming that at the start of the eighth year the remaining life is estimated to be six years and the residual value is estimated to be $15,000, determine the depreciation expense for each of the remaining five years.$

Straight-Line Depreciation A building acquired at the beginning of the year at a cost of $134,200 has an estimated residual value of $5,200 and an estimated useful life of 10 years. Determine the following: (a) The depreciable cost     (b) The straight-line rate   % (c) The annual straight-line depreciation

Historical cost $ 270,000 Estimated useful life 6 years Salvage value $ 24,000 Estimated useful hours 12,000 hours 3,100 2019 1,100 2020 1,200 2021 Estimated hours per year: 2,800 2022 2,600 2023 1,200 2024 Required 1 Complete the depreciation schedule using the Units of Production Method. Page Adventure Park, Corp. ciation Schedule - Units of Production Depreciation Accumulated Depreciable Year Expense Depreciation Cost 12.31.19 12.31.20 12.31.21 12.31.22 12.31.23 12.32.24 2 Record depreciation expense for 2020. General Journal DR CR 3 What is the net book value of the equipment on 12.31.20? Historical cost (Accumulated depreciation) Net book value at 12.31.20 |24