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.

Resources

Post-Acquisition Finance Transformation Ebook

Our free ebook offers a memorable, staged framework for navigating the complex post-acquisition finance transformation process, as well as key considerations and items for each stage.

October 21, 2021George Jacob

Financial Planning & Analysis

Tools for Building Financial Models for New Products and Services

As we scroll on our phones to pass time, we constantly get flooded with targeted ads for new products. Whether it’s for the latest iPhone or a knife so sharp that it can cut through pennies, the appetite for new products and services is a common, daily pang. The level of demand has no ceiling,… View Article

October 14, 2021Romesh Jayawardene

Financial Planning & Analysis

How to Create Better CAPEX Business Memos

At some point in time, all businesses will need to invest in new equipment, undertake a large project or take on several strategic initiatives to improve efficiency or generate additional revenues. Capital expenditures (CAPEX) are an inevitable part of growing and maintaining a competitive business. Over the years, I have been involved in various CAPEX… View Article

October 6, 2021Ebrahim Allana

See All

Back to Insights