:

Enter the following questions Part I & II in the excel spreadsheet:

Part I: Using the format in Table 8-A-5, compute units of service depreciation using the following assumptions:

Cost to be depreciated = $50,000

Salvage value = zero

Total units of service = 10,000

Units of service per year: year 1 = 2,200; Year 2 = 2,100; Year 3 = 2,300; Year 4 = 2200; Year 5 = 200

Part II: Using the same format, compute units of service depreciation using adjusted assumptions as follows:

Cost to be depreciated = $50,000

Salvage value = $5,000

Total units of service = 10,000

Units of service per year: Year1 = 2200; Year 2 = 2100; Year 3= 2300; Year 4 = 2,200; Year 5 = 200