Managing Spreadsheet Risks for Cymru Capital Investments

Task:

This assessment is designed to demonstrate a student’s completion of the following Learning Outcomes: 

Critically evaluate the role of EUC in modern organisations

Demonstrate understanding of the risks associated with EUC, specifically spreadsheet error. 

Understand the role Human Factors plays in spreadsheet development. 

Evaluate and discuss methods applied to spreadsheets to reduce errors presented in academic research. 

Formulate suitable management strategies for management of EUC in organisations

Understand the role of legal, management and technological policies for the control of EUC in organisations.

Cymru Capital Investments (CCI) is a mid sized bank working in corporate and investment Banking. The bank has offices located throughout Europe and USA employing 20,000 people in over 500 offices, and is regulated by the Financial Services Authority (FSA). The bank has enjoyed rapid growth in the last five years and at the end of the last financial year recorded a profit of £2.9 Billion. 

CCI’s core business is securities underwriting although it does also trade in derivatives, foreign exchange and commodities. The bank underwrites newly issued securities (Bonds and shares) from corporations and governments on the capital markets. In addition, CCI also underwrites loans and credit to various customers through a detailed process of credit analysis, this is known as Bank underwriting. 

You are to compile a 4000 report for the senior management that addresses the problems CCI faces. 

1. Firstly (50%), you must outline the risks associated with spreadsheet use and relate this to CCI’s spreadsheet activities and practices. Your report should also highlight the specific risks CCI faces and comment on any poor practice evident. Make use of citations to the literature and examples in your report.

Secondly (50%), you must recommend a new approach to managing CCI’s spreadsheets risk. You are free to adopt any approach you see fit with the exception of removing spreadsheet use from CCI completely.  Your approach should take into account the fact that CCI has some 50,000 operational spreadsheets)

Identification, contextualisation and exemplification of risks CCI expose themselves to Solution that addresses the identified risks