What it means
Most financial models run forwards: you enter assumptions, and the spreadsheet returns a result. Goal seeking runs the same model in reverse, fixing the output at a target and adjusting one input until the equation balances.
Spreadsheet tools automate this, but the underlying idea is simply algebra applied to a business question. It matters because business conversations are usually framed as targets rather than assumptions.
A board does not ask what happens if volume grows 11.4%; it says it wants $2,000,000 of operating profit and expects finance to say what that implies. Goal seeking converts an ambition into a specific, testable operational requirement.
In practice the technique is used for break-even volumes, required selling prices, permissible cost levels, loan repayment amounts and the discount rate that makes a project's net present value exactly zero, which is the internal rate of return. Each is the same move: hold everything constant, name the output, solve for the one input you are willing to change.
The discipline is choosing which single variable is genuinely under management control. The main limitation is that goal seeking changes one input at a time and ignores the relationships between them.
Raising price to hit a profit target usually reduces volume, so a naive answer can be arithmetically correct and commercially impossible. Sensible practice is to use goal seeking to find the number, then sanity-check it against market reality or run a wider scenario analysis alongside it.
In practice
Real-world examples.
Example
A subscription business needs to reach $5,000,000 of annual recurring revenue by year end. Finance fixes the target and solves for the monthly new-customer count required at the current average contract value and churn rate. The answer, 340 new accounts a month, immediately tells the marketing team its budget request is too small.
Example
A construction firm is bidding for a fixed-price contract and knows its required margin is 12%. Rather than pricing up costs and hoping, it sets the margin as the target and solves for the maximum subcontractor cost it can accept. That number becomes the ceiling for negotiations with trades.
Example
A homeowner wants a monthly mortgage payment of no more than $1,800. The lender fixes the payment as the goal and solves for the loan principal at the current rate and term. The result reframes the search from "what can I borrow" to a concrete property price ceiling.
Formula
Calculation
Goal seeking solves for the unknown input in an equation you already have. For a profit target the rearranged equation is:
Required units = (Fixed costs + Target profit) / Contribution margin per unit
A hardware business sells a unit for $120 and incurs $75 of variable cost per unit.
Contribution margin per unit = $120 - $75 = $45.
Fixed costs are $180,000 a year and the board wants $90,000 of operating profit.
Required units = ($180,000 + $90,000) / $45 = $270,000 / $45 = 6,000 units.
Checking the answer forwards: 6,000 units x $45 = $270,000 of total contribution, less $180,000 of fixed costs, leaves exactly $90,000 of profit. At that volume, revenue is 6,000 x $120 = $720,000 and total variable cost is 6,000 x $75 = $450,000. The commercial question then becomes whether 6,000 units is realistic, because the arithmetic cannot answer that.Case study
Seen in the real world.
Peakview Ceramics is a fictional tile manufacturer used here purely as an illustrative example. Its board approved a plan requiring $90,000 of operating profit from a single product line carrying $180,000 of annual fixed costs, a $120 selling price and $75 of variable cost per unit.
Finance used goal seeking rather than guessing at volume assumptions. Holding price and cost constant, the required volume came out at 6,000 units, some 1,400 units above the prior year. Because the sales team believed only 4,800 units were achievable, the model was run again with volume fixed at 4,800 and price as the free variable.
That second pass showed the price would need to rise materially to hit the same profit, which the commercial director judged impossible against imported competition. In this fictional case, goal seeking did not save the plan, but it turned a vague target into two specific, arguable numbers and forced the fixed cost base onto the agenda instead.
Watch out
Common mistakes.
- Solving for a variable that management cannot actually change. Finding the raw material price that would make a plan work is useless if the business has no influence over that market.
- Forgetting that inputs are linked. Solving for a higher price while holding volume constant quietly assumes demand is completely insensitive to price, which is rarely true.
- Treating the answer as a forecast. Goal seeking tells you what would have to be true, not what is likely to happen.
Questions
People also ask.
Is goal seeking the same as break-even analysis?
Break-even analysis is one specific application of goal seeking, where the target profit is set to zero.
Can goal seeking handle more than one variable at once?
Not directly, since it solves for a single input; changing several at once requires an optimisation tool or a structured scenario analysis.
Why does goal seeking sometimes fail to find an answer?
Usually because no value of the chosen input can reach the target, for instance when fixed costs alone exceed the maximum possible contribution.
From the founder's library
Take it further with the book.
Build your financial confidence beyond this definition. Shihan's full-length guide, Accounting Fundamentals, takes the same plain-English approach and turns it into a complete, practical playbook for non-finance managers, business owners and students - with chapter-end quiz answers and presentation slides included.
25% off with code MMHQ25, applied at checkout. Priced in USD - checkout may show the equivalent in your local currency.
View the book and save 25%Related