How do I compare a lump sum now versus a larger amount later?

Grow the lump sum forward to the date of the later offer at a realistic rate, then compare. $100,000 today at 6% becomes $133,822.56 in 5 years, which is less than a $150,000 later offer, so the later offer wins unless you can earn more than the 8.45% break-even rate.

What is the break-even rate when comparing offers?

The break-even rate is the return at which both offers are worth the same. For $100,000 now versus $150,000 in 5 years, it is (150,000 / 100,000)^(1/5) - 1 = 8.447%. If you can reliably earn more than that, take the cash now; if not, take the larger later amount.

How do I compare a lump sum to a stream of payments?

Calculate the future value of each at the same date and rate. Use FV = PV x (1 + r)^n for the lump sum and FV = PMT x [((1 + r)^n - 1) / r] for the payments. At 6%, $50,000 today grows to $160,356.77 while $5,000 per year for 20 years grows to $183,927.96.

How do I compare offers in Excel?

Use =FV(rate, nper, pmt, pv) for both. A lump sum is =FV(0.06, 20, 0, -50000) = $160,356.77, and a payment stream is =FV(0.06, 20, -5000) = $183,927.96. Place them in adjacent cells with the same rate and the larger output is the better offer.

Should I take a signing bonus upfront or spread over years?

Compare their future values at the same date. A $20,000 bonus today at 6% grows to $26,764.51 in 5 years, while $5,000 per year for 5 years grows to $28,185.46, so the spread payout wins on math. But factor in the risk of leaving early, since unpaid future installments are worth nothing.

Is a lump sum always better than payments over time?

No. A lump sum compounds from day one, but a payment stream can deliver more total cash. Whether it wins depends on the amounts, the rate, and the time horizon. Always run both through the future value formula rather than assuming the lump sum is best.

What rate should I use to compare offers?

Use the return you could realistically earn on the money, called the opportunity cost or discount rate. Conservative investors often use 4% to 5%, while those comfortable in the market use 6% to 8%. A higher assumed rate makes taking cash now look more attractive.

What does the future value formula leave out?

It ignores risk, taxes, and inflation. A guaranteed amount today can beat a larger uncertain future amount, lump sums can trigger a higher tax bracket in one year, and future dollars buy less due to inflation. Use the math as a baseline, then apply judgment.

Home › Guides › Using Future Value to Compare Lump-Sum Offers

Using Future Value to Compare Lump-Sum Offers

By Muhammad Zohaib Ameer · June 3, 2026 · Savings & Investing · 7 min read

To compare two lump-sum offers fairly, grow each one to the same future date at the same realistic interest rate, then pick the larger result. A common trap is comparing $50,000 today with $60,000 in three years as if the dollars are equal. They are not, because the $50,000 can be invested now. Grow it at 6% for 3 years and it becomes $59,540, almost matching the later offer, so the decision is far closer than it looks at first glance.

This guide shows how to put any pair of money offers on a level playing field using future value. You will compare cash-now versus more-later deals, weigh a single lump sum against a stream of payments (an annuity), and handle real choices like a signing bonus paid upfront versus spread over years. The math is the same FV = PV x (1 + r)ⁿ engine behind our future value calculator; here you apply it to make decisions, not just projections.

Why you cannot compare offers at face value

Money has a time value: a dollar today is worth more than a dollar in the future because today's dollar can be invested and earn a return. So whenever two offers arrive at different times, comparing the raw dollar amounts is meaningless. You must move them to a common point in time first.

The cleanest method is to grow every offer forward to the same future date using a realistic rate, then compare the future values. (You could also discount everything back to today with present value; both approaches give the same winner.) The rate you choose is the return you could reasonably earn on the money, often called the discount rate or opportunity cost. For a conservative investor that might be 4% to 5%; for someone comfortable in the market, 6% to 8% is common.

Cash now vs more money later

Consider a settlement or buyout where you can take $100,000 today or $150,000 in 5 years. To compare them, grow the $100,000 forward 5 years at your expected return and see which ends up larger.

