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.
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:
Citation counts are sourced monthly from and 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 theindexing service can be viewed at the linked Google Scholar™ search.
|Item Type:||Conference Paper|
|Keywords:||Present Value, Future Value, Periodic Payment, Number of Periods, Compound Interest, Finance, Excel, HERN|
|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|
Repository Staff Only: item control page