Now you would like to track the value of all three investments over the same $10-$year period in rows $22,23,$ and $24.$ Start by creating a formula in D$22$ that is like the formula in D$13.$ However, there is one change to make.

Knowing that you will want to drag the entire $10-$year span in row $22$ down to rows $23$ and $24,$ the row reference in the $(1+$ growth rate$)$ calculation must be able to change as you drag. That is done by removing the dollar sign $($$$)$ in front of the row number in the growth calculation. Make sure that is done in cell D$22,$ then drag across to M$22$ to obtain the values for Investment A$.$

Finally, select all cells from D$22$ to M$22,$ and then drag down to fill the next two rows. Now you have the values for Investment B and Investment C$.$ Notice the format of the formulas in cells D$22$:M$24.$ What is the value of each investment in year $10?$

Investment A: $fill in the blank $15($to the nearest dollar$)$

Investment B: $fill in the blank $16($to the nearest dollar$)$

Investment C: $fill in the blank $17($to the nearest dollar$)$