Spreadsheet-Based Modeling for Teaching Finance and Accounting Courses

28 Pages Posted: 18 Mar 2003

Date Written: May 16, 2005


The teaching of the quantitative aspects in accounting and finance poses inherent challenges and even if students have such quantitative skills, they often find it hard to really grasp the meaning of such theories or concepts. This paper advocates embedding the teaching of these concepts into spreadsheet and computer modeling exercises. The approach is motivated by the author's experience of teaching dedicated spreadsheet-based modeling courses in finance whose structure and content is documented with this article. These courses put modeling into the centre while students acquire truly applicable concepts in finance and accounting almost automatically along the way. This practical "hands-on" method does not only provide a means of enhancing understanding and retention but it is also bound to improve employability of students as they become more adept in their use of analysis tools widely used in today's work environment.

Keywords: Teaching, finance, financial modeling, spreadsheets, excel, VBA

JEL Classification: A20, C60

Suggested Citation

Hess, Kurt, Spreadsheet-Based Modeling for Teaching Finance and Accounting Courses (May 16, 2005). Available at SSRN: https://ssrn.com/abstract=378680 or http://dx.doi.org/10.2139/ssrn.378680

Kurt Hess (Contact Author)

Independent Credit View ( email )

Schweizergasse 21
Z├╝rich, 8001

Do you have a job opening that you would like to promote on SSRN?

Paper statistics

Abstract Views
PlumX Metrics