Basic finance made accessible in Excel 2007 : "the big 5, plus 2"

Sugden, Stephen & Miller, David (2010) Basic finance made accessible in Excel 2007 : "the big 5, plus 2". Spreadsheets in Education (eJSiE), 4(2), pp. 1-32.

View at publisher (open access)


The basic principles and equations are developed for elementary finance, based on the concept of compound interest. The five quantities of interest in such problems are present value, future value, amount of periodic payment, number of periods and the rate of interest per period. We consider three distinct means of computing each of these five quantities in Excel 2007: (i) use of algebraic equations, (ii) by recursive schedule and the Goal Seek facility, and (iii) use of Excel's intrinsic financial functions. The paper is intended to be used as the basis for a lesson plan and contains many examples and solved problems. Comment is made regarding the relative difficulty of each approach, and a prominent theme is the systematic use of more than one method to increase student understanding and build confidence in the answer obtained. Full instructions to build each type of model are given and a complete set of examples and solutions may be downloaded (Examples.xlsx and Solutions.xlsx).

Impact and interest:

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: 73179
Item Type: Journal Article
Refereed: Yes
Keywords: Basic Finance, Spreadsheet, PV, FV, RATE, NPER, PMT, NPV, IRR
ISSN: 1448-6156
Divisions: Current > Schools > School of Mathematical Sciences
Current > QUT Faculties and Divisions > Science & Engineering Faculty
Deposited On: 01 Jul 2014 23:21
Last Modified: 02 Jul 2014 23:25

Export: EndNote | Dublin Core | BibTeX

Repository Staff Only: item control page