financial analysis with microsoft excel 2019

Excel can work backwards to change either cell B1, B2, or B3 to reach that goal. Therefore, if we determine that the monthly repayment amount quoted is higher than desired, we can use Goal Seek to set the monthly amount to $1750. In the example above, cell B5 is dependent on the variables in cells B1, B2, and B3.

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.

Financial analysis with microsoft excel 2019