Session 12 — Mutual Fund Selection
Age-flexible: costs, diversification, taxes • simple model portfolios
Your goal today: build a simple, low-cost, diversified long-term portfolio like a real 401(k)/IRA investor.
Classroom heuristic, not tax advice. Laws & plan rules change.
| Add | Ticker | Name | Category | ER | Index? | Turnover | 1y | 3y | 5y |
|---|
| Label | Value |
|---|---|
| Gross annual return | 0.07 (format as %) |
| ER (bps) — Case A | 5 |
| ER (bps) — Case B | 60 |
| Monthly contribution | 300 |
| Years | 30 |
| Initial balance | 0 |
type=0):
=0.07 - 5/10000 → 6.95%=0.07 - 60/10000 → 6.40%=FV((0.07-0.0005)/12, 30*12, -300, 0, 0)=FV((0.07-0.0060)/12, 30*12, -300, 0, 0)=FVA - FVBtype=0 = contributions at the end of each month (matches your app).
type=1 (beginning-of-month), which inflates FV compared to the app.
Sample size: 16 submissions. Most of you built a simple, low-cost 3-fund portfolio.
| Pattern | Count | Notes |
|---|---|---|
| 60% / 20% / 20% | 3 | US stock / Intl stock / US bond |
| 80% / 20% | 2 | Stock / Bond (often all-US stock) |
| 83% / 17% | 3 | Stock / Bond (several all-US) |
| Other (95/5, 91/9, 89/11, 88/12, etc.) | 8 | Higher-stock tilts |
Authoritative links for class use (official SEC pages).