01:40 I could go and change this to $2,000.01:37 And at this point, we now have a scenario set up.01:28 we're gonna enter values by changing each of these cells, $1500.01:26 It comes back, and it says all right, so.01:22 And we click that again, and we say Okay.01:19 and I'd like to change all three of these cells.01:17 I'm gonna click this little raffette box here,.01:14 And it says what cells would you like to change?.
01:12 So this is my base case scenario.01:09 I'm going to call this scenario, Base.
EXCEL FOR MAC WHAT IF ANALYSIS PLUS
01:05 So what I'm gonna do is I'm going to click the plus button to add one, and.01:02 You'll notice there's no scenarios to find right now.00:57 I'm gonna go to what if analysis and I'm gonna choose the scenario manager.00:54 So to do that I'm gonna go to the data tab and.00:52 I can always roll back to them very easily.00:48 I'm actually gonna use a little tool here to lock these values in so.00:45 with the numbers here and trying to guess by putting values in,.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.
0 kommentar(er)
