00:42 So the first thing that I'm gonna do before I start messing around.00:39 if I had some goal with contributions or target interest rates.00:35 would happen if I had some goals that I wanted to reach about future earnings, or.00:32 Now, I want to play around with this a little bit and see what.00:28 actually go to cash that in after the end of year ten.00:26 If I do, I should earn about $20,000 by the time I.00:23 And I'm hoping to earn 6.5 percent interest.00:20 So $1500 here, I'm going to try and put this away for ten years.

00:16 a financial contribution for a number of years.00:12 what you can see here is my little table has some values set up for.00:09 bit of what if analysis around a scenario here, so.00:04 In this video we're gonna look at some ways that we can actually do a little.Try goal seeking to work out the interest rate you’d need to achieve in order to earn $27,500 given the 1500 contribution over 10 years.Roll back to the base case using the Scenario manager.Click OK and watch as Excel runs the numbers to find out what the value of our variable in B3 needs to be in order to have B7 result in a value of $27,500.Choose to Set cell B7 to a value of 27,500, by changing B3.Select cell B7 and go to Data -> What-If Analysis -> Goal Seek.Click Base Case and Show, and your original data will come back.

Select the new scenario and click Show (your data will change).

Click OK to set the new value, then click OK.

Pick the cell you want to change in the Changing Cells box and click OK.

Click Add, and enter a descriptive name for the Scenario Name.

Pick the cell(s) you want to change in the Changing Cells box and click OK.

Click Add, enter Base Case for the Scenario Name.

Open the Scenario Manager by going to Data -> What-If Analysis -> Scenario Manager.

NOTE: It is highly recommended to create a Base Case scenario that you can roll back to!.

These tools work very well when you either want to try seeing how things would look with different variables in place, or when you need to work out what variables will drive the outcome you’re looking for. Performing what-if analysis in Excel using the Scenario Manager and Goal-Seek.

Quick analysis button excel mac