**ERIC Number:**ED469079

**Record Type:**Non-Journal

**Publication Date:**2002

**Pages:**21

**Abstractor:**N/A

**Reference Count:**N/A

**ISBN:**N/A

**ISSN:**N/A

Calculating the Variables of Finance on a Spreadsheet.

Rochowicz, John A., Jr.

The different approaches for solving problems and learning mathematics with technology are invaluable. This paper describes how to determine the variables of the ordinary annuity equation with a spreadsheet. Examples of future value of annuity, sinking fund annuity, the number of periods necessary for periodic payments plus interest to accumulate to a future value, and the rate per period needed for periodic payment plus interest to accumulate to a future value are described. With formulas, algebra, approximation, and technology, these mathematics applications are studied in different and meaningful ways. Although learning to use technology may be an obstacle to implementation for some educators, the use of spreadsheets enables the student to learn mathematics with little interference from technology and focus more on relevant topics and less on tedious calculations. Since society is relying more on technology, computer and calculator use for mathematics instruction is also becoming increasingly necessary. (Author)

**Publication Type:**Reports - Descriptive

**Education Level:**N/A

**Audience:**N/A

**Language:**English

**Sponsor:**N/A

**Authoring Institution:**N/A