Savings Goal Calculator

Set a target and deadline and get the exact monthly amount to save, accounting for interest earned along the way.

How the Savings Goal Calculator works

A savings goal calculator solves for the recurring contribution required to grow a starting balance into a target amount over a fixed time horizon, using a future-value-of-an-annuity equation under monthly compounding. In plain English, it answers the question "how much should I save each month to hit my goal?" by reversing the standard compound interest formula and solving for the unknown payment. The core equation our tool uses is the future-value formula with a present-value seed: FV = PV(1 + r)ⁿ + PMT × [((1 + r)ⁿ - 1) / r] Where:

• FV = the savings goal (target dollar amount)
• PV = present value (your starting balance today)
• r = periodic interest rate (annual APY divided by 12 for monthly compounding)
• n = number of compounding periods (years multiplied by 12)
• PMT = the monthly contribution we solve for

To isolate PMT, the calculator rearranges the equation algebraically: PMT = (FV - PV(1 + r)ⁿ) × r / ((1 + r)ⁿ - 1). This is identical to the math a financial calculator performs when you press the PMT key, and it matches the function used by most online savings goals calculator tools. Step-by-step, here is what happens when you click calculate:

1. The annual APY you enter is converted to a periodic rate (r = APY / 12).
2. Your time horizon in years is converted to monthly periods (n = years × 12).
3. The starting balance is grown forward to the end date using compound interest, giving its future value.
4. That future value is subtracted from the goal, leaving the gap your contributions must fill.
5. The gap is divided by the annuity factor ((1 + r)ⁿ - 1) / r to produce the required monthly deposit.

Edge cases the calculator handles: If the APY is 0%, the formula collapses to (FV - PV) / n, a simple straight-line split. If your starting balance already exceeds the future value of your goal at the chosen rate, the calculator returns $0, meaning no additional contributions are needed. If the time horizon is less than one full month, the tool rounds up to a single period to avoid division errors. This same engine powers our weekly and biweekly variants. To use it as a weekly savings goal calculator, set r = APY / 52 and n = weeks. For biweekly, use r = APY / 26. The compound interest savings goal calculator logic remains identical, only the compounding cadence changes, which is why biweekly savers finish slightly ahead of monthly savers at the same annual rate.

Example calculation

Three worked scenarios show how the savings goal calculator behaves across short-term, mid-term, and retirement horizons. Each uses real APY assumptions current as of 2026 (4.5% high-yield savings, 7% long-run S&P 500 average) and the formula PMT = (FV - PV(1 + r)ⁿ) × r / ((1 + r)ⁿ - 1). Scenario 1: Short-term savings goal calculator, $15,000 down payment in 3 years. Sarah has $2,500 saved and wants $15,000 for a house down payment in 36 months. Her online high-yield account pays 4.5% APY. Plugging in: r = 0.045 / 12 = 0.00375, n = 36, FV = $15,000, PV = $2,500. Her starting balance grows to $2,500 × (1.00375)³⁶ = $2,861. The gap is $12,139. The annuity factor is ((1.00375)³⁶ - 1) / 0.00375 = 38.526. Sarah needs to save $12,139 / 38.526 = about $315 per month. On a biweekly schedule that is roughly $145 per paycheck. Scenario 2: Mid-term savings goals calculator, $40,000 wedding in 5 years. Marcus and his partner have $5,000 saved and target $40,000. Using a brokerage money market fund at 5.0% APY: r = 0.004167, n = 60. The $5,000 grows to $6,417 at the end. The gap is $33,583. The annuity factor is 68.006, so they need $494 per month, or $228 per biweekly paycheck. If they instead invested in a balanced fund averaging 7%, the required monthly contribution drops to $467, saving them $1,620 in deposits over five years. Scenario 3: Calculate retirement savings goals, $1,000,000 in 25 years. Priya is 40 with $50,000 in her 401(k) and wants $1 million by 65. Using a 7% expected return: r = 0.005833, n = 300. Her $50,000 grows to $285,409. The gap is $714,591. The annuity factor is 811.66, so she needs $881 per month. That fits comfortably under the 2026 401(k) contribution limit of $23,500.

