Modelling straight line depreciation

This is a simple way to calculate depreciation using the sum(), offset() and min() functions in just one row of formula.

Using this method not only allows you to save space in your financial model, but also the flexibility to calculate any incremental depreciation from additional capex in the forecast period.