Title

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

Date of this Version

1-1-2010

Document Type

Journal Article

Publication Details

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.

 

This document has been peer reviewed.