Scenario	Goal	Starting	APY	Years	Required Monthly	Total Contributed	Interest Earned
House down payment	$15,000	$2,500	4.5%	3	$315	$11,340	$1,160
Wedding fund	$40,000	$5,000	5.0%	5	$494	$29,640	$5,360
Retirement nest egg	$1,000,000	$50,000	7.0%	25	$881	$264,300	$685,700

Notice how compound interest does increasingly heavy lifting as the timeline lengthens. In Scenario 1, interest covers 7% of the goal; in Scenario 3, it covers 69%.

Tips for using the Savings Goal Calculator

• Front-load contributions in the first quarter when possible. Putting $2,000 in January earns 11 months of compounding versus $167 spread monthly, which can shave six to eight weeks off your timeline for a one-year savings goal at 4.5% APY.
• Match your contribution cadence to your paycheck. If you are paid biweekly, use a biweekly savings goal calculator setting (26 deposits per year) rather than 24 semimonthly deposits, since the two extra payments accelerate compounding by roughly 8.3% annually.
• Re-run the calculator every six months. APY on high-yield accounts shifts with Fed policy, and a 50 basis point change on a $20,000 goal can move your required monthly deposit by $15 to $25.
• Separate goals into named sub-accounts. Banks like Ally and SoFi let you create up to 30 buckets, each with its own savings goal calculator target, which prevents emergency-fund money from getting tapped for vacation spending.
• Set a stretch goal and a floor goal. Calculate the monthly amount for a 3-year timeline (stretch) and a 4-year timeline (floor), then automate the floor and treat windfalls as bonus contributions toward the stretch.
• Use a Roth IRA as a dual-purpose short-term savings goal calculator target. Contributions (not earnings) can be withdrawn tax and penalty free, so a $7,000 annual contribution doubles as both a retirement deposit and a backup emergency fund.
• Index your monthly contribution to inflation. If your initial calculation says $400 per month for a 10-year goal, increase by 3% annually so your real purchasing power keeps pace, ending around $522 per month in year 10.
• Treat the calculator output as a minimum, not a target. If the saving for a goal calculator says $315 per month, set the automated transfer to $325. The $10 buffer absorbs months you forget to skip a discretionary purchase.
• For variable income, calculate two scenarios. Run the savings goals calculator using your lowest reliable monthly income for the base contribution, then sweep 50% of every dollar above that floor into the goal account on the 15th of each month.

The math behind a savings goal calculator

A savings goal calculator is a rearranged future-value-of-an-annuity formula that solves for the unknown payment instead of the unknown future value. The complete equation is PMT = (FV - PV(1 + r)ⁿ) × r / ((1 + r)ⁿ - 1), where every dollar you deposit earns interest from the day it arrives until the goal date.

The annuity factor, ((1 + r)ⁿ - 1) / r, represents how many dollars of future value each $1 of recurring contribution will produce. At 4.5% APY over 60 months, that factor is 67.14, meaning every $1 you contribute monthly grows into $67.14 by month 60. Flip the relationship and you can quickly estimate: for a $20,000 goal in 5 years, you need roughly $20,000 / 67.14 = $298 per month before accounting for any starting balance.

This is the same engine inside a compound interest savings goal calculator, a monthly savings goal calculator, and a weekly savings goal calculator. Only the periodic rate and period count change. Annual compounding uses r = APY and n = years; daily compounding uses r = APY / 365 and n = days. The difference between daily and monthly compounding at 5% APY over 10 years is about 0.14% of the final balance, which is why most calculators default to monthly.

Origin and evolution of savings goal math

The annuity formula that powers every savings goals calculator was first published by Flemish mathematician Simon Stevin in 1582 in his book Tafelen van Interest, the earliest known compound interest tables. Stevin built the tables for Antwerp merchants who needed to price bills of exchange, and the math has not changed in 444 years.

The first consumer-facing how to calculate savings goal tool was the HP-12C financial calculator, released in 1981, which embedded the time-value-of-money keys (N, I/YR, PV, PMT, FV) that every modern app still mirrors. Before that, savers used printed annuity tables or slide rules.

