Data analysis – pros and cons
| 18-04-2018 | Lionel Pavey |

With the advent of computing and ever more powerful processing capabilities, we are living in a time where there is more and more data available within a company. Advocates of data mining speak of the advantages that can be obtained by analysing all the data and discovering trends within the data. But there is also the risk that we end up being swamped by the data overload – so much data, so little time. If we want to analyse all our data, what is it that we truly want to find? How can we interpret all the data and arrive at beneficial conclusions?
Treasurers and cash managers are long time users of data analysis – it is used to go from a macro level to a micro level for individual transactions. When designing a cash flow forecast it is essential to take the micro approach. There will always be peak days for outflows – wages are paid, normally, on 1 specific day of the month; on the last working day of the month there is large expenditure relating to taxes and social premiums. Additionally, if the company works with monthly subscriptions, there will be peak days for inflows as all the renewals take place. These “exceptional” items need to be input as hard data on the relevant working days to assist in presenting an accurate forecast.
Another application of data analysis is to interrogate the actual Days Sales and Days Purchasing Outstanding – DSOs and DPOs – that make up the cash conversion cycle. A lot of unnecessary working capital can be tied up in this process. Understanding the transactional characteristics of individual debtors and creditors can be very beneficial to freeing up working capital. Furthermore, it allows the company to review their relationships – is it worth maintaining certain contacts if they do not meet the agreed terms and conditions on their trade transactions.
It is also possible to conclude that certain clients could benefit from a more advantageous pricing policy. Rewarding those that comply leads to better relationships and the improvements in cash flow can help reduce external borrowing requirements.
When attempting to analyse data, it is imperative to first understand what you are looking for. Obvious metrics could be month on month sales or purchases, seasonal effects on turnover, new products, promotional offers etc. The act of analysing data, together with the awareness within the company that the data is being analysed, can lead to anomalies caused by people’s actions. Data input could be subject to a form of “window dressing” – entries are made before the end of the month and then corrected in the following month.
It is possible to conclude that there is a trend in the data – some people even look for these – that could lead to a false sense of conclusion. There is also the danger that 2 different streams of data are linked to each other because they show the same trends. When analysing data is it necessary to be open minded about the expected outcome. If people start analysing with a preconceived idea of what the outcome should be, human nature can intervene and the data is interpreted in a way that justifies the preconceived idea.
Data analysis is a technical discipline that can overlook the fundamentals. Before the CDO crisis of 2008, most banks agreed with the interpretation of the underlying data within the systems, without challenging the reality of the scenarios being presented. Even after the crisis started, the banks were unable to foresee the severe impact that it would have on the whole financial market. I have a curious leaning to analysing long term interest rates – I have collated data on Interest Rate Swaps since the inception of the Euro. Whilst I am able to spot long term trends, I have failed in ever calling the top or the bottom of the market.
When analysing data, it is imperative that the basic fundamentals of a company and its products is never forgotten, If sales are down, a more fundamental approach needs to be undertaken. Are our competitors cheaper, are their products better, is the economy in a downturn, are our products obsolete?
Analysis should always be undertaken, but the results must always be weighed up against the reality of the marketplace. It is too easy to draw conclusions – it gives the illusion that the analysis is good.
A lot of good things can come from data analysis, but it must not exclusively determine the actions that a company takes in its quest for growth and survival.

Cash Management and Treasury Specialist

There are many instruments that can be used to obtain short term funding. We have touched on some of them earlier in this series. This article is all about lines of credit. These are normally provided by banks of other financial intermediaries and help corporates with their short term funding needs. At first glance is might appear to be the same as a short term loan, but there are some clear differences. Normally, the financial institute that is the counterparty, will provide you with a line of credit – after appropriate inspection – which sets a specific limit on the amount of credit to be extended. Let us see how this works.
Last week an article appeared on the BBC website about the current situation in Sweden. They have embraced the world of digital payments – cash payments in the retail sector now amount to only 15% of the total, compared to 40% in 2010. But against this resounding success, there is a growing unrest among the elderly and other groups perceived as vulnerable. The majority of the banks in Sweden have stopped customers from withdrawing or paying in cash at the banks. So, what are the consequences in a cashless society and how will digital money perform in the future?
If all goes as stated, then the United Kingdom will be leaving the European Union on 29th March 2019. There has been fierce competition within the EU to entice banks away from London and to settle within the Euro zone. In London there is a fear that there will be a banking exodus – an industry that has prospered and made London a global centre. At till now banks have been able to sell their services into Europe via London, that this is envisaged to change. So, how are the major European cities faring in their campaigns?
Last week, the Centraal Bureau voor de Statistiek (CBS) released their year end data for 2017 regarding the Dutch economy. The recovery is strong – for the first time since 2008 the Netherlands complies with 2 of the important Euro criteria at the same time; the government debt is below 60% of GDP and the annual budget deficit must not exceed 3% of GDP. Furthermore, Dutch GDP grew at an annual rate by 3.2% in 2017 – this is higher than in 2016 when the growth was 2.2%. This is the strongest growth since 2007. We take a look at the data and the contributing factors.
Blockchain technology enables real-time settlement finality in the securities world. This may mean the end of a number of players in the post trade area. For a long time, central securities depositories (CSDs), as intermediators in the post-trade processing chain, were expected to become obsolete. CSDs, but also other existing players in the post-trade environment, are however changing their mind on these new technologies and on their future position in the blockchain world. Increasing regulation, legacy systems and costs pressures, are drivers for CSDs to at least embrace some aspects of blockchain. They are increasingly considering them as enabler of more efficient processing of existing and new services, instead of a threat to their existence. It is interesting to see that some of these actors – who could be potentially big losers in a distributed ledger technology (DLT) or blockchain system – are open to innovation with blockchain and willing to invest in DLT. Last January SWIFT and seven CSDs worldwide agreed on a Memorandum of Understanding to explore the use of blockchain technology in the post trade process esp. e-proxy voting.


