Teaching basic finance with Excel, and without pain

Sugden, Stephen John (2012) Teaching basic finance with Excel, and without pain. In Proceedings of the 2012 Hawaii International Conference on Education, Hawaii International Conference on Education, Honolulu, Hawaii, pp. 1-9.

View at publisher (open access)


The five quantities of interest in elementary finance problems are present value, future value, amount of periodic payment, number of periods and the rate of compound interest per period. A recursive approach to computing each of these five quantities in a modern version of Excel, for the case of ordinary annuities, is described. The aim is to increase student understanding and build confidence in the answer obtained, and this may be achieved with only linear relationships and in cases where student knowledge of algebra is essentially zero. Annuity problems may be solved without use of logarithms and black-box intrinsic functions; these being used only as check mechanisms. The author has had success with the method at Bond University and surrounding high schools in Queensland, Australia.

Impact and interest:

Search Google Scholar™

Citation counts are sourced monthly from Scopus and Web of Science® citation databases.

These databases contain citations from different subsets of available publications and different time periods and thus the citation count from each is usually different. Some works are not in either database and no count is displayed. Scopus includes citations from articles published in 1996 onwards, and Web of Science® generally from 1980 onwards.

Citations counts from the Google Scholar™ indexing service can be viewed at the linked Google Scholar™ search.

ID Code: 73245
Item Type: Conference Paper
Refereed: Yes
Keywords: Present Value, Future Value, Periodic Payment, Number of Periods, Compound Interest, Finance, Excel, HERN
ISSN: 1541-5880
Divisions: Current > Schools > School of Mathematical Sciences
Current > QUT Faculties and Divisions > Science & Engineering Faculty
Copyright Owner: Copyright 2012 [please consult the author]
Deposited On: 08 Jul 2014 22:25
Last Modified: 14 Jul 2014 03:48

Export: EndNote | Dublin Core | BibTeX

Repository Staff Only: item control page