The shift to web-based savings calculator goal tools began in the late 1990s with Bankrate and SmartMoney. The 2008 financial crisis triggered a surge in goal-based personal finance apps (Mint, You Need A Budget, Qapital) that wrapped the same Stevin formula in a friendlier interface. Today, every major US bank (Ally, Capital One 360, Marcus, Discover) offers a built-in saving goal calculator inside its mobile app, often pre-populated with the account's current APY.

Common misconceptions about savings goal calculators

The biggest misconception is that a savings goal calculator guarantees the result. It does not. The output is conditional on the APY holding constant, which almost never happens. The Federal Reserve raised rates 11 times between March 2022 and July 2023, then cut them in 2024 and 2025, swinging high-yield savings APYs from 0.5% to 5.5% and back to roughly 4.0% to 4.5% by mid-2026.

A second misconception is that compounding frequency matters more than rate. It does not. The effective annual yield difference between monthly and daily compounding at 4.5% nominal is about 0.01 percentage points. Picking a 4.6% APY with annual compounding beats a 4.5% APY with daily compounding every time.

A third confusion: people enter pre-tax APY and forget that interest on a regular savings account is taxed as ordinary income. If your marginal federal rate is 22% and your state rate is 5%, a 4.5% APY becomes 3.29% after tax. Always run the saving for a goal calculator with the after-tax rate, or stash the savings inside a Roth IRA or HSA where growth is tax-free.

How long to reach savings goal calculator: solving for time instead of payment

A how long to reach savings goal calculator solves the same equation for n (number of periods) instead of PMT. The rearranged formula is n = ln((FV × r + PMT) / (PV × r + PMT)) / ln(1 + r), where ln is the natural logarithm.

This variant answers a different question: given what you can actually afford to save each month, when will you hit your goal? Example: you can save $400 per month, have $3,000 banked, and want $25,000 at 4.5% APY. Plugging in: n = ln((25000 × 0.00375 + 400) / (3000 × 0.00375 + 400)) / ln(1.00375) = ln(493.75 / 411.25) / 0.003743 = 0.1825 / 0.003743 = 48.8 months, or just over 4 years.

Pair this with the standard savings calculator how long to reach goal logic to triangulate your plan. If the timeline answer is longer than you want, you have three levers: increase the monthly contribution, find a higher APY, or lower the goal amount. The calculator lets you see exactly how each lever moves the finish line.

Advanced use cases competitors miss

Most blog posts treat the savings goal calculator as a single-purpose down payment tool. It is far more flexible.

Sinking funds: Use the calculator to right-size 8 to 12 named buckets simultaneously (annual insurance, car registration, holiday gifts, vet bills, HOA assessments). Add the monthly contributions together to get one accurate "future-known expenses" line in your budget.

Roth IRA ladders: For early retirement, calculate how much to contribute each year to build a 5-year ladder of converted dollars you can access penalty-free at age 50. Run the calculator with a 20-year horizon and the Roth contribution limit ($7,000 in 2026) to see if you are on track.

Sabbatical funding: Reverse-engineer a 6-month or 12-month career break by treating your salary as the goal. If you net $5,500 per month and want a year off in 4 years, run the calculator with FV = $66,000.

Self-insured deductibles: If you carry a $7,500 HSA-qualified high-deductible health plan, calculate the monthly HSA contribution that fills the deductible bucket in 24 months while still capturing the tax deduction.

Mistakes that derail savings goal plans

The most expensive savings goal mistake is anchoring the timeline to a calendar date instead of a paycheck count. Goals tied to "December 2027" feel abstract; goals tied to "my next 36 biweekly paychecks" trigger action. Always convert the time horizon into pay periods when you set up the automation.

The second mistake is parking the money in a brick-and-mortar bank's standard savings account paying 0.01% APY. The national average savings yield is roughly 0.45% as of 2026, while the top online high-yield accounts pay 4.0% to 4.5%. On a $20,000 goal over 4 years, that gap is over $1,800 in lost interest.

