For corporate finance, the dynamic goal seek could be useful in deriving the equity capital injection to reach a target capital structure so that you do not have to run the solver. If you later want to operate another goal seek that derives prices or capital expenditures this can be very useful. 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 |