In the range E5:E40, calculate the value of the equipment as it depreciates each year. To calculate the depreciated values, subtract the depreciation amount from the value of the equipment in the previous month. To calculate the depreciation amount, use the DDB function for the double-declining method using the depreciation values entered in the range B4:B7 and the corresponding period value in column D.