RMD Trim Planner Help

Turn a required minimum distribution into a list of shares to sell. Upload a holdings file, choose how to trim, and take away a trade list as a CSV.

Watch the walkthrough

2 minutes 48 seconds, with narration and on-screen captions. It covers the formula, the four trim methods and why each exists.

Narration: AI-generated voiceCaptions: turn on with the CC buttonDownload the MP4
Read the transcript

Introduction 0:01

Starting the year you turn seventy-three, the IRS requires an RMD, a Required Minimum Distribution, from your traditional IRA every year. It is the prior year-end balance divided by an IRS divisor, and it is taxed as ordinary income. This planner turns that into a trade list.

Help page and sample files 0:21

The planner's help link opens a help page with this video, an FAQ, and four sample holdings files. Download one, or copy it, then open the planner.

Enter the inputs and upload 0:32

Enter last year-end's balance, one hundred five thousand dollars, and your age. Seventy-three uses a divisor of twenty-six point five. Add your advisory fee, one percent, then upload the holdings file. A Merrill Lynch export is converted automatically.

Read the results 0:49

The RMD is three thousand, nine hundred sixty-two dollars. Existing cash, four hundred dollars, is used first, so about thirty-five hundred must come from selling stock. Shares sell whole, so the amount lands slightly higher.

Why the choice matters 1:04

Inside an IRA, selling a winner or a loser has no tax effect. So the withdrawal is a forced sale you can use to rebalance and cut risk. The trim method decides how.

Largest positions first 1:16

Largest positions first pulls the biggest weights back toward the pack. Here it sells eight names, bringing weights near seven percent down to about six.

Pro-rata 1:26

Pro rata trims every position in proportion, so your mix stays the same. That is easy to explain, but it means eleven small trades.

Most appreciated first 1:35

Most appreciated first sells the biggest winners. Inside an IRA, gain just measures how far a position has run. The threshold, twenty percent, limits it to names that really ran. The cap, twenty-five percent, limits how much of any one position goes. Nvidia is up two hundred forty-three percent, but gives up only fifteen of its sixty shares.

High-beta, sector, then largest 1:58

The fourth method is built for retirees, who must withdraw whatever the market is doing. It first sells appreciated, high-beta names, the ones most likely to fall hard: Nvidia and Caterpillar. Then it checks sector concentration. With the limit at fifteen percent, Consumer Staples is over, so it also trims Walmart and Coca-Cola.

Frozen columns 2:20

Scroll right, and the symbol and description columns stay frozen, so every trade stays readable.

Fee savings and export 2:26

Every dollar withdrawn shrinks assets under management, so a one-percent fee saves about forty dollars a year, or ten dollars a quarter. Download or copy the file for your manager. This is analysis, not tax or investment advice. Confirm the final RMD with your custodian or CPA.

Quick start

Everything runs in your browser. The file you choose is not uploaded.

  1. Enter the balance and your age.Use the account's value on December 31 of last year, and the age you turn this year. The planner divides one by the IRS divisor to get the RMD.
  2. Add the fee and the account total.Enter your advisory fee as a percent to see the yearly fee saving. If your file lists only part of the account, enter the whole account value so weights are right.
  3. Choose your holdings file.A CSV or tab-separated export with Symbol, Price and Quantity columns. Not sure what yours needs? See File format, or start from a sample file.
  4. Read the cards.The planner applies existing cash first, then shows the amount left to raise by selling stock, the shares it sells, the cash left over and the manager-fee saving.
  5. Pick a trim method.Largest first, pro-rata, most appreciated first, or the risk-based order. Adjust the threshold, the cap, the beta cutoff and the sector limit, or exclude symbols you want to keep.
  6. Take the trade list.Use Download CSV or Copy CSV. Prices come from your file, so check them against live quotes before you trade.

Sample holdings files

Four fictional portfolios you can load into the planner to see how it behaves. Prices, betas and cost bases are illustrative, not quotes.

1. Balanced portfolio

A Schwab-style export with 16 stocks and a cash row. Shows every method.

Balance
$105,000
Age
73 (RMD $3,962.26)
Cash
$400.00, used first
To trim
$3,562.26
Download

2. Current Value and money market

Uses the headers Quantity, Last Price, Unit Cost and Current Value. The money-market row has no price. One stock has no cost, so its gain is worked out from Unrealized Gain/Loss.