The third mistake is forgetting to increase contributions when you get a raise. If you got a 4% raise and your previous required monthly was $400, bumping it to $416 (the same 4%) keeps your savings rate constant and prevents lifestyle creep.

The fourth mistake is ignoring inflation. A $50,000 goal set in 2026 will have the purchasing power of about $43,100 by 2031 at 3% inflation. Either inflate the goal annually or convert your target to real (inflation-adjusted) dollars using our inflation calculator before running the savings math.

Savings goal calculator versus alternative planning tools

A savings goal calculator answers a narrower question than a full retirement or budgeting tool, which is exactly why it is more accurate for short and mid-term goals. Here is when to use it and when to switch tools.

Use a savings goal calculator when: the time horizon is 1 to 10 years, the target is a known dollar amount, you want to know the required monthly contribution, and you are saving in a single account or fund.

Use a retirement calculator instead when: the horizon is 15+ years, you need to model Social Security, you have multiple account types (401(k), IRA, taxable brokerage), or you want to test withdrawal sustainability with Monte Carlo simulation.

Use a future value calculator when: you already know your contribution amount and want to project the ending balance, instead of solving for the contribution.

Use a compound interest calculator when: you are evaluating a lump sum with no recurring deposits, such as a bonus you want to grow for 10 years.

The savings goal calculator sits at the intersection of these tools and is the right starting point for 80% of US household savings questions.

Monthly Savings Needed to Reach a Goal in 5 Years (at 4% APY)

This table shows the monthly contribution required to reach common savings goals in 5 years (60 months), starting from $0 at a 4% APY. Each figure uses the annuity formula PMT = goal x (r/12) / ((1+r/12)^60 - 1) with r = 0.04, so compound interest is already factored in. The gap between your goal and what you contribute is the interest the account earns for you.

Goal	Monthly needed	Total you contribute
$5,000	$75.42	$4,524.96
$10,000	$150.83	$9,049.91
$25,000	$377.08	$22,624.78
$50,000	$754.16	$45,249.57

To plug in your own goal, timeline, APY, or contribution cadence, use the Savings Goal Calculator, which runs these same formulas and shows exactly how much of your target comes from interest versus your own deposits.

Related on this site

compound interest calculator · general savings calculator · emergency fund calculator · retirement calculator · future value calculator · college savings calculator · millionaire calculator · how much to save per month guide · what is compound interest · savings calculators hub

For a related deep dive, see GreenCalcs solar payback calculator.

Savings Goal Calculator — frequently asked questions

Required amount too high?

Extend the timeline, add to the starting balance, or choose a higher-return account.

Is interest guaranteed?

Only for fixed-rate accounts; investment returns vary.

What if I can't save the required amount?

Lengthen the deadline, raise the starting balance, or accept a longer horizon.

How much should I save each month to reach my goal?

Divide your savings gap by the annuity factor for your timeline and interest rate. For a $20,000 goal in 4 years at 4.5% APY with $1,000 starting, the formula is ($20,000 - $1,000 × 1.196) / 52.39 = $370 per month. A faster rule of thumb: for a 5-year goal at 4 to 5% APY, divide the goal by 68 to get the rough monthly amount. For a 10-year goal at 7% return, divide by 173. Always automate the transfer the day after payday so the deposit happens before discretionary spending.

How do I calculate monthly savings goals manually?

Use the formula PMT = (FV - PV × (1 + r)ⁿ) × r / ((1 + r)ⁿ - 1), where FV is your goal, PV is your starting balance, r is your APY divided by 12, and n is months. Work it in four steps: grow the starting balance forward, subtract from the goal, calculate the annuity factor, then divide the gap by the factor. A scientific calculator handles it in under a minute, but a savings goal calculator monthly tool eliminates rounding errors that compound over long horizons.

What is a savings goal calculator with interest?

A savings goal calculator with interest is the standard version that includes compound interest in the math, as opposed to a simple straight-line calculator that just divides the goal by the number of months. Including interest matters more as time and rate increase: at 4.5% APY over 5 years, interest reduces required monthly deposits by about 12%; over 10 years, by 27%; over 25 years at 7%, by more than 60%. Always use the with-interest version unless you are storing cash at literally 0% return.

