ICAEW.com works better with JavaScript enabled.
Exclusive

Economic life modelling

Author: Liam Bastick

Published: 06 Apr 2021

Exclusive content
Access to our exclusive resources is for specific groups of students, users, subscribers and members.

When modelling for accounting purposes, sometimes you need to verify the life chosen for depreciation (in most jurisdictions, taxation reporting does not have this requirement, so lives for tax purposes may be simply be assumed). This cannot be just “any” number: it has to reflect the economic life.

The definition of economic life is stated as the timespan over which the annual cost of owning and operating a non-current asset (held for continuing use in the business) is minimised. The economic life of such an asset can be a function of factors such as physical wear and tear, usage and technological obsolescence.

In order to establish what constitutes minimum costs, I want to consider not only the costs incurred but the timing of them too – so we need to dust down discounted cash flows.

The easiest way to explain this is with an illustration. Assume I have the following forecast cost data:

Image of forecast cost data

For this non-current asset, I have three cost categories, forecast for each of the next eight years (you may need to project further in real life).  Do note that the Purchase Price is the cost to buy a new, replacement asset in x years from now – not the purchase price to buy the asset now. That figure is both sunk and / or decision irrelevant as we are assuming we already have the asset.

I assume Maintenance Costs will be incurred each year.  To keep the discounted cash flow simple, I will assume the costs are incurred at the end of each period too (not an unreasonable assumption to make as businesses will often try to keep their costs to a minimum and tend to delay costs where they can).

Assuming we replace this asset after eight (8) years, a discounted cash flow financial appraisal would look something like this:

image of discounted cash flow financial appraisal

Do note that I ignore tax, as this would be an assumed constant and again, is decision irrelevant. What you might see in these straightforward calculations is several IF statements that cut off costs after so many periods, or only display them for a particular period. That is so I may vary the life assessed. For example, this would be the Net Present Value (NPV) for one year:

image of net present value

For five years, the calculation would be:

image of 5 years calculation of net present value

Note I calculate the discounted cash flows from first principles – there are too many mistakes made when you use Excel’s built-in NPV and XNPV functions. It’s also easier for end users to follow intuitively.

Obviously, the costs appear to increase each year, as there will be additional Maintenance Costs, Disposal Proceeds will reduce and the Purchase Price will increase. On that basis, we should replace assets once every picosecond, but that’s not exactly viable. Besides, it would be wrong.

We need to calculate the average annual cost. Simply dividing by the number of periods would be incorrect as we are discounting the cash flows. We need to take this into account. Therefore, we weight this average by diving by the sum of the discount factors instead (known as the cumulative discount factor):

Our initial eight-year appraisal would then become:

image of 8 year cumulative discount factor

whereas the one-year assessment would be:

Image of one year assessment of cumulative discount factor

Clearly, eight years would be a better bet than one year, on this basis.

Rather than estimate the economic life by performing a “manual goal seek”, I can derive the optimum figure using a one-dimensional column Data Table (ALT + D + T):

Image of economic life calculation

I have put the formula =H28 in the hidden cell H38, then highlighted the range G38:H46 before creating the Data Table. This shows that for the costs forecast, the economic life for this asset should be seven (7) years, viz.

Image of 7 year economic life forecast

With the correct set-up, this economic life verification becomes trivial and should therefore be performed at least once a year, in order to confirm the appropriate accounting policies, etc.

Excel community

This article is brought to you by the Excel Community where you can find additional extended articles and webinar recordings on a variety of Excel related topics. In addition to live training events, Excel Community members have access to a full suite of online training modules from Excel with Business.

Excel polaroid
Open AddCPD icon

Add Verified CPD Activity

Introducing AddCPD, a new way to record your CPD activities!

Log in to start using the AddCPD tool. Available only to ICAEW members.

Add this page to your CPD activity

Step 1 of 3
Download recorded
Download not recorded

Please download the related document if you wish to add this activity to your record

What time are you claiming for this activity?
Mandatory fields

Add this page to your CPD activity

Step 2 of 3
Mandatory field

Add activity to my record

Step 3 of 3
Mandatory field

Activity added

An error has occurred
Please try again

If the problem persists please contact our helpline on +44 (0)1908 248 250