Question
FIXED COLUMN / RELATIVE ROW CELL REFERENCES Growth Rate (Expected) Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year
FIXED COLUMN / RELATIVE ROW CELL REFERENCES | ||||||||||||
Growth Rate | ||||||||||||
(Expected) | Year 0 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 | |
Investment A | 11% | $1,700 | ||||||||||
Investment B | 10% | $1,700 | ||||||||||
Investment C | 5% | $1,700 | ||||||||||
Formulas | #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 | |||
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | |||
"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." | ||||||||||||
"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." Fixed Column / Relative Row Cell References 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 D22 that is like the formula in D13. 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 D22, then drag across to M22 to obtain the values for Investment A. Finally, select all cells from D22 to M22, 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 D22:M24. What is the value of each investment in year 10? Investment A: $ (to the nearest dollar) Investment B: $ (to the nearest dollar) Investment C: $ (to the nearest dollar) |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started