The impact of training in financial modelling principles on the incidence of spreadsheet errors

Ian Beaman, Erwin Waldmann and Peter Krueger

Accounting Education, 2005, vol. 14, issue 2, 199-212

Abstract: Spreadsheet models are used extensively in business as an important aid in decision support particularly in areas like financial analysis, budgeting and forecasting. If these models were compromised through quantitative and qualitative errors, the resulting decision making would be based on fallacious information with potentially disastrous outcomes. Consequently, it is imperative that accounting professionals receive adequate training in spreadsheet modelling, especially as past research has shown that these types of errors are common. This paper reports on a survey and spreadsheet exercise given to a group of second-year undergraduate accounting students at an Australian university, both before and after a semester course aimed specifically at teaching spreadsheet design principles and problem-solving techniques. The findings show that spreadsheet errors and, in particular, spreadsheet design errors are prolific even for a simple domain-free exercise. Results also show that the incidence of these errors (and again, particularly design errors) was reduced significantly after a semester of teaching spreadsheet design principles. The results support the contention that accounting educators should include a course in spreadsheet design principles and problem-solving techniques as part of an undergraduate accounting program.

Keywords: End user computing; spreadsheet; modelling; error; spreadsheet design (search for similar items in EconPapers)
Date: 2005
References: View complete reference list from CitEc
Citations: View citations in EconPapers (1)

Downloads: (external link)
http://www.tandfonline.com/doi/abs/10.1080/0963928042000229699 (text/html)
Access to full text is restricted to subscribers.

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:taf:accted:v:14:y:2005:i:2:p:199-212

Ordering information: This journal article can be ordered from
http://www.tandfonline.com/pricing/journal/RAED20

DOI: 10.1080/0963928042000229699

Access Statistics for this article

Accounting Education is currently edited by Richard Wilson

More articles in Accounting Education from Taylor & Francis Journals
Bibliographic data for series maintained by Chris Longhurst ().