Tag Archives: Depreciation

Completing the OFFSET series, let’s see a real-life example on how to use the OFFSET function to model depreciation.

Basically, the depreciation model needs the following inputs:

• Monthly capital expenditures forecast
• Useful life of the assets

With those inputs we’ll be able to calculate:

• Monthly depreciation
• Accumulated CAPEX
• Accumulated depreciation