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.