Tools goal seek

The price of each generator is Rs , and the quantity sold is nos. We can see that the company is suffering a loss of It is identified that the maximum price for which a generator can be sold is Rs. Now, It is required to identify the no. In the above figure, a person has taken a loan amount of Rs When he calculated the total amount, which he will be repaid in 45 months, he got Rs Now he wants to increase the number of repayment periods as he would not be able to pay Rs However, he does not want to increase the total amount of repayment by more than Rs In the above figure, a person wants to invest a lump sum amount in his bank for a certain period of time.

The bank employee suggested he open a Fixed Deposit Account. The rate of interest is 6. So to find out the return, the person uses the FV function procedure of calculation is shown in the above figure.

The most widely used example of a personal use case of Goal Seek is the loan example. You know the amount you need, you know how many months you want to pay it back, and you know the amount you can afford to pay back each month.

You can use Goal Seek to determine the interest rate you need to secure in order to stay within your monthly budget. So, we know the desired outcome, and we have all of the data except one value: Q4.

Based on the data we currently have, we can use the Goal Seek function to determine what the net profit of Q4 needs to be in order to achieve the set goal. Before we go further, there are a few basic Excel functions that we are using in this example.

Do this for rows 3, 4, and 5, as well. Now that those basic Excel functions are in place, we can use Goal Seek to determine what we need to close Q4 with to meet our annual goal. This is the cell that we want to change to our desired goal.

Once selected, a box will appear around the cell and the respective row number and column letter will be highlighted in gray. Next, click the Data tab, click the What-If Analysis option in the Forecast group, and then click the Goal Seek option from the drop-down menu.

Enter the required information and then click OK. Excel will start analyzing the data and spit out the number required in B5 to meet the desired goal.

For example, the mathematical function behind the calculation may have many non-continuous points. If Gnumeric did not find a solution that generates the desired result, you may want to try to specify a range minimum and maximum in which the value of the output variable should be.

Go to page content Go to main menu Go to the search field. About Users Administrators Developers. Goal Seek Tool. Using the Tool 6. Results 6.