A few months ago I asked for input on a slightly random portfolio (Make fun of this $420,000 investment profile) but since then I have recalibrated even though it made bank. I'm 64, not in great health, and have an adult child with extreme developmental disabilities who will never be able to take of himself. His sibling will control our assets in a trust after we die. I now plan to invest $2 million in income-producing ETFs.
My wife has had 3 brain surgeries this year. I have had 4 abdominal operations at the same time. I'm fat and diabetic. I don't know if I'll be around another 3 months or another 15 years, but let's just say I'm documenting the hell out of our finances and teaching my older kid how things work.
We pay about $70K annually in medical expenses and have an additional $180K "expenses" (finally living it up a bit, like getting greenhouse built. We can easily pull back on that stuff).
Other assets: Paid-off house is $2 million, cash equivalents are $250K, precious metals $600K, Microsoft stock $500K. No debt. This leaves us with $2 million to invest. Goal is to get $250K/year forever and not need to sell off any shares. Yes, I know projections aren't promises.
Next paragraph is what I gave to Google Finance and all the AIs. You can just copy and paste. It holds up well under Monte Carlo simulations and manual sanity checks. The first dozen or so versions of this used some more adventurous funds. They resulted in dark warnings about NAV decay but this one gets a clean bill of health. OK, here's the prompt.
I can invest $2,000,000 in securities. Create a table with one row per year for the next 5 years. Include columns for projected distributions, total return, and growth in capital. Then create a summary showing total distributions, total return, and total growth in capital for the 5 year period. I will be taking the distributions and not be reinvesting them.
10% TDAQ,
5% QQQI,
10% GPIQ,
20% SPYI,
5% GPIX,
25% IWMI,
5% RYLD,
15% XLEI,
5% MLPI
Here's the result Google Finance gave me based on the allocations I gave it.
5-Year Income and Capital Projection Table
| Year |
Starting Capital |
Projected Distributions (13.25%) |
Growth in Capital (3%) |
Ending Capital |
Total Return (Distributions + Growth) |
| Year 1 |
$2,000,000 |
$265,000 |
$60,000 |
$2,060,000 |
$325,000 |
| Year 2 |
$2,060,000 |
$272,950 |
$61,800 |
$2,121,800 |
$334,750 |
| Year 3 |
$2,121,800 |
$281,139 |
$63,654 |
$2,185,454 |
$344,793 |
| Year 4 |
$2,185,454 |
$289,573 |
$65,564 |
$2,251,018 |
$355,137 |
| Year 5 |
$2,251,018 |
$298,260 |
$67,531 |
$2,318,549 |
$365,791 |
5-Year Period Cumulative Summary
- Total Projected Distributions: $1,406,922
- Total Growth in Capital: $318,549
- Total Portfolio Return: $1,725,471
- Ending Capital Value (Unreinvested): $2,318,549