How do I use a savings goal calculator weekly instead of monthly?

Convert your APY to a weekly periodic rate (APY divided by 52) and set the number of periods to weeks instead of months. For a $10,000 goal in 2 years at 4.5% APY, r = 0.000865 and n = 104, producing a required weekly deposit of about $92. A weekly savings goal calculator suits hourly workers paid each Friday and people doing the 52-week challenge. Biweekly savers use r = APY / 26 and the same math, which works well with most US payroll schedules.

How long will it take to reach my savings goal?

Use the formula n = ln((FV × r + PMT) / (PV × r + PMT)) / ln(1 + r) to solve for months. Example: saving $300 per month from $2,000 toward $15,000 at 4.5% APY gives n = ln(56.25 + 300 / 7.5 + 300) / ln(1.00375) = about 41 months, or 3 years 5 months. A how long to reach savings goal calculator flips the standard equation, useful when your monthly contribution is fixed and you want to see the finish date instead of the deposit amount.

How do I calculate retirement savings goals?

Estimate your annual retirement spending, multiply by 25 (the 4% safe withdrawal rule), then use a savings goal calculator with a 7% expected return to solve for the monthly contribution. Example: $60,000 annual spending × 25 = $1.5 million target. At age 35 with $30,000 saved and 30 years until age 65, you need roughly $1,140 per month. Adjust upward if you expect Social Security to cover less than 25% of spending, and use Roth and traditional 401(k) accounts to optimize taxes.

What APY should I use in a savings goal calculator?

Use the after-tax APY of the account holding the money, not the headline rate. For a high-yield savings account at 4.5% APY held in a taxable brokerage with a 22% federal and 5% state marginal rate, the effective APY is 3.29%. For tax-advantaged accounts (Roth IRA, HSA, 529), use the full pretax expected return: 7% for diversified equity index funds, 4 to 5% for money market or CD ladders. Update the APY every six months as rates change.

How do I calculate a short-term savings goal?

For goals under 24 months, use a short term savings goal calculator with the APY of a high-yield savings account, money market fund, or short-duration CD ladder, never a stock index fund. Volatility risk on equities over 12 to 24 months is too high to time reliably. Plug in your goal, starting balance, months, and 4 to 5% APY. For an $8,000 vacation in 18 months from $500 saved, the required monthly deposit is about $402.

Can a savings goal calculator account for biweekly paychecks?

Yes. A savings goal calculator biweekly uses r = APY / 26 as the periodic rate and n = total biweekly periods. On a 5-year goal that means n = 130. The 26 deposits per year (versus 24 semimonthly) sneak in 2 extra payments annually, finishing roughly 4 to 5 weeks early at the same nominal rate. Most US workers paid every other Friday should use biweekly settings to match real cash flow, especially for sinking funds and down payment goals.

What is a compound interest savings goal calculator?

A compound interest savings goal calculator applies compounding to both your starting balance and every recurring deposit, using the formula FV = PV(1 + r)ⁿ + PMT × [((1 + r)ⁿ - 1) / r] solved for PMT. The first deposit compounds for n - 1 periods, the second for n - 2, and so on. This stair-step growth is why a $400 monthly contribution at 7% turns into $69,300 in 10 years instead of $48,000 with no interest, a 44% boost.

How do I split a savings goal into multiple buckets?

Run the savings goal calculator separately for each named goal and sum the monthly contributions, since each bucket can have a different timeline and APY. Example: emergency fund $20,000 in 24 months at 4.5% = $797 per month; vacation $5,000 in 12 months at 4.5% = $407 per month; car down payment $8,000 in 36 months at 4.5% = $208 per month. Total automation: $1,412 per month across three sub-accounts at any online bank.

How does inflation affect my savings goal calculation?

Inflation erodes the real purchasing power of a fixed-dollar goal, so a $50,000 target in 2026 will only buy what $43,100 buys today by 2031 at 3% inflation. Either inflate the goal by the expected inflation rate each year, or use real returns (nominal APY minus inflation) in the calculator. For a 10-year goal with 7% nominal returns and 3% inflation, run the math at 4% real return instead. Long-term goals especially require inflation adjustment to avoid underfunding.

