From the course: Excel 2010 Essential Training

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Working with Goal Seek

Working with Goal Seek - Microsoft Excel Tutorial

From the course: Excel 2010 Essential Training

Start my 1-month free trial

Working with Goal Seek

Sometimes you know the result that you want but you are not sure what the data inputs should be to get you there. Well, Excel has this great feature called Goal Seek that will let you tell it what the answer is and it will figure the rest out for you. It's kind of like that game show where they give you the answer and you have to guess the question. Well, by way of an example, our Two Trees Extra Virgin Olive Oil Company, they need a capital loan for a new equipment, because they want to expand production. So they are going to borrow some money and we are going to use the Payment function to help them determine how much they can borrow. Let's just go to Sheet2 here for a second. The Payment function has three arguments to it. The first is the interest rate that you are going to pay. The second argument is how many periods will you pay that back over. And the third argument is what is the present value of the loan, which is kind of a financial way of saying how much money do you want…

Contents