Ning 1010 Poted in th Search MRT an Malings Ravine Vine Heb wes Unless need to set to stay in Protected Vier Enable Editing Using Excel to Calculate Depreciation As long as the cost, salvage value, and useful life of the asset are provided in the worksheet, The following functions can be used to determine the applicable depreciation expense. Note that the period must also be entered when calculating depreciation expenses under the sum of the years' digits and double-declining balance methods. This allows Excel to determine the proper depreciation for each year of the asset's useful Me 14 Cost 12400 15 Salvage Value 2400 10 4 16 Useful Life 17 Period 19 SLN(C14,C15,C16) Straight-Line Depreciation 20 SYD(C14,C15,C16,C17) Sum of the Years' Digits Depreciation 21-0DB(C14,C15 C16,C17) Double-Dedining Balance Depreciation Let's assume that we have an asset with a 30-year useful Me, a cost of $207,000, and a salvage value of $7,000. Complete an Excel worksheet in which you calculate depreciation for each of the first TWO years of the asset's uneful Me under the Straight Line Depreciation Method New repeat the above process, this time using the Sum of the Years' Digits Depreciation Method %6 5 40 6 & 8 6 > 0 R T Y U - T O P G H J K L A V B N M