Should I prioritize debt payoff or a savings goal?

Prioritize debt with an interest rate higher than your expected savings APY, then split contributions. If your credit card charges 22% APR and your savings yields 4.5%, every dollar to the card is worth nearly 5x more than the same dollar in savings. Keep a $1,000 starter emergency fund, attack high-interest debt aggressively, then run the savings goal calculator on the remainder. For mortgage debt at 6% versus 7% expected equity returns, the math is closer and personal preference matters.

How accurate is a savings goal calculator?

A savings goal calculator is mathematically exact for fixed-rate accounts (CDs, treasury bonds) and a close estimate for variable-rate accounts (high-yield savings, money market funds). For equity-based goals at a 7% assumed return, the calculator output should be treated as the midpoint of a wide range. Real outcomes can vary by 25 to 40% in either direction over 10-year periods. Rerun the calculator annually with updated balances and current rates to keep the plan calibrated.

What is the easiest way to calculate how much to save each month?

Subtract your starting balance from your goal, then divide by the number of months to your deadline. For $10,000 in 24 months from $1,000, you need $375 per month at 0% interest. If you are earning 4% to 5% APY, knock 5 to 10% off that number to account for interest. For a precise answer, use a saving for a goal calculator that handles compound interest automatically, especially when the time horizon exceeds 3 years or the goal exceeds $25,000.

How much do I need to save each month to reach $20,000 in 3 years?

To reach $20,000 in 3 years (36 months) at 5% APY, you need about $516.08 per month. The formula is PMT = goal x (r/12) / ((1+r/12)^36 - 1), with r = 0.05. With no interest you'd need $555.56/month ($20,000 / 36). Interest covers roughly $1,421 of the goal, lowering your required contribution.

How do I figure out monthly savings for a house down payment of $60,000 in 4 years?

For a $60,000 down payment in 4 years (48 months) at 4.5% APY, save about $1,143.21 per month. Use PMT = 60000 x (0.045/12) / ((1+0.045/12)^48 - 1). You'd contribute roughly $54,874 yourself, with interest covering the remaining ~$5,126. Keep the cash in a high-yield savings account or CD, not stocks, for a short 4-year horizon.

How long will it take to save $10,000 if I put away $300 a month at 4% APY?

Saving $300 a month at 4% APY, you'll reach $10,000 in about 31.7 months, roughly 2 years and 8 months. The formula solves for n: n = ln(1 + goal x r / PMT) / ln(1 + r), where r = 0.04/12. Without interest it would take 33.3 months ($10,000 / $300), so interest saves you about 2 months.

How much should I save weekly to reach $3,000 in one year?

To reach $3,000 in one year with weekly contributions and no interest, save $57.69 per week ($3,000 / 52 weeks). If your savings account earns interest, you'd need slightly less, but for a one-year goal the difference is only a few dollars. The Savings Goal Calculator lets you switch to a weekly cadence and adds any APY automatically.

How much do I need to save each biweekly paycheck to hit $5,000 in a year?

Save $192.31 per biweekly paycheck to reach $5,000 in a year, since there are 26 biweekly pay periods ($5,000 / 26). This matches most US payroll schedules. If your high-yield account earns 4% APY, you'd need a touch less because interest adds up across the year. Set the calculator to a biweekly cadence to see the exact, interest-adjusted figure.

How much should I save per day to reach $1,825 in a year?

To save $1,825 in one year with daily contributions and no interest, set aside $5.00 per day ($1,825 / 365). Daily micro-saving works well for round-up apps and spare-change habits. Any interest earned would slightly reduce the total you contribute. Daily cadence is useful for visualizing small, consistent goals like an emergency cushion or a holiday fund.

How much do I need to save yearly to reach $50,000 in 10 years at 5%?