Balance
$62,000
Age
73 (RMD $2,339.62)
Cash
$1,200.00, money market
To trim
$1,139.62
Download

3. Minimum columns

Only Symbol, Price, Qty and Mkt Val. With no cost data, gain % shows n/a and the planner falls back to the largest positions.

Balance
$53,000
Age
73 (RMD $2,000.00)
Cash
$1,500.00
To trim
$500.00
Download

4. Technology-heavy

About 75% of the account is technology. Choose the high-beta method and the sector step trims the largest technology holding. Includes a Sector column.

Balance
$100,000
Age
73 (RMD $3,773.58)
Cash
$400.00
To trim
$3,373.58
Download

To try one: download it, open the planner, enter the balance and age shown, choose the file, then switch trim methods and compare.

File format

Header names are matched without regard to capitals. Dollar signs, commas, percent signs and (negative) brackets are fine. Any lines above the header row, such as an account title or a date, are skipped automatically. Merrill Lynch exports (a combined “Symbol Description” column) are converted automatically: the planner splits the ticker, works out gain, and adds estimated beta and sector, and you can download the cleaned file.

What it isAccepted headersNotes
Symbol requiredSymbolOne row per holding.
Price requiredPrice Last Price Last Current Price Market PriceTaken as-is. Check against live quotes before trading.
Quantity requiredQty Quantity SharesWhole or fractional.
Value recommendedMkt Val Market Value Value Current ValueUsed for cash rows and for gain %. If missing, Price × Qty is used.
Cost recommendedCost Basis Cost Total Cost, or a per-share cost: Cost/Share Unit Cost Average CostNeeded for gain-based methods. Per-share cost is multiplied by quantity. If both are missing, the planner uses Unrealized Gain/Loss, then the file's own Gain %.
Description optionalDescriptionShown in full. Also used to spot cash rows and bond maturity dates.
Asset Type optionalAsset Type Security Type Asset ClassA value of Cash or Money Market makes the row cash, which is applied to the RMD first. Bond, Treasury, Note or CD marks a bond.
Bonds optionalAsset Type (Bond, Treasury, Note, CD) and Maturity, or a date in the description such as 4.5% 11/15/2028Bonds are sold only after cash and stocks, earliest maturity first, in whole $1,000 lots. Sector shows as Fixed Income.
Beta optionalBetaA missing beta counts as 0.
Sector optionalSector IndustryIf absent, a built-in list of about 60 common tickers is used. Everything else is "Unknown".
Cash rowsA Symbol starting with "Cash"; a Description containing "Money Market" or starting with "Sweep"; common money-market symbols (SPAXX, FDRXX, FZFXX, SPRXX, FCASH, SWVXX, VMFXX, QACDS)The amount comes from Value or Current Value, so a cash row without a price works. Other symbols: add them in the "Treat as cash" box.

Frequently asked questions

No questions match. Try a shorter word.

RMD basics
What is an RMD, and when does it start?

A required minimum distribution is the amount the IRS requires you to withdraw each year from a traditional IRA. It starts in the year you turn 73, or 75 if you were born in 1960 or later. You may delay the first one to April 1 of the next year, but then you take two in that year, which can push you into a higher tax bracket.

After that, each RMD is due by December 31. Missing it costs 25% of the shortfall, or 10% if you correct it promptly. Original owners of Roth IRAs have no RMD.

How does the planner calculate the RMD?

It divides the prior December 31 balance by the IRS Uniform Lifetime Table divisor for the age you turn this year: 26.5 at 73 and 25.5 at 74. For example, $500,000 ÷ 26.5 = $18,867.92.

The planner handles one account at a time. With several traditional IRAs, run each one and add the results; the total can be taken from any one of them. 401(k) accounts are calculated and withdrawn separately.

Which balance and age should I enter?

Balance: the account's value on December 31 of last year, from your year-end statement, not today's value. Age: the age you reach this year. If your birthday hasn't come yet, enter the age you will turn.

The age matters. At 73 the divisor is 26.5, at 74 it is 25.5, so the same $500,000 gives $18,868 or $19,608.

Does it matter which shares I sell inside an IRA?