Assumed return	$100,000 grown 5 yrs	Better choice
4%	$121,665.29	$150,000 later
6%	$133,822.56	$150,000 later
8%	$146,932.81	$150,000 later (barely)

The $150,000-later offer wins at every rate below the break-even point. To find that tipping point, solve for the rate that grows $100,000 into $150,000 in 5 years: (150,000 / 100,000)^(1/5) - 1 = 8.447%. In plain terms, you would need to earn more than 8.45% per year to make taking the cash today the smarter move. Since that is an ambitious sustained return, the delayed $150,000 is usually the better deal here. Our CAGR calculator computes that break-even rate for you in seconds.

Lump sum vs a stream of payments (annuity)

Many real offers pit a single lump sum against a series of equal payments over time, which finance calls an annuity. Think pension buyouts, lottery cash-versus-annuity options, or structured settlements. To compare them, calculate the future value of each at the same horizon and rate.

The future value of an ordinary annuity (payments at the end of each period) is:

FV = PMT x [ ((1 + r)ⁿ - 1) / r ]

Suppose you can take $50,000 as a lump sum today or $5,000 at the end of each year for 20 years, and you expect a 6% return. Grow both to year 20:

Offer	Calculation	Future value at year 20
$50,000 lump sum today	50,000 x 1.06²⁰	$160,356.77
$5,000 per year for 20 yrs	5,000 x [(1.06²⁰ - 1) / 0.06]	$183,927.96

Here the payment stream wins by about $23,571 because you receive $100,000 in total payments versus a $50,000 lump sum, and even though the lump sum compounds from day one, it cannot overcome twice the total cash. Change the numbers and the answer flips: a $90,000 lump sum today at 6% grows to $288,642 by year 20, beating the same $5,000 stream. The point is to run the math, not to assume the lump sum is always king.

If payments arrive at the beginning of each period (an annuity due), each one compounds one extra period, so multiply the result by (1 + r). The $5,000 stream above would then be worth $183,927.96 x 1.06 = $194,963.63.

Comparing offers in Excel with =FV()

Excel makes side-by-side comparison fast. The =FV(rate, nper, pmt, pv) function handles both a lump sum and an annuity in one formula:

Lump sum: =FV(0.06, 20, 0, -50000) returns $160,356.77. Set pmt to 0 and enter the lump sum as a negative pv.
Payment stream: =FV(0.06, 20, -5000) returns $183,927.96. Enter the recurring payment as a negative pmt and leave pv blank.
Annuity due: add a 1 for the type argument, =FV(0.06, 20, -5000, 0, 1), to shift payments to the start of each period.

Put both formulas in adjacent cells, point them at the same rate, and the larger output is the better offer at that assumed return. Drag the rate across a row of cells to see how the winner changes as your expected return shifts.

A real-world example: signing bonus vs spread payout

Job and contract offers often include this exact choice. Imagine an employer offers a $20,000 signing bonus today or $5,000 per year for 5 years. At a 6% expected return, grow both to year 5.

Offer	Future value at year 5 (6%)
$20,000 upfront	$26,764.51
$5,000 per year for 5 yrs	$28,185.46

The spread payout wins by about $1,421 here, because the $25,000 in total payments outweighs the $20,000 upfront even after the lump sum's head start in compounding. But this assumes you stay employed all five years and the payments are guaranteed. If there is a real risk of leaving early or the company not paying, the certain $20,000 today may be worth more than the math suggests. Always weigh risk alongside the numbers. To check how a raise or bonus changes your take-home pay, use our take-home pay calculator and pay raise calculator.

Three factors the formula does not capture

Risk and certainty. A guaranteed amount today can beat a larger future amount that depends on a company staying solvent or you staying employed. Discount uncertain future offers more heavily.
Taxes. Lump sums can push you into a higher bracket in a single year, while spread payments may be taxed more gently. Compare after-tax amounts when the gap is close.
Inflation. Future dollars buy less. If the comparison is tight in nominal terms, run the figures through our inflation calculator to see the real difference.

Step-by-step: how to compare any two offers

Whenever you face cash-now versus more-later, work through this checklist. It turns a gut decision into a numbers decision.

