A dynamic goal seek can be useful in project finance models when you have a an equal installment or a level repayment. The similarity is that you need to re-program equations in excel and that you must do this with a user-defined function that has so kind of iteration loop. The process of making a dynamic goal seek is similar to resolving a circular reference with a user-defined function. But sometimes you may want to have the goal seek work on a dynamic basis, meaning that you do not want to go to the data menu and then hit the what if analysis and enter the target cell etc. A dynamic goal seek function is where you make a function that automatically changes to an output variable that comes from a goal seek when you change one of the inputs. The goal seek is a wonderful tool in excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |