Using What-If Analysis
In Excel what if analysis lets you answer questions with data. With what if analysis Excel also lets you experiment with data.
- Open an existing Excel 2010 workbook. If you want, you can use this example.
- Use Goal Seek to determine an unknown value. If you're using the example, go to the History Class worksheet and use Goal Seek to determine what grade you would need on Test 3 to earn a final grade average of 90.
- Insert the PMT function into the worksheet. If you are using the example, go to the Car Loan worksheet and insert the function into cell B5.
- Use Goal Seek to find the interest rate you'll need in order to have a monthly payment of $400. What interest rate would you need if you could only afford a $380 monthly payment?