template - Saved Search for tools, help, and more (Option + Q) File Home Insert Share Page Layout Formulas Data Review View Help Draw D22 Arial 10▾ B = Currency $€.% 1 3 4 Investment A 5 Investment B 6 Investment C 7 Growth Rate (Expected) Year 0 11% $1,700 7% $1,700 2% $1,700 Year 1 Formulas $1,887 =C4*(1+B4) $1,819 =C4*(1+B5) $1,734 =C4*(1+B6) F G H RELATIVE CELL REFERENCES 8 "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)." # Editing Comments Q K M N о 9 10 ABSOLUTE CELL REFERENCES 11 Growth Rate 12 13 Investment A (Expected) Year 0 11% $1,700 Year 1 $1,887 Year 2 $2,095 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 $2,325 $2,581 $2,865 $3,180 $3,529 $3,918 $4,349 Year 10 $4,827 14 15 Formulas 16 =C13*(1+B13) D13*(1+$B$13) =E13*(1+$B$13) =F13*(1+$B$13) =G13*(1+$B$13) H13*(1+$B$13) =113*(1+$B$13) =J13*(1+$B$13) =K13*(1+$B$13) =L13*(1+$B$13) 17 "Start in column D, then move across allowing the column to change, and multiply the preceding value by its FIXED growth rate in cell $B$13 (which is 1 plus the percentage expected growth) to get the current value." 18 19 FIXED COLUMN/RELATIVE ROW CELL REFERENCES 20 Growth Rate 21 (Expected) Year O Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 22 Investment A 11% $1,700 23 Investment B 7% $1,700 24 Investment C 2% $1,700 25 26 Formulas #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A 27 28 #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A 29 30 "Start in column D, then move across, and multiply the preceding value by its growth rate in cell $B22 (which is 1 plus the percentage expected growth) to get the current value." 31 "By changing the growth rate cell from $B$22, etc. to $B22, the row of the growth rate is allowed to change yet remain in column B while filling down to the other two Investments." 32 33 34 35 < =Sheet1 + Workbook Statistics Give Feedback to Microsoft 100% +