Investing for Retirement

Joseph Meyinsse, Southern University, Baton Rouge, Louisiana 70813
Author Profile
This material is replicated on a number of sites as part of the SERC Pedagogic Service Project

Summary

In this Spreadsheets Across the Curriculum activity, students build spreadsheets to study the effect of compound interest on accounts into which they deposit savings. They build a spreadsheet to examine the two basic cases: the future value of a single deposit, and the future value of an annuity. In both, they use the mathematical equation for future value to do the calculation, not the buiilt-in Excel function. The intention is for the students to see and work with the underlying mathematics. They apply their spreadsheets to a variety of problems, including the following question: For a given interest rate, how much does one need to deposit every year to accumulate two million dollars in the account at the time of retirement?

Learning Goals

Students will: In the process students will:

Context for Use

This module can be used in a General Math course taken by non-technical majors needing to meet a 6 hour requirement.

Description and Teaching Materials

The module is a PowerPoint presentation with embedded spreadsheets. If the embedded spreadsheets are not visible, save the PowerPoint file to disk and open it from there.

The above PowerPoint files are the student version of the module. An instructor version is available by request. The instructor version includes the completed spreadsheet. Send your request to Len Vacher (vacher@usf.edu) by filling out and submitting the Instructor Module Request Form.

Teaching Notes and Tips

In this Spreadsheets Across the Curriculum activity, this module will motivate students to appreciate mathematical applications to real life experiences. Planning for retirement is easy when you know the basic mathematics involved in investment.

Assessment

A pre-test is given with the instructor version. Also, the end of module questions could be used for assessment.

References and Resources

See more SSAC General Collection Modules »