Working with Goal Seek


show more Working with Goal Seek provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 Essential Training show less
please wait ...

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 wa...

Working with Goal Seek
Video duration: 5m 29s 6h 21m Beginner

Viewers:

Working with Goal Seek provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 Essential Training

Subjects:
Business Education + Elearning
Software:
Excel
Author:
please wait ...