Depreciation is a term used to describe the reduction in the value of as asset over a number of years. A Depreciation Schedule is a table that shows the depreciation amount over the span of the asset's life. ... Part 2 discusses how to calculate the MACRS depreciation Rate using Excel formulas.