Savings Goal Calculator (Free Spreadsheet)

“Someday” is where savings goals go to die. The fix is embarrassingly simple: convert the goal into a date. A down payment isn’t a dream once the spreadsheet says October 2028 — it’s an appointment, and appointments get kept.

This calculator needs four numbers — goal, what you’ve saved, monthly contribution, and your account’s APY — and answers with the two forms of the same truth: months to goal, and the calendar month you arrive. It computes the timeline both without interest and with it (real compound math via NPER, verified against an independent calculation; the worked example is in the file).

The example: a $30,000 down payment

Starting point: $6,500 saved, $850/month, parked in a high-yield account at 4.3% APY. The sheet reports: $23,500 still to save, 28 months ignoring interest — but 26 months with interest, arriving around October 2028.

Three things worth noticing:

Interest shaved two months off. At today’s high-yield rates, the account itself contributes about two months of the example’s timeline — roughly $1,700 of the goal arrives as interest rather than paycheck. That’s the argument for not saving toward a multi-year goal in a checking account, made in months instead of percentages.

Interest is the seasoning, not the meal. Two months off a 28-month timeline is real but modest. The contribution is what moves the date: bump the example to $1,000/month and the goal lands ~5 months sooner; chase an extra 0.5% APY and you save a week or two. Optimize the contribution first, the account second.

The arrival date does the motivating. “26 months” is abstract; “October 2028” lets you picture the season you get the keys. The date cell recomputes from today every time you open the file, so it’s always the live answer.

Making the number honest

Use your real monthly number, not your aspirational one. The calculator is only as truthful as the contribution you’ll actually make. If $850 requires a perfect month, enter $700 and let a budget find the rest properly.

Big goals deserve their own account. Mixing the down payment with everyday cash makes the balance ambiguous and raid-able. One goal, one account (or one named bucket), one row in this calculator — the same logic as sinking funds, just pointed at a bigger target.

Recompute when life changes. Raise, windfall, rate change — new inputs, new date. Watching the arrival month pull closer after a raise is a better use of five minutes than most financial content.

A caveat for honesty’s sake: APY isn’t guaranteed over multi-year horizons — rates drift, and the with-interest date drifts a little with them. The no-interest row is your conservative floor; the truth will land between the two. (General information, not financial advice.)

Using it in Google Sheets

1. Google Sheets → blank sheet → File → Import → Upload → select the file → Replace spreadsheet.
2. Only the five green cells are inputs. Duplicate the tab per goal — one for the emergency fund, one for the trip, one for the down payment — and you have a dashboard of arrival dates.

Frequently asked questions

Which APY do I enter? The rate your money actually earns where it actually sits. High-yield savings accounts publish it directly; for a checking account, enter 0% and read the no-interest row.

What about investing toward long goals? Market returns aren’t a fixed APY, so this calculator deliberately doesn’t pretend to model them. For goals under ~5 years, savings-account math (this sheet) is the standard conservative approach anyway.

Is it free? Free for personal and commercial use, no signup. Spot an error? Tell us — we re-verify and fix.