Excel Goal Seek Tutorial: Find Your Target Course Price
Work backwards from a target result, then prove that the price survives rounding and a realistic attendance check. A calculated answer is a starting point for a commercial decision—not permission to skip the assumptions.
19 October 2026 · Desktop Excel · UK training and service businesses
Illustrative example
All figures: Illustrative example. Bar lengths start at zero. Attendance and modelled costs remain fixed.
-
Input set · defined Illustrative example · 40 attendees, £35 variable cost each, £1,800 fixed course costs.
-
Target equation · checkable Illustrative example · solve the gap to zero, then compare with a direct formula.
-
Commercial review · still required Illustrative example · the model does not predict demand or prove that £110 will sell.
The question behind the spreadsheet
“What price would reach the target?”
A training provider has a course ready to run but needs a repeatable way to discuss pricing. Repeatedly typing new prices into a workbook is slow and makes it easy to lose the original assumptions. This tutorial separates the inputs, the course result and the target, then uses Excel Goal Seek to connect them.
Use desktop Excel for the demonstrated workflow. Microsoft documents Goal Seek for current supported Windows and Mac desktop editions; it adjusts one input to reach a formula result. The detailed menu route below follows Windows. [1] No macros or add-ins are needed for this exercise.
Define the result honestly. Here, “course result” means revenue minus the variable and fixed course costs included in this model. It is not net profit or cash flow. The illustrative inputs do not calculate VAT, tax, financing, general overheads, refunds or payment timing. Use a consistent revenue/cost basis agreed with your finance lead before adapting the model.
Build the model
Give every input one job
Create a blank sheet named Pricing. Enter these labels in column A and values or formulas in column B at the stated rows. Leave unused rows blank.
| Cell | Label in column A | Entry in column B |
|---|---|---|
B3 |
Price per attendee | 95 |
B4 |
Paying attendees | 40 |
B5 |
Variable cost per attendee | 35 |
B6 |
Fixed course costs | 1800 |
B7 |
Target course result | 1200 |
B9 |
Revenue | =B3*B4 |
B10 |
Total variable cost | =B4*B5 |
B11 |
Course result | =B9-B10-B6 |
B12 |
Gap to target | =B11-B7 |
Enter numbers without currency symbols, then format the monetary cells as pounds with two decimal places. Keep B4 as a whole-number count. Label the input cells visibly; colour may reinforce the distinction, but should not be the only cue. Require B4 to be a positive whole number and the example’s price, costs and target to be non-negative numbers before solving.
Check the baseline
Illustrative example: revenue is £3,800, variable cost is £1,400, B11 is £600 and B12 is −£600. A negative gap means the result is below the target.
Keep the starting point
Save a baseline copy or duplicate the sheet before the run. Goal Seek will change the price input. Record the date and source of the costs so a later reviewer can reconstruct the decision.
Work backwards
Make the target gap equal zero
In desktop Excel, choose Data → What-If Analysis → Goal Seek. Configure the three boxes as follows, then run the calculation. The result cell must contain a formula linked to the changing input. [1]
Set cell: B12
This is the formula for the gap between the modelled course result and the target.
To value: 0
Type zero. The target amount stays in B7, so the model has one visible place to maintain it.
By changing cell: B3
Change only the price input. Do not select B7: that would move the target instead of finding the required price.
For the illustrative inputs, B3 should be approximately £110, B11 approximately £1,200 and B12 approximately zero. Inspect these cells before accepting the result. If the calculation fails or produces an implausible value, stop and inspect the formulas and assumptions; do not relabel the outcome as approved.
A formula dependency matters: B12 refers to B11, which refers to revenue in B9, which refers to B3. Replacing any link with a typed result can break the model. Keep B3 as an input, not a formula cell.
Independent verification
Do the algebra once
This model is linear, so a direct formula is actually the simplest production solution. Goal Seek demonstrates working back through a model; the algebra gives you a useful independent check.
The relationship is course result = attendees × (price − variable cost per attendee) − fixed costs. Rearranging gives the price needed for the target.
=B5+(B6+B7)/B4Put the formula in B14 and label A14 “Required price — direct check”. Illustrative example: 35 + (1800 + 1200) / 40 = 110. Compare B14 with the Goal Seek price. Check the unrounded residual in B12; for this exercise, require =ABS(B12)<0.01 to return TRUE. This is a teaching tolerance, not a universal accounting policy.
Do not use the division formula when attendance is zero or invalid. With zero attendees and positive fixed costs and target, no finite ticket price can meet the target. Keep errors visible until the input is corrected rather than hiding the problem with a zero price.
Use a real price
Rounding is part of the test
Add the following cells, one formula per cell. For the positive prices in this exercise, ROUNDUP with two digits rounds the required amount upwards to pennies; Microsoft defines ROUNDUP as rounding away from zero. [2]
B15 · proposed penny price
=ROUNDUP(B14,2)Label A15 “Proposed price — rounded up”. This is a candidate for review, not an instruction to quote it automatically.
B16 · result at that price
=B4*(B15-B5)-B6Label A16 “Result at proposed price”. Confirm it meets B7 using the actual rounded amount.
Illustrative rounding test: temporarily change B4 to 37. B14 becomes approximately £116.081081; B15 becomes £116.09 and B16 becomes £1,200.33. Charging £116.08 would produce £1,199.96. A two-decimal display alone is not a price decision. Restore B4 to 40, then rerun Goal Seek because changing another assumption does not make its earlier price a fresh solution.
For comparison, put =B5+B6/B4 in B17 and label A17 “Break-even price — modelled costs only”. Illustrative example: £80 at 40 attendees covers the included costs but does not deliver the £1,200 target. Do not confuse break-even with the target price.
Stress the assumption
Hold the price still; reduce attendance
The calculation assumed 40 paying attendees at £110. It did not estimate how many people would accept that price.
After restoring the baseline assumptions, enter “Attendance” in D3 and “Course result at proposed price” in E3. Enter 30, 35 and 40 in D4:D6. Put this ordinary worksheet formula in E4 and fill down to E6. It is not an Excel What-If Data Table.
=D4*($B$15-$B$5)-$B$6| Paying attendees | Course result | Gap to £1,200 target |
|---|---|---|
| 30 | £450 | −£750 |
| 35 | £825 | −£375 |
| 40 | £1,200 | £0 |
The absolute references keep the proposed price and costs fixed while each row substitutes its own attendance. This tests volume, not demand elasticity. If the course needs a larger room, extra trainer or non-refundable minimum catering charge, the cost relationship changes: rebuild that part of the model before relying on it.
Choose the right tool: use a direct formula for a transparent linear relationship like this one; Goal Seek for one unknown input in a connected model; Data Tables to compare one or two changing inputs; and assess Solver when multiple adjustable inputs or explicit constraints are required. [3] A more advanced tool cannot repair unsupported assumptions.
Best practice · failure modes
Do not let a neat answer hide a weak model
The wrong changing cell
If B7 changes, you have negotiated with the target rather than the price. Compare input values with the baseline and confirm that only B3 changed during the solve.
Incomplete costs
Missing preparation time, discounts, booking fees or a cost step can make the answer too low. Have the cost owner confirm what is included and what remains outside the model.
Unsupported sales volume
Attendance held constant is a modelling condition, not a forecast. Check bookings, capacity and relevant market evidence before accepting the price; record the response if the target cannot be supported.
Interactive handover check
Separate model evidence from decision evidence
Tick only checks you have completed. The assessment stays in this page and transmits no answers. A full score means ready for review, not approved pricing.
Ownership, adoption and impact
Turn a calculation into a controlled conversation
The model builder owns formula correctness and the saved baseline. The course lead confirms attendance, capacity and delivery assumptions. The finance lead reviews the cost basis and exclusions. The authorised commercial approver decides whether to change the price, redesign the course or accept a different target. The workbook should not make that decision automatically.
Keep a short decision note with the version, input sources, solved price, actual proposed price, sensitivity results, reviewer and review date. Clearly distinguish editable inputs from calculations. Demonstrate the model to the person who will reuse it, including how to restore the baseline and when to rerun the solve. Do not overwrite source bookings or publish a price list from a training exercise.
Measure the time required to prepare a pricing review, the number of corrections caught before approval and the difference between assumed and actual course outcomes. Separate forecasting errors from formula errors. Faster review and clearer assumptions are credible improvement goals; the example does not establish a revenue uplift or guaranteed margin.
Frequently asked questions
Excel Goal Seek FAQs
Can Goal Seek change price and attendance together?
No. Goal Seek changes one input. Keep attendance fixed for this exercise. If several inputs or explicit constraints must be solved together, assess Solver instead; a feasible model still needs business review.
Does a successful Goal Seek result prove the price is commercially viable?
No. It only addresses the modelled relationship. Check the residual, cost completeness, achievable attendance, customer demand and approval limits before using the result.
Why check the rounded price separately?
A price displayed to two decimals may still contain additional decimal places. Recalculate using the actual price you intend to charge; rounding down can leave the model below its target.
Is the course result the same as net profit or cash flow?
No. Here it is revenue less the variable and fixed course costs included in the model. Unmodelled overheads, taxes, financing, payment timing, refunds and other business effects are outside this simplified result.
Sources and scope
Verified tools; illustrative business assumptions
Microsoft documentation checked on 19 October 2026. All amounts, counts, charts and results in the course example are illustrative, not customer evidence. The pricing controls and teaching tolerance are Smart Statistics recommendations. Adapt the model with appropriate finance and commercial review; this is a software tutorial, not tax or investment advice.
- [1] Microsoft: use Goal Seek to adjust one input — supported editions and configuration.
- [2] Microsoft: ROUNDUP function — rounding direction and decimal places.
- [3] Microsoft: introduction to What-If Analysis — Goal Seek, Data Tables, scenarios and Solver.