4/1/2024 0 Comments Use goal seek excel 2013![]() To return to the original values, click Cancel in step 4 instead of clicking OK after viewing the result in the dialog. Specifically, you must enter the desired payment as a negative value. If Goal Seek doesn't work, revisit the To value in step 3. (Deposits matter, but we won't complicate this example with more variables than we need.) Figure A shows a simple mortgage calculator where all variables are known: to repay a 6% loan on $200,000 over 15 years, your monthly payment must be $1,687.71. What if the payment your lender offers is too high for your budget? Using Goal Seek can help by evaluating the payment formula and returning new values for the rate, term, and even the principal to fit your desired payment. Use Goal Seek when you don't have an exact value to use.Ĭalculating the terms of a loan is a good example of a what-if situation. Or, put another way, Goal Seek determines input values needed to achieve a specific goal. For our purposes, Excel's Goal Seek feature lets you adjust a value used in a formula to achieve a specific goal. Technically, Goal Seek is a process of calculating a value by performing what-if analysis on a given set of values. For your convenience, you can download the example. This tool tells you how variables must change to achieve a specific goal. You might be asking what a what-if tool is these tools show you the impact of making a change without impacting the actual data. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |