![]() ![]() The amount to be paid each month is also calculated and shown in cell B6.īy using the Goal Seek command, we can indicate a desired outcome and Excel will determine the adjustment we need to make to a single variable. Using the above information, the bank calculates that the amount borrowed plus interest over the loan period will be $47,200, as shown in cell B5. To illustrate how it works, imagine that the bank is offering an interest rate of 9% per annum on personal loans with 24 months to repay, and that you would like to borrow $40,000. ![]() Assuming that you know the single outcome you would like to achieve, the Goal Seek feature in Excel allows you to arrive at that goal by mathematically adjusting a single variable within the equation. The simplest sensitivity analysis tool in Excel is Goal Seek. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |