n Learning and Teaching Mathematics - Using spreadsheets to "get inside" annuities

Volume 2011, Issue 10
  • ISSN : 1990-6811


Over the past few years I have spent a great deal of time working on the use of spreadsheets for learning financial mathematics. My goal in doing this has been to "get inside" the formulae for simple and compound interest and for annuities. In doing so, I wanted to understand more deeply how the money was growing each month, and to help teachers and learners to do the same. The formulae that we use in financial maths at school provide efficient ways to calculate answers but they don't really help us to understand what is happening month-by-month, particularly with annuities. In this article I wish to share four spreadsheets that have become an integral part of my teaching of financial maths with pre-service secondary maths teachers. All four spreadsheets focus on annuities. The first two spreadsheets focus on future value of an ordinary annuity while the third and fourth spreadsheet focus on present value of an annuity.

Loading full text...

Full text loading...


Article metrics loading...


This is a required field
Please enter a valid email address
Approval was a Success
Invalid data
An Error Occurred
Approval was partially successful, following selected items could not be processed due to error