Basic finance made accessible in Excel 2007: "The Big 5, Plus 2"

Stephen Sugden, Bond University
David Miller, West Virginia University

Article comments

Published Version.

Sugden, S., & Miller, D. (2010). Basic finance made accessible in Excel 2007: "The Big 5, Plus 2". Spreadsheets in Education, 4(2), 1-29.

Access the Journal's homepage.

2010 HERDC submission. FoR Code: 019900

© Copyright Stephen Sugden & David Miller, 2010.

Abstract

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.