if you try to drag 013 to the right to fill in the remaining years, you will get some very strange numbers! That is because the growth rate cell 813 is changing a ever, you need that cell to say fixed in place for all the formulas as you drag to fill E13 through M13. The way to fix cell B13 in place is using an absolute cal erence. Instead of B13 in the formula change it to $B$13 and then drag to the right to fill Year 2 through Year 10. Enter those values below (to the nearest doll use a dollar sign (5), just the value.

ture ocotlar son (1), kist the valie. 8 "Take each value in column C and multiply it by its adjacent growh rate in column B (which is 1 plus the percentage exp 16 17 "Start in column D, then move across allowing the column to change, and multiply the preceding value by its FIXED grov