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

Notes from the Field: A Financial Audit Checklist

No matter why a company goes through a financial statement audit, the process is typically very stressful. Audits take place during normal business activity, pulling people and resources in different directions. They require a significant time commitment and a great deal of preparation. The ultimate goal of an audit is to receive an unqualified opinion… View Article

June 30, 2020Sangita Narang

Financial Reporting & Accounting

Interim Controller or Outsourced Controller: Which One Do You Need?

A company may find itself in need of a new Operational or Corporate Controller for any number of reasons. If the need is pressing, then rationalizing resources is appropriate whether it be for an Interim Controller, Outsourced Controller or regular hire. The tough thing can be knowing which of the three will work best for… View Article

June 25, 2020Susan Weikel

M&A Due Diligence & Transaction Support

Types of Due Diligence and What to Expect from the Process

Many mergers and acquisitions (M&A) deals in the 1980s were transacted without much emphasis placed on due diligence. The result? Too many less than ideal outcomes for acquirors caused by post-M&A issues such as cultural mismatches, unexpected legal complications, overly optimistic pre-sale performance forecasts and unrealistic valuations. Consequently, today’s acquirors are much more demanding when… View Article

June 23, 2020Joe Wirija

See All