GETest

Name ________________________
Middle School Mathematics/Numerical Reasoning /Draft
County School Board of Fairfax County, Virginia 1997
Date ________________________


N.7.5.2, Modified

1. A student invests $7,000 in a bond that pays 9.5%, compounded quarterly for a period of three years.

In the spreadsheet below, write values in cell C5 and cell D5.
Write a formula in cell E5 to calculate the interest earned.
Write a formula in cell B6 to calculate the new principal.
Fill in the values and formulas through row 16.
Write a formula in cell B17 to calculate the total value of the investment after three years.

Quarterly Compounded Investment
Annual Time Quarterly
Quarter Principal Interest Rate in Years Interest

1

$7,000.00

2

3

4

5

6

7

8

9

10

11

12

Final Value