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.