StarOffice™ 5.2 Calc Handbook

Using Goal Seek

Goal Seek allows you to determine the values that are required for a particular function when you set a specific value as the target return for the function. Goal Seek is very useful in cases where you want to see what your sales figures would have to be to reach a certain annual sales figure or to compute the interest rate that you would have to receive on a particular investment to reach a goal value.

Let's say you want to make a monthly payment into an investment account so that over a 10-year period at a 6% annual interest rate, you end up with 20,000 dollars in the account. All you have to do is set up Calc's PV formula and then use Goal Seek to figure out how much the monthly investment payment into the account would have ...