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
November 15, 2019

0 responses on "Using Goal Seek in Excel 2007"

    Leave a Message

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

    Social Media

    facebook page EC Analytics Consulting   Linkedin Page EC Analytics Consulting   Youtube EC Analytics Consulting

    Address:

    NM 23, SECTOR 14, OLD DLF COLONY,
    GURGAON (HARYANA)
    0124- 4601426

    ABOUT EC ANALYTICS CONSULTING

    EC Analytics will help your business make better decisions by providing expert-level business intelligence (BI) services. Forecasting, strategy, optimization, performance analysis, trend analysis, customer analysis, budget planning, financial reporting and more. EC Analytics also offers Advanced Data Analytics training in corporate and retail.

    EC Analytics Consulting @ 2019 ALL RIGHTS RESERVED