Excel Tips

Using Goal Seek in Excel: 8020 Quick Tips

Goal Seek is a useful Excel tool that allows you to see how one data item in a formula impacts another, similar to a cause-and-effect scenario, providing an answer to the “what-if” question.

For example, let’s say your high-end apparel company is looking to go IPO once net profit percentage equals or exceeds 40%, and you are looking to identify a target sales number to communicate to your sales team.

Step 1: Identify the “target goal” in your financial statements.

In this example, “what-if” the net profit is 40%?

Step 2: What needs to happen?

Increase sales, increase “Revenue” to increase Net Profit %, but by how much?

  1. Click on “Data” tab
  2. Click “What-If Analysis”
  3. Click “Goal Seek”

Step 3: Fill in the Blanks

  1. Set Cell – What you want to change? (In this example, it’s cell I10.)
  2. To Value – Your goal, that you need 40% to IPO (.40)
  3. By Changing Cell – What needs to change? (Revenue)
  4. Click “OK”

Step 4: Evaluate Solutions

In order to have 40% Net Profit %, Revenue needs to be $190M instead of $182M.

Want More Insight?

We hope you find this Goal Seek tip useful in managing your finance, sales, and forecasting planning. You can sign up to receive notifications every time we post new insights, just by visiting our blog subscription page!

subscribe to CFO insights

Categorized in: ,

similar articles

Learn to think and approach problems like our financial consultants.

Financial Reporting & Accounting

Finance & Accounting Process Optimization and More Through ESOAR (Part 2)

Once a standardized process has been successfully implemented, efforts can shift towards finance & accounting process Optimization, Automation and Robotization to derive further value.

July 28, 2021Justin Vu

Resources

Accounting Process Improvement Strategies Guide

Get our comprehensive guide to using the ESOAR methodology to improve accounting processes within your organization. This guide also includes a detailed example of an accounting department improving its Provision for Sales Returns process.

George Jacob

Financial Reporting & Accounting

How to Improve Accounting Processes Using ESOAR (Part 1)

Want to know how to improve accounting processes? You might take advantage of ESOAR, a process improvement methodology that can help you drive long-term value. This post covers Elimination and Standardization stages of the methodology.

July 22, 2021Justin Vu

See All

Back to Insights