Using Goal Seek in Excel 2007

Share Now

Goal Seek (Part of What-If analysis tool) is very powerful feature of excel.

If you know the result that you want from a formula but you are not sure what input is? In that case you can use the Goal Seek.

For Example:

Suppose that you need to borrow some money. You know how much money you want, for how long period to pay off, and how much you can pay off each month. In that case you can use goal seek feature of excel to determine what interest rate you must take to meet your loan goal.

Applying the Goal Seek to calculate monthly payment using PMT function

In the above spreadsheet screenshot, we have uses PMT function to calculate monthly payment for loan.

D2 = Principal
D3 = Interest rate
D4 = number of payments
D6 = Monthly Payment (using PMT function)

Alternating Interest Rate using Goal Seek

• Click on Data Tab from menu bar
• In Data Tool Panel, click what If analysis
• Click Goal Seek

The following dialogue box appears:

Suppose you can make max payment of $ 400 each month. In the above dialogue box in “Set cell” select D6. In “To Value” enter 400 and in “By Changing Cell” select D3 (Interest Rate).

Now Click OK and you will get the answer. Cell D3 value will become 14.62%.

Share Now
February 19, 2013

0 responses on "Using Goal Seek in Excel 2007"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Tableau Training in Delhi

    All Rights Reserved. EC Analytics Consulting 2014 - 2019.

    NM 23, Sector 14, OLD DLF Colony - Gurgaon (Haryana) India. 9582876837 | Privacy Policy