Spreadsheets

Goal Seek: how much to cut spending to hit a savings target

Use Goal Seek in Excel to find how much to cut a grocery or dining budget to hit a monthly savings target, with the exact steps and its one-answer limit.

Editorial illustration for Goal Seek: how much to cut spending to hit a savings target

Goal Seek works backwards: you tell Excel the savings figure you want, name the one budget cell it may change, and it finds the value that makes the formula land on the target. In Excel choose Data, What-If Analysis, Goal Seek, then fill in Set cell, To value and By changing cell. It changes one cell only and gives one answer.

What does the sheet look like?

Use a small budget with invented figures, in rupees:

CellMeaningValue
B2Monthly income80,000
B3Rent20,000
B4Groceries (the cell Goal Seek may change)12,000
B5Everything else28,000
B6Savings, =B2-B3-B4-B520,000

You want savings of ₹25,000. The question is how low groceries would have to go.

How do I run Goal Seek?

  1. Choose Data, What-If Analysis, Goal Seek.
  2. In Set cell, enter B6. This must be a cell that holds a formula.
  3. In To value, type 25000.
  4. In By changing cell, enter B4. This must hold a typed number, not a formula.
  5. Click OK. Excel shows a message that it found a solution. Click OK again to keep it, or Cancel to return to the old value.

Excel changes B4 to 7,000 and B6 becomes 25,000. Check by hand: 80,000 minus 20,000 minus 7,000 minus 28,000 is 25,000. The groceries line would have to fall by ₹5,000, from 12,000 to 7,000, which is a cut of about 42 percent. Seeing that number is the point: it tells you whether the target is realistic or whether you need a different lever.

Can I try dining out or another line instead?

Yes. Goal Seek can change any one typed number the formula depends on. Change the By changing cell to your eating-out line, or to income, to answer a different question: what income would let me save ₹25,000 if groceries stay at ₹12,000? Run it again with a different cell and compare.

What are the limits of Goal Seek?

  • One changing cell at a time. If you want to trim groceries and dining together, run it twice or work out the split yourself.
  • One answer. It will not tell you the range of workable solutions.
  • It does not understand common sense. A target of ₹40,000 with the figures above would push groceries to minus ₹8,000, because even zero groceries leaves only ₹32,000 of savings. Excel will happily report a negative figure.
  • It is not live. If you edit rent later, the answer in B4 does not adjust; run it again.
  • It overwrites the value in the changing cell, so keep a copy of the original.

Is there a way to get the answer without Goal Seek?

For a simple budget like this, yes. The cell you want is the income, minus the other lines, minus the target: =B2-B3-B5-25000 gives groceries of ₹7,000 directly. Goal Seek earns its place when the formula is long, with many steps between the input and the result, and rearranging it by hand would be painful.

What if Goal Seek stops without a solution?

  • Make sure the changing cell is a typed value and not a formula.
  • Start closer: type a rough guess in the changing cell first.
  • Check that the set cell really depends on the changing cell. Formulas, Trace Precedents will show the links.
  • Increase the number of iterations or reduce the maximum change under File, Options, Formulas if the model is complicated.

Next step

Keep a spare copy of the sheet before you run Goal Seek for the first time, so that an accidental OK never costs you the figures you started with.

Pick the line you would genuinely cut, run Goal Seek, then compare the answer with what you actually spent on that line in recent months. SpendixAI reports can show the monthly total for a category from imported statements, which makes that comparison quick.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports