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
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.
2 minutes 48 seconds, with narration and on-screen captions. It covers the formula, the four trim methods and why each exists.
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.
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 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.
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.
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 pulls the biggest weights back toward the pack. Here it sells eight names, bringing weights near seven percent down to about six.
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 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.
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.
Scroll right, and the symbol and description columns stay frozen, so every trade stays readable.
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.
Everything runs in your browser. The file you choose is not uploaded.
Four fictional portfolios you can load into the planner to see how it behaves. Prices, betas and cost bases are illustrative, not quotes.
A Schwab-style export with 16 stocks and a cash row. Shows every method.
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.
Only Symbol, Price, Qty and Mkt Val. With no cost data, gain % shows n/a and the planner falls back to the largest positions.
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.
To try one: download it, open the planner, enter the balance and age shown, choose the file, then switch trim methods and compare.
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 is | Accepted headers | Notes |
|---|---|---|
| Symbol required | Symbol | One row per holding. |
| Price required | Price Last Price Last Current Price Market Price | Taken as-is. Check against live quotes before trading. |
| Quantity required | Qty Quantity Shares | Whole or fractional. |
| Value recommended | Mkt Val Market Value Value Current Value | Used for cash rows and for gain %. If missing, Price × Qty is used. |
| Cost recommended | Cost Basis Cost Total Cost, or a per-share cost: Cost/Share Unit Cost Average Cost | Needed 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 optional | Description | Shown in full. Also used to spot cash rows and bond maturity dates. |
| Asset Type optional | Asset Type Security Type Asset Class | A 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 optional | Asset Type (Bond, Treasury, Note, CD) and Maturity, or a date in the description such as 4.5% 11/15/2028 | Bonds are sold only after cash and stocks, earliest maturity first, in whole $1,000 lots. Sector shows as Fixed Income. |
| Beta optional | Beta | A missing beta counts as 0. |
| Sector optional | Sector Industry | If absent, a built-in list of about 60 common tickers is used. Everything else is "Unknown". |
| Cash rows | A 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. |
No questions match. Try a shorter word.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
No. The planner reads your file and does all the math in your browser. Nothing is sent or stored.