Modelling depreciation using SUM OFFSET

Use the SUM(), OFFSET() and MIN() functions to dynamically compute straight-line depreciation for capital expenditure in any year.