The following lesson plan is designed for students who have studied integer exponents. The mathematics of finance tends to grab the interest of students because it associates rather sterile numbers with something students are interested in... money. In addition to the motivational factor, it is also very practical topic. My suggestion for implementing the lesson would be to have a short introduction in which vocabulary is discussed but as quickly as possible have students work on applications. In the following lessons only exercises using Excel are given. These can be complimented with more traditional exercises. To begin with, we need to introduce some vocabulary.

**Interest-**The fee paid for the use of someone else's money.

**Principal-**The amount of money borrowed or deposited.

**Simple interest-**Interest paid only on the amount deposited and
not on past interest.

**Future value-**The total amount of principal and interest in an
account. The account can be on either a loan or an amount that has been
deposited.

**Compound interest-**Interest that is charged (or paid) on interest
as well as principal.

**Compound amount-**The amount of principal and interest in an account
that draws compound interest.

**Annuity-**An account in which a sequence of equal payments are made
at equal time intervals.

**Note: Some of the financial formulas are functions in Excel. Teachers
should decide if students are to be allowed to use these. The spreadsheets
and graphs below are active and have the formulas put in manually.**

**Lesson 1-Simple Interest**

The simple interest, **I**, for **t** years on an amount of **P**
dollars at a rate of interest **r** per year for **t** years is

The future value or maturity value, **A**, of **P **dollars for
**t **years at a rate of interest of r per year is

After going over the details of making sure students enter t in years (11 months = 11/12 years), have the students create the following Excel document.

Suppose $2000(in each of the following exercises I have chosen $2000-one summer worth of savings) is invested at 8% interest, how long would it take to have $3500 in the account? This could lead to a discussion of how to solve this problem algebraically?

Have students describe how fast the account is growing? How does this relate to the graph?

**Lesson 2-Compound Interest**

If **P **dollars are deposited for **m** compounding periods per
year for **n** years at a rate of interest **r** per period, the compound
amount **A** is

**.**

In the following Excel exercise, have students examine the effects of changing the compounding periods each year for the following problem.

Suppose the $2000 is invested at a rate of 8% for 10 years, what are the compound amounts for the following compounding periods?

Why is the graph not linear? The above graph is for the first two columns on the worksheet.

**Note: **An additional exercise to accompany the following would
be to have students evaluate the following sequence (1 + 1/n) as
n becomes large using Excel.

**Lesson 3-Future Value of an Annuity**

The future value **S** of an ordinary annuity of **n** payments
of **R** dollars each at the end of consecutive interest periods with
interest compounded at a rate of** i**=r/m per period is

There are alternate ways of working problems like the following without using the above formula. Excel is a very versatile medium for students to explore and find alternate methods for solutions.

Suppose at the age of 18 a student begins putting away $2000 per year for 10, 20, 30, or 40 years, how much money will be in the account at the end of each of the given years? In order to make changes in our assumptions about the interest rate, the following Excel worksheet makes use of the $ sign function.

**Lesson 4-Present Value**

The present value P of an annuity of n payments of R dollars each at the end of consecutive interest periods with interest compounded at an interest rate i=r/m per period is

A car costs $15,000. After a down payment of $1000, the balance will be paid off in 48 monthly payments with interest of 12% per year on the unpaid balance. Find the amount of each payment. Prepare an amortization schedule for the loan.

Students will be surprised as they calculate the total amount of interest paid on the loan.

This brings us to financing a home.

**Lesson 5-The Big Investment**

One of the biggest investments most people will ever make is buying a home. The following exercise is designed for students to experiment around with the length of the loan and interest rates.

After a down payment, a family can finance $100,000 for a home. Interest rates vary slightly from bank to bank. Is this a big deal?

In the Excel chart, the interest rate and total payments are variable. Students should be allowed explore payments as these two quantities vary. As a final project, students might be asked to do an essay on financing a house given several constraints such as maximum amount of monthly payments or varying interest depending on the length of the loan. Students might use graphs to support there conclusions.

There are numerous ways to assess students progress through this unit. Presentations, essays, computer work, pencil and paper exercises and tests. These lessons are designed for students to be active. Enjoy!!!

Back to **Mike
Callinan's Home Page**