tolog Mo tone No Dr N Straight-Line Depreciation Completing this activity will help you learn to: Compute depreciation using the straight-line method. Extract information from a data set using Excel formulas, functions, and/or pivot tables. Scenario: Company A provides delivery services to and from warehouses owned by a large e-commerce company. The company operates 10 routes in the local area. The company owns three types of fixed assets: delivery vans, forklifts, and light equipment. Each route has 10 delivery vans, one forklift, and two pieces of light equipment for its operations. The company depreciates all fixed assets using the straight-line method. The Data worksheet contains a list of vehicles and equipment the company owns. Each row provides information about one asset, including its type, cost, residual value, useful life, route, and number of months already in service. Required: Open spreadsheet Complete four columns on the Data worksheet: Depreciable Base, Annual Depreciation, Accumulated Dep., and Book Value. Use this information to complete the requirements below. R1. Cell H2: Use a formula referring to other amounts in the row to calculate the depreciable base for the first asset. $ R2. Cell 12: Use the SLN function to determine the annual depreciation expense amount for the first asset. $ R3. Cell 12: Use a formula referring to other amounts in the row to calculate accumulated depreciation for the first asset. $ R4. Cell K2: Use a formula referring to other amounts in the row to calculate the book value of the first asset.

Straight-4ine Depreciatibn Oonpleting this rawity will help yoo learn to Scenaries Nesulied 4 1 1 Straight-4ine Depreciatibn Oonpleting this rawity will help yoo learn to Scenaries Nesulied 4 1 1