Create an accounting depreciation schedule using straight-line or accelerated depreciation, optionally applying a partial-year convention.
Formula
Straight-line depreciation is(cost − salvage) ÷ useful life. Declining balance multiplies opening book value by factor ÷ useful life. Sum-of-years' digits weights the depreciable basis by the remaining life over n(n + 1) ÷ 2.Examples
Straight-line asset
An $11,000 asset with $1,000 salvage value and a five-year life depreciates by $2,000 per year, ending at $1,000.