You want to know at what interest rate you can borrow the loan. Suppose you want to take a loan of 5,000,000 and you want to repay in 25 years. Refer to the chapter – Optimization with Excel Solver in this tutorial. If you have more than one input value to be determined, you have to use the Solver add-in. Goal Seek works only with one variable input value. ![]() Then, by varying the input value in the formula, Goal Seek tries to arrive at a solution for the input value. ![]() Goal Seek requires a formula that uses the input value to give result in the target value. Goal Seek is a What-If Analysis tool that helps you to find the input value that results in a target value that you want.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |