TimeWeb
SITEMAP | HELP | SAMPLE DATA | MIMAS DATA | SEARCH TIMEWEB  
HOME : CRUNCHING : ANALYSING : WORKSHEET
Digging
Crunching
  - Tour
  - Processing
  - Analysing
      - Explanation
      - Illustration
      - Worksheets
      - Review
  - Relating
  - Experimenting
Buffing
Reference

 



WorksheetWORKSHEET : Fantastic Plastic

Fantastic Plastic: The Cashless Society

With many UK politicians apparently fixated on the issue of the European single currency, it is tempting to forget that there is the prospect of the UK facing the end of cash itself. Rather than worry about what types of coins we have in our pockets and notes in our wallets, we ought to be more concerned, perhaps, with whether cash itself will continue to be with us in its physical form.

Let's get hold of some data to show how reliant on plastic we are becoming in the UK.

Get a copy of the Volume of transactions table [Excel file 18K].

OK, the first thing to notice is how the volume of transactions in the UK economy has moved according to movements in the overall economy.

Compare these two variables on the Excel sheet (as above) GDP % change set against total transactions.

This illustrates very well that recessions, including the 1991 - 92 slump, have real effects on people and their spending. In fact the fall in total transactions actually persisted longer than the decline in GDP, (1994 transactions fell by more than 2 % when GDP rose by over 4 % in the same period).


Q1. Why do you think that rising GDP was not reflected in higher volume of transactions in 1993-94?
(Select one answer)

(a) * The figures take a long time to be recorded.
(b) * Transactions were taking place through barter.
(c) * Consumer confidence was slower than the overall economy to recover.


What is clear from the data is that cash is declining as a share of all payments, over the period studied.

Try to represent this trend graphically using pie charts:

See the TimeWeb Guide on drawing pie charts if you are not sure how to do this.

Draw two pie charts to show the respective shares taken by cash and non-cash payments, as a proportion of total transactions. You should build into non-cash payments the data for post office order book and passbook withdrawals, given in the Volume of Transactions table.

Q2. What are the correct percentages for cash transactions in 1991 and 1999?
(Select one answer)

(a) * 24.3 & 33%
(b) * 21.5 & 30%
(c) * 2.4 & 3.3%


Q3. What are the correct percentages for non-cash transactions in 1991 and 1999?
(Select one answer)

(a) * 7.5 & 6.7%
(b) * 75 & 67 %
(c) * 24 & 33%


Now let's focus on the component parts of non-cash payments:

Calculate the percentage change that has occurred in the following non-cash elements over the period studied. Complete the gaps in the following table.

Non-cash payment method Up/Down Percentage change
Cheques ? > 25 %
Direct debits, standing orders etc Up ?
ATMs ? > 80 %
Debit card Up ?

UK Non-cash transactions % change 1991 - 1999

What do you think are the main reasons for the changes outlined above?

Here are some ideas...

  • Social change - Pace of life has quickened so saving time when seeing to your finances is seen as beneficial.
  • Consumers want a virtual economy - Although some people would agree with this, the majority of consumers would be reluctant to give up cash as main method of payment.
  • Technological change - Technology now allows for rapid transfer of funds.
  • Paper costs make cheques dearer - This is not a major factor.
  • Banking industry development - Restrictions have been lifted on some banking activities as a result of legal changes. This has forced the pace of change in the industry.
  • EU directive forces cashless society - This is merely an EU scare story!
  • Political direction - Government has been keen to see faster change in payment methods, as this is seen as boosting the competitiveness of the economy.
  • Utility charging policy - The utility companies (gas, electricity, water etc) have given discounts to consumers willing to pay their bills by direct debit.

What do you suppose the future holds for cash as a method of payment? Well of course there are a number of factors that could change the way transactions are carried out in the economy. Try to suggest some of the likeliest from the following list.

Q4. Which of the following changes in transactions behaviour are likeliest to happen, in your opinion?
(Select one or more answers)

(a) * The death of cash. All transactions handled through 'virtual' methods.
(b) * The integration of UK and EU payments systems in Euro-denominated form.
(c) * The re-introduction of the barter system into the European economy, as seen in Russia after the break-up of the USSR.
(d) * A steady increase in the use of non-cash payments.


But we cannot accurately predict what might happen technologically, politically or in terms of taste and fashion. What we can do is use the existing data that we know is reliable to find out the trend that could be seen in the decline of cash, if all else remains equal. This means that if we assume that the current social, technological and political circumstances stay the same, we can see what would happen in the future.

This activity is based on functions that Excel offers. If you are not sure about these, you may want to have a look at the relevant section of the TimeWeb guide to Excel.

When you have finished finding out how to go about predicting the trend using Excel, return to this worksheet and use the data in the table below for 1991 -1999 to extrapolate cash transactions for the years 2000 - 2009. Can you get these results using Excel?

The continuing decline of cash?
1991 28022
1992 27845
1993 27273
1994 26179
1995 26270
1996 26318
1997 25540
1998 25309
1999 25596
2000 24764
2001 24420
2002 24076
2003 23732
2004 23388
2005 23044
2006 22700
2007 22356
2008 22012
2009 21668

Trended data in italics
Original data from Social Trends No 31.

Back to worksheets