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 Systems

Notes From the Field: MS Dynamics 365 Implementation Considerations

For any ERP implementation, the goals are usually operational scalability and process streamlining, resulting in increased overall efficiency. To achieve these goals, it is important the chosen ERP system is a strong fit for the organization. There are many ERP systems on the market now, from fairly straightforward (Odoo) to highly specialized (Investran) to very… View Article

October 1, 2020Ellen Vayner

Business Advisory

Treasury Management: The Best Defense is a Good Offense

Most organizations do not see their Treasury Department, if they have one at all, as a critical strategic partner until a crisis arises. However, uncertainty can occur suddenly and without a clear endpoint. For example, a key vendor may go out of business, new legislation could make raw material prices skyrocket, banks could freeze the… View Article

September 29, 2020Danelle Lawsen

Financial Reporting & Accounting

Key Considerations for Selecting ASC 842 Lease Accounting Software

FASB’s “new” lease accounting standard, ASC 842, has been in the works for several years, though the final effective date for non-public companies has been delayed several times. (The most recent news is that ASC 842 Lease Accounting will be effective for fiscal years beginning after December 15, 2021, and interim periods within fiscal years… View Article

September 24, 2020Mark Christian

See All