Not for tax. Sales inside an IRA aren't taxed, and the distribution is ordinary income whichever shares you sell. So the planner chooses by risk and balance rather than by tax lot. It is not meant for taxable accounts, where tax lots and wash-sale rules matter.

Does it handle qualified charitable distributions?

No. A qualified charitable distribution can satisfy part or all of the RMD tax-free, but the planner doesn't model it. If you plan one, ask your custodian how much of the RMD is left to take.

Files and cash
What columns does my file need?

At minimum, Symbol, Price and Quantity, in a CSV or tab-separated file with a header row. Value and a cost column are recommended. The File format table lists every accepted header name.

How does "cash first" work?

Existing cash is applied to the RMD before any stock is sold, so you sell only what is left: Amount to trim = RMD − cash, never below zero. If cash covers the whole RMD, nothing is sold.

A row counts as cash when its Symbol starts with "Cash", its Description contains "Money Market" or starts with "Sweep", or its symbol is a common money-market fund. The amount comes from Value or Current Value, so a cash row with no price still works.

The planner shows no cash, but my account has some

Look at the Existing cash card: it names the row it read. If a note says no cash was read, the row's symbol or description isn't one the planner recognizes. Enter its symbol in "Treat as cash", or rename the row "Cash". Also check that the row has an amount in Value, Mkt Val or Current Value.

My file lists only part of the account. What should I do?

Enter the whole account value in "Total account value". The planner uses it for position weights and sector percentages. The RMD still comes from the balance you entered.

Why does Gain % show n/a?

The planner needs a cost to work it out: a Cost Basis column, or a per-share cost times quantity. If neither is there, it uses Unrealized Gain/Loss, then the file's own Gain % column. With none of these, the gain-based methods can't rank positions and fall back to the largest positions.

The note under the buttons lists the symbols affected and the headers it found.

Trim methods
Which trim method should I use?

Largest positions first pulls the biggest weights back toward the pack with few trades. It is mechanical and ignores risk.

Pro-rata trims everything in proportion, so your mix stays the same. It makes many small trades and fixes no concentration.

Most appreciated first takes profits from the biggest winners, then the largest positions.

High-beta appreciated, then over-concentrated sectors, then largest funds the withdrawal from the riskiest, most extended holdings first. That lowers portfolio beta and reduces the chance of selling safer holdings in a falling market.

What do the appreciation threshold and the cap do?

The threshold (default 20%) limits profit-taking to positions that have really run. Too high and nothing qualifies, so the method turns into "largest first". Too low and everything qualifies, so it is just a ranking by gain. A level that a handful of your holdings clear is a good start.

The cap (default 25%) is the most of any one position the priority step can sell. It stops a winner being sold off entirely and spreads the selling across several names. The fallback to the largest positions is not capped, so it can go past the cap if more cash is needed.

Where do beta and sector come from?

From the file's Beta and Sector columns if they exist. Otherwise the planner uses its built-in sector list of about 60 common tickers and labels the rest "Unknown", which the sector limit ignores. A position with no beta counts as beta 0, so the high-beta step skips it.

Use the Beta overrides and Sector overrides boxes to fix gaps, for example AMAT=1.6 or AAPL=Technology.

Why wasn't a particular stock selected?

It may be on the exclude list, below the appreciation threshold or the beta cutoff, or already at its cap. Each method works through its priority steps first and then falls back to the largest positions.

Results and output
Why is "Shares to sell" more than "Amount to trim"?

Only whole shares are sold, so the total rounds up past the target and the extra stays in the account as cash. Prices come from your file, so adjust the share counts to live quotes before you trade.

How is the manager-fee saving calculated?

It is your advisory fee percent times the RMD that leaves the account, shown per year and per quarter. It assumes the lower balance applies for a full year. The real saving depends on when you take the distribution and how your manager bills.

My account is managed. Who places the trades?

Usually your manager. Send them the RMD amount and your preferred approach, or the planner's CSV as a starting point, and confirm the final figure with your custodian or CPA.

Download CSV doesn't work

Some browsers and embedded viewers block downloads. Use Copy CSV and paste it into a text file saved as .csv, or open the page in a regular browser tab.

The CSV has one SELL row per trade, CASH rows for the cash flow, and an INFO row that shows the RMD inputs.

Is my file uploaded anywhere?

No. The planner reads your file and does all the math in your browser. Nothing is sent or stored.