S
speed2
Hi guys, i have got this assignment in which iam using a spreadsheet to
simulate investment returs over time. I use the ran() function and then
vlookup() to determine the interest rate which applies to the
investment... Anyway i have been provided with a "standard macro" which
re-runs the spreadsheet a set amount of times (say a 1000) and stores
the accumulated value of the final investment return, which i can use
to determine the average investment return.
One of the questions requires me to determine what level of saving ( a
%) will yield a certain amount of dollars at the end. Now using just a
normal spreadsheet (without macro) i can use goal seek to find what
level of saving will yield that certain amount, but with the macro goal
seek fails to work. Just wondering if there is any other way?
simulate investment returs over time. I use the ran() function and then
vlookup() to determine the interest rate which applies to the
investment... Anyway i have been provided with a "standard macro" which
re-runs the spreadsheet a set amount of times (say a 1000) and stores
the accumulated value of the final investment return, which i can use
to determine the average investment return.
One of the questions requires me to determine what level of saving ( a
%) will yield a certain amount of dollars at the end. Now using just a
normal spreadsheet (without macro) i can use goal seek to find what
level of saving will yield that certain amount, but with the macro goal
seek fails to work. Just wondering if there is any other way?