- The financial years for the data under review is on the lookup worksheet.
- The list of assets and their life spans are on the lookup worksheet.
- The Vlookup function extracts the data into the assets register from the lookup worksheet under "Check useful life".
- The IF and AND functions are used to calculate the financial year when the asset was purchased under Assets Purchased by Fin Year.
- Depreciation using the Straight line method is calculated in column O.