About this paper

Appears in:
Pages: 356-365
Publication year: 2011
ISBN: 978-84-615-3324-4
ISSN: 2340-1095

Conference name: 4th International Conference of Education, Research and Innovation
Dates: 14-16 November, 2011
Location: Madrid, Spain

THE ROLE OF SPREADSHEET MODEL DESIGN IN CORPORATE FINANCE COURSES

C. Correia, T. Minter

University of Cape Town (SOUTH AFRICA)
Spreadsheet Models are pervasive in practice and are increasingly used in the teaching of corporate finance. The use of spreadsheets enable students to obtain the skills required to apply corporate finance theory in the real world. Yet, there is limited focus in academic courses on the design and layout of financial models to ensure the integrity of spreadsheets, even when the consequences of errors have been shown to be highly significant in practice. Studies have indicated errors in 20% to 80% of operational spreadsheet models and KPMG have reported error rates of over 90%. The objectives of this paper are to analyse the main issues relating to spreadsheet design, the methods used to minimise modelling errors and to evaluate the role of documentation in building financial models. These issues are often not addressed in an educational setting.

The consequences of incorrect model design, model structures that increase the potential for errors and a lack of documentation may not be acute due to the limited ambit of spreadsheet models in an academic course setting. Yet, non-adherence to the fundamental principles of spreadsheet design can have lasting effects on what students do in the work environment later on. The paper further analyses how the issues of complexity, interdependencies, model maintenance and “what-if” analysis influence model design. This paper will consider how the interrelated issues of model design and layout, avoidance of errors and documentation are crucial in setting up financial models. The paper expands how effective spreadsheet design can be integrated within a corporate finance course and how these principles can be imparted in small and large class settings.
@InProceedings{CORREIA2011ROL,
author = {Correia, C. and Minter, T.},
title = {THE ROLE OF SPREADSHEET MODEL DESIGN IN CORPORATE FINANCE COURSES},
series = {4th International Conference of Education, Research and Innovation},
booktitle = {ICERI2011 Proceedings},
isbn = {978-84-615-3324-4},
issn = {2340-1095},
publisher = {IATED},
location = {Madrid, Spain},
month = {14-16 November, 2011},
year = {2011},
pages = {356-365}}
TY - CONF
AU - C. Correia AU - T. Minter
TI - THE ROLE OF SPREADSHEET MODEL DESIGN IN CORPORATE FINANCE COURSES
SN - 978-84-615-3324-4/2340-1095
PY - 2011
Y1 - 14-16 November, 2011
CI - Madrid, Spain
JO - 4th International Conference of Education, Research and Innovation
JA - ICERI2011 Proceedings
SP - 356
EP - 365
ER -
C. Correia, T. Minter (2011) THE ROLE OF SPREADSHEET MODEL DESIGN IN CORPORATE FINANCE COURSES, ICERI2011 Proceedings, pp. 356-365.
User:
Pass: