Dollar-Cost Averaging a Lump Sum: The Spreadsheet Answer

The wire hits your account on a Tuesday. Maybe it’s an inheritance, a bonus, a home sale, a 401(k) rollover. And now you’re facing the question every spreadsheet eventually answers the same way but every human answers with dread: invest it all at once, or dribble it in over twelve months?

Short version: the spreadsheet says lump sum, the nervous system says dollar-cost averaging, and both answers are defensible because they’re answering different questions. Let me show you the math that decides it, and then the reason I still use DCA anyway in some situations.

The Math: What DCA Actually Is

Dollar-cost averaging a lump sum means holding part of it in cash and investing it on a schedule — say, $10,000 a month for twelve months. That schedule has a hidden cost: the un-invested portion sits out of the market while it waits. If markets rise during your waiting period, you bought shares at higher and higher prices. That’s the entire cost of DCA, and it’s why, historically, lump sum wins most of the time.

In Vanguard’s frequently-cited study of US rolling historical periods, lump-sum investing beat 12-month DCA roughly two-thirds of the time. The reason is dull: markets go up more often than they go down, so the cash waiting on the sideline usually costs more than the perfect timing DCA occasionally buys you.

A Worked Example You Can Verify

Take $120,000. Plan A: invest it all today. Plan B: invest $10,000 at the start of each month for a year, holding the rest in cash. Compare both across three kinds of years (numbers rounded for readability; every line follows from basic compounding at ±1% per month):

Kind of year	Lump sum (all in day one)	DCA ($10k/month)	Winner
Up ~12.7% (steady +1%/mo)	~$135,200	~$128,100	Lump by ~$7,100
Flat (0%)	$120,000	$120,000	Tie
Down ~11.4% (steady −1%/mo)	~$106,400	~$112,500	DCA by ~$6,100

Notice the symmetry: DCA’s edge in a bad year is about the same size as its cost in a good year. DCA doesn’t create an advantage; it trades upside in good markets for protection in bad ones. It’s insurance, and like all insurance it usually expires unused. Whether you should buy the insurance depends on one thing: what happens to you if the bad year arrives right after you invest everything at once.

The Regret Asymmetry Nobody Prices

Here’s the part the pure-math camp underweights. Suppose you invest $120,000 in one shot in February, and by April the market is down 20%. Your account shows $96,000. Nothing about your plan has changed if your timeline is twenty years — I’ve walked through why an early crash barely dents a long horizon in my 40%-crash math post. But now the human part: would you still be holding? Would you be able to sleep? Would you make a panicked sale at the bottom that turns a temporary drawdown into a permanent loss?

That question — not the expected return — is the real decision variable. A plan you abandon at the first 15% drawdown has an expected return of whatever you get selling low. If investing the whole lump at once means there’s a one-in-three chance you’ll be a wreck for twelve months, the “optimal” plan is worse than the suboptimal one you’ll actually stick to.

I’ve written my honest take on this in dollar-cost averaging as a behavior tool, not a math edge — the conclusion there stands: DCA is a way to make a scary purchase survivable, and it’s worth paying the small expected cost when the alternative is paralysis.

Why Paralysis Is the Real Enemy

The least-discussed option in this debate is the one where nothing happens. People with a lump sum in a checking account routinely wait months “for a better time,” and the cost of that waiting dwarfs the lump-vs-DCA question entirely. While deciding between a plan worth ~$135,000 and a plan worth ~$128,000 in a good year, the money is earning checking-account rates in both scenarios. Not investing is the only truly bad plan on the board.

If DCA is what gets the money from “sitting” to “invested,” DCA wins by forfeit, whatever the spreadsheets say. An 80% solution executed this week beats a 100% solution executed never.

The Hybrid Rule I Use

My own framework when a lump sum lands (educational framing, not advice):

1. If it’s money for retirement decades away, and I know I won’t flinch: invest the lump. Take the two-thirds odds.
2. If the amount is large relative to my annual income, or the money is emotionally loaded (inheritance, severance): DCA over 3–6 months. Not because it’s mathematically better — because it’s survivable. Shorter windows keep most of the lump-sum advantage while capping the regret.
3. Either way, decide the schedule before the first purchase and automate it. A DCA plan without a written end date becomes market timing, and market timing is how people end up fully invested at the top anyway.
4. Never DCA into individual stocks you picked because of a story. DCA makes sense as risk management for broad, boring assets. Averaging into a single speculative pick is averaging into a thesis, which is different and worse.

A Note on Windfalls Specifically

Windfall money is different from paycheck money in one way that matters: it has no replacement schedule. If you DCA your paycheck contributions, you’re just investing as you earn — that’s not a choice, it’s the only option. A lump sum is a genuine fork. My honest suggestion: split the emotional load from the financial one. Write down what the money is for before deciding how to deploy it. Money that carries grief, obligation, or guilt tends to get handled badly in both directions — invested too rashly to feel “worthy” of it, or frozen entirely because touching it feels wrong.

Bottom Line

Lump sum beats DCA about two-thirds of the time by the historical US data, because cash waiting on the sideline is a drag more often than it’s a shield. But the gap is modest, and the third of the time DCA wins includes exactly the scenarios that would test your discipline hardest. Choose the plan whose worst case you can actually live with.

One forward step: if you have a lump sum in motion right now, write down today’s date, your plan (lump or schedule), and the rule that would make you abandon it. Then tape it somewhere you’ll see it in month two of a drawdown. The plan matters less than the promise not to renegotiate it with yourself when the market is red.