Contributing once a year, you'd need about $3,975.23 annually to reach $50,000 in 10 years at 5% interest. The yearly-annuity formula is PMT = goal x r / ((1+r)^n - 1), with r = 0.05 and n = 10. You contribute roughly $39,752 yourself; compound interest covers the remaining ~$10,248. Annual contributions suit IRA or lump-sum bonus savers.

How do I calculate a savings goal with no interest?

With no interest, divide your goal by the number of contributions: monthly amount = goal / months. For example, $6,000 in 24 months is $250 per month ($6,000 / 24). This is the simplest savings math and is accurate for checking or zero-interest accounts. Set the APY to 0% in the Savings Goal Calculator to get the same straight-line result automatically.

How does compound interest change how much I have to save?

Compound interest reduces how much you contribute because your balance earns returns that also earn returns. For example, reaching $10,000 in 5 years at 4% APY needs only $150.83/month, so you contribute about $9,050 and interest adds the other ~$950. The formula PMT = goal x (r/12) / ((1+r/12)^n - 1) bakes this in. Higher APY or longer timelines magnify the effect.

How do I adjust my savings goal for inflation?

To keep buying power, inflate your goal by the expected inflation rate over your timeline: future cost = goal x (1 + inflation)^years. For a $50,000 goal in 10 years at 3% inflation, you'd actually need about $67,196 to buy the same things. Aim your contributions at the inflated number, and choose an APY that meets or beats inflation so real value isn't eroded.

How do I build a savings goal in Excel or Google Sheets?

In Excel or Google Sheets, use the PMT function: =PMT(rate/12, months, 0, -goal). For $10,000 in 60 months at 4% APY, enter =PMT(0.04/12, 60, 0, -10000), which returns about $150.83. The negative goal makes the result positive. To solve for time, use =NPER(rate/12, -payment, 0, goal). The Savings Goal Calculator runs these same formulas without a spreadsheet.

How do I calculate CAGR for my savings in Google Sheets?

CAGR (compound annual growth rate) measures your average yearly growth: CAGR = (ending / beginning)^(1/years) - 1. In Google Sheets, enter =(18000/10000)^(1/5)-1, which returns about 12.47% for growing $10,000 to $18,000 over 5 years. CAGR is for measuring past growth, while a savings goal calculator projects future contributions you need to reach a target amount.

Does this savings goal calculator work the same as Bankrate or NerdWallet?

Yes. The underlying math is identical across Bankrate, NerdWallet, Investor.gov, MoneySmart, and Ally because they all use the standard annuity formula PMT = goal x (r/12) / ((1+r/12)^n - 1). This free Savings Goal Calculator runs the exact same equation, so you'll get matching results. We don't pull live bank rates, so enter the APY your own account quotes for an accurate figure.

Can I use this to plan multiple savings goals or buckets at once?

Yes. Run the calculator once per goal, then add the monthly amounts to see your total commitment. For example, a $5,000 vacation in 8 months needs $500/month, and an $8,000 car in 18 months needs about $444.44/month, so together you'd budget roughly $944/month. The bucket method keeps each goal on its own timeline and APY instead of lumping savings together.

Should I pay off debt or save for my goal first?

Generally, pay off high-interest debt first, then save, because debt interest usually outruns savings returns. If a credit card charges 22% but your savings earns 4% APY, every dollar to debt beats a dollar saved. The exception is a starter emergency fund (about $1,000) and any employer 401(k) match, which you should grab first. After that, attack debt above ~7-8%, then fund your goal.

How do I calculate how much interest a 6-month CD at 4.5% APY earns?

A 6-month CD at 4.5% APY on $10,000 earns about $222.52, using interest = principal x ((1 + APY)^0.5 - 1) for half a year. Note APY already includes compounding, so you take the rate to the 0.5 power for 6 months. For a savings goal, add this interest to your contributions; enter 4.5% as the APY in the calculator to project a CD-funded target.

Guides & articles

• How much to save per month to reach your goal: formula, examples, and shortcut
• How Long Will It Take to Reach My Savings Goal?
• What Is a Sinking Fund and How to Use One (With Categories + Examples)

Related calculators

Compound Interest Calculator · Simple Interest Calculator · Savings Calculator · CD Calculator · APY Calculator · Investment Calculator