Question: Start in column D , then move across allowing the column to change, and multiply the preceding value by its FIXED growth rate in cell
Start in column D then move across allowing the column to change, and multiply the preceding value by its FIXED growth rate in cell $$which is plus the percentage expected growth to get the current
"Start in column D then move across, and multiply the preceding value by its growth rate in cell $Bwhich is plus the percentage expected growth to get the current value,"
By changing the growth rate cell from $B$ etc. to $ the row of the growth rate is allowed to change yet remain in column B while filling down to the other two Investments."
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
