RELATIVE CELL REFERENCES

Growth Rate

(Expected)

Year 0

Year 1

Formulas

Investment A

11%

$1,700

#N/A

Investment B

10%

$1,700

#N/A

Investment C

5%

$1,700

#N/A

"Take each value in column C and multiply it by its adjacent growth rate in column B (which is 1 plus the percentage expected growth)." Investment A: $ (to the nearest dollar) Investment B: $ (to the nearest dollar) Investment C: $ (to the nearest dollar)