Pick a common future date. Usually the date of the latest payment in either offer.
Choose a realistic rate. Use the return you could actually earn on the money, often 4% to 8%.
Grow each offer to that date. Use FV = PV x (1 + r)ⁿ for lump sums and the annuity formula for payment streams.
Compare the future values. The larger number is the better offer at that rate.
Find the break-even rate. The rate where both offers tie tells you how confident you must be in your returns.
Adjust for risk, taxes, and inflation. Let the math set the baseline, then apply judgment.

Putting it all together

Comparing lump-sum offers is not about which number looks bigger on paper; it is about which number is bigger once both are moved to the same point in time. Grow every offer forward at a realistic rate, use the annuity formula for payment streams, and find the break-even rate so you know exactly how aggressive your assumptions are. Then layer in risk, taxes, and inflation before you sign.

For the foundations of the time value of money behind these comparisons, see the U.S. Securities and Exchange Commission's Investor.gov compound interest resource, and our explainer on how compound interest works. When you are ready to run your own offers, open the free future value calculator, grow each option to the same date, and let the bigger future value make the call. For working backward from a future amount to today's value, pair it with the present value calculator.

Try it yourself

Run your own numbers in the free Future Value Calculator — instant, private, no sign-up.

Open the Future Value Calculator →

Frequently asked questions

How do I compare a lump sum now versus a larger amount later?: Grow the lump sum forward to the date of the later offer at a realistic rate, then compare. $100,000 today at 6% becomes $133,822.56 in 5 years, which is less than a $150,000 later offer, so the later offer wins unless you can earn more than the 8.45% break-even rate.
What is the break-even rate when comparing offers?: The break-even rate is the return at which both offers are worth the same. For $100,000 now versus $150,000 in 5 years, it is (150,000 / 100,000)^(1/5) - 1 = 8.447%. If you can reliably earn more than that, take the cash now; if not, take the larger later amount.
How do I compare a lump sum to a stream of payments?: Calculate the future value of each at the same date and rate. Use FV = PV x (1 + r)^n for the lump sum and FV = PMT x [((1 + r)^n - 1) / r] for the payments. At 6%, $50,000 today grows to $160,356.77 while $5,000 per year for 20 years grows to $183,927.96.
How do I compare offers in Excel?: Use =FV(rate, nper, pmt, pv) for both. A lump sum is =FV(0.06, 20, 0, -50000) = $160,356.77, and a payment stream is =FV(0.06, 20, -5000) = $183,927.96. Place them in adjacent cells with the same rate and the larger output is the better offer.
Should I take a signing bonus upfront or spread over years?: Compare their future values at the same date. A $20,000 bonus today at 6% grows to $26,764.51 in 5 years, while $5,000 per year for 5 years grows to $28,185.46, so the spread payout wins on math. But factor in the risk of leaving early, since unpaid future installments are worth nothing.
Is a lump sum always better than payments over time?: No. A lump sum compounds from day one, but a payment stream can deliver more total cash. Whether it wins depends on the amounts, the rate, and the time horizon. Always run both through the future value formula rather than assuming the lump sum is best.
What rate should I use to compare offers?: Use the return you could realistically earn on the money, called the opportunity cost or discount rate. Conservative investors often use 4% to 5%, while those comfortable in the market use 6% to 8%. A higher assumed rate makes taking cash now look more attractive.
What does the future value formula leave out?: It ignores risk, taxes, and inflation. A guaranteed amount today can beat a larger uncertain future amount, lump sums can trigger a higher tax bracket in one year, and future dollars buy less due to inflation. Use the math as a baseline, then apply judgment.

Muhammad Zohaib AmeerFounder & Personal Finance Researcher

Muhammad Zohaib Ameer is the founder of The Money Calcs. He personally builds, tests and researches every calculator and guide on the site — translating the standard financial formulas used by banks and lenders into free, plain-English tools. His focus is accuracy and clarity: helping everyday people understand mortgages, loans, savings, investing, retirement and debt without jargon, sign-ups or sales pitches.