Deposit: $10,000.00
Gross return: 7.00%
Target-date expense ratio: 0.50%
Index-fund expense ratio: 0.04%
Years: 20 years
Target-date ending: $35,236.45
Target-date net return: 6.50%
Index-fund ending: $38,408.55
Index-fund net return: 6.96%
Fee drag (gap): $3,172.10
Winner: index fund wins by $3,172.10
Branch: 30 years: Deposit $10,000.00, gross return 7.00%, target-date expense 0.50%, index expense 0.04%, 30 years: target-date ending $66,143.66 (net 6.50%), index ending $75,273.45 (net 6.96%), gap $9,129.79, index fund wins by $9,129.79
Branch: 10 years: Deposit $10,000.00, gross return 7.00%, target-date expense 0.50%, index expense 0.04%, 10 years: target-date ending $18,771.37 (net 6.50%), index ending $19,598.10 (net 6.96%), gap $826.72, index fund wins by $826.72
Branch: Deposit $50,000: Deposit $50,000.00, gross return 7.00%, target-date expense 0.50%, index expense 0.04%, 20 years: target-date ending $176,182.25 (net 6.50%), index ending $192,042.74 (net 6.96%), gap $15,860.48, index fund wins by $15,860.48
Branch: Target-date expense 0.15%: Deposit $10,000.00, gross return 7.00%, target-date expense 0.15%, index expense 0.04%, 20 years: target-date ending $37,626.21 (net 6.85%), index ending $38,408.55 (net 6.96%), gap $782.33, index fund wins by $782.33
Branch: Index expense 0.10%: Deposit $10,000.00, gross return 7.00%, target-date expense 0.50%, index expense 0.10%, 20 years: target-date ending $35,236.45 (net 6.50%), index ending $37,979.93 (net 6.90%), gap $2,743.47, index fund wins by $2,743.47
Branch: Gross return 5%: Deposit $10,000.00, gross return 5.00%, target-date expense 0.50%, index expense 0.04%, 20 years: target-date ending $24,117.14 (net 4.50%), index ending $26,331.55 (net 4.96%), gap $2,214.41, index fund wins by $2,214.41
Branch: Target-date expense 0.75%: Deposit $10,000.00, gross return 7.00%, target-date expense 0.75%, index expense 0.04%, 20 years: target-date ending $33,618.53 (net 6.25%), index ending $38,408.55 (net 6.96%), gap $4,790.01, index fund wins by $4,790.01
Reverse: Deposit for a $5,000.00 gap: $15,762.44
Reverse: Deposit for a $5,000.00 gap (rounded): $15,762.44
Exact deposit for a $5,000.00 gap: 15762.4437
At $15,762.44 the figures are: Deposit $15,762.44, gross return 7.00%, target-date expense 0.50%, index expense 0.04%, 20 years: target-date ending $55,541.24 (net 6.50%), index ending $60,541.24 (net 6.96%), gap $5,000.00, index fund wins by $5,000.00
At the lower neighbor the figures are: Deposit $15,761.44, gross return 7.00%, target-date expense 0.50%, index expense 0.04%, 20 years: target-date ending $55,537.72 (net 6.50%), index ending $60,537.40 (net 6.96%), gap $4,999.68, index fund wins by $4,999.68
At the upper neighbor the figures are: Deposit $15,763.44, gross return 7.00%, target-date expense 0.50%, index expense 0.04%, 20 years: target-date ending $55,544.77 (net 6.50%), index ending $60,545.08 (net 6.96%), gap $5,000.32, index fund wins by $5,000.32
Reverse verdict: CONTINUOUS
Reverse: Target-date expense for an exact tie: 0.04%
Reverse: Target-date expense for an exact tie (rounded): 0.04%
Exact target-date expense for an exact tie: 0.0400%
At 0.04% the figures are: Deposit $10,000.00, gross return 7.00%, target-date expense 0.04%, index expense 0.04%, 20 years: target-date ending $38,408.55 (net 6.96%), index ending $38,408.55 (net 6.96%), gap $0.00, Tie
At the lower neighbor the figures are: Deposit $10,000.00, gross return 7.00%, target-date expense 0.03%, index expense 0.04%, 20 years: target-date ending $38,480.43 (net 6.97%), index ending $38,408.55 (net 6.96%), gap -$71.88, target-date fund wins by $71.88
At the upper neighbor the figures are: Deposit $10,000.00, gross return 7.00%, target-date expense 0.05%, index expense 0.04%, 20 years: target-date ending $38,336.79 (net 6.95%), index ending $38,408.55 (net 6.96%), gap $71.75, index fund wins by $71.75
Reverse verdict: CONTINUOUS
Reverse: Years for the gap to reach $5,000: 25 years
Reverse: Years for the gap to reach $5,000 (rounded): 25 years
Exact years for the gap to reach $5,000: 25 years
At 25 years the figures are: Deposit $10,000.00, gross return 7.00%, target-date expense 0.50%, index expense 0.04%, 25 years: target-date ending $48,276.99 (net 6.50%), index ending $53,769.36 (net 6.96%), gap $5,492.37, index fund wins by $5,492.37
At the lower neighbor the figures are: Deposit $10,000.00, gross return 7.00%, target-date expense 0.50%, index expense 0.04%, 24 years: target-date ending $45,330.51 (net 6.50%), index ending $50,270.53 (net 6.96%), gap $4,940.02, index fund wins by $4,940.02
At the upper neighbor the figures are: Deposit $10,000.00, gross return 7.00%, target-date expense 0.50%, index expense 0.04%, 26 years: target-date ending $51,415.00 (net 6.50%), index ending $57,511.71 (net 6.96%), gap $6,096.71, index fund wins by $6,096.71
Reverse verdict: STEP
Reverse: Gross return for a $50,000.00 target-date ending: 8.88%
Reverse: Gross return for a $50,000.00 target-date ending (rounded): 8.88%
Exact gross return for a $50,000.00 target-date ending: 8.8798%
At 8.88% the figures are: Deposit $10,000.00, gross return 8.88%, target-date expense 0.50%, index expense 0.04%, 20 years: target-date ending $50,001.49 (net 8.38%), index ending $54,421.52 (net 8.84%), gap $4,420.03, index fund wins by $4,420.03
At the lower neighbor the figures are: Deposit $10,000.00, gross return 8.87%, target-date expense 0.50%, index expense 0.04%, 20 years: target-date ending $49,909.30 (net 8.37%), index ending $54,321.60 (net 8.83%), gap $4,412.31, index fund wins by $4,412.31
At the upper neighbor the figures are: Deposit $10,000.00, gross return 8.89%, target-date expense 0.50%, index expense 0.04%, 20 years: target-date ending $50,093.84 (net 8.39%), index ending $54,521.61 (net 8.85%), gap $4,427.77, index fund wins by $4,427.77
Reverse verdict: CONTINUOUS
Reverse: Index expense for a $1,000.00 gap: 0.35%
Reverse: Index expense for a $1,000.00 gap (rounded): 0.35%
Exact index expense for a $1,000.00 gap: 0.3509%
At 0.35% the figures are: Deposit $10,000.00, gross return 7.00%, target-date expense 0.50%, index expense 0.35%, 20 years: target-date ending $35,236.45 (net 6.50%), index ending $36,242.42 (net 6.65%), gap $1,005.97, index fund wins by $1,005.97
At the lower neighbor the figures are: Deposit $10,000.00, gross return 7.00%, target-date expense 0.50%, index expense 0.34%, 20 years: target-date ending $35,236.45 (net 6.50%), index ending $36,310.45 (net 6.66%), gap $1,074.00, index fund wins by $1,074.00
At the upper neighbor the figures are: Deposit $10,000.00, gross return 7.00%, target-date expense 0.50%, index expense 0.36%, 20 years: target-date ending $35,236.45 (net 6.50%), index ending $36,174.52 (net 6.64%), gap $938.07, index fund wins by $938.07
Reverse verdict: CONTINUOUS
Reverse: Deposit for a $100,000.00 index ending: $26,035.87
Reverse: Deposit for a $100,000.00 index ending (rounded): $26,035.87
Exact deposit for a $100,000.00 index ending: 26035.8712
At $26,035.87 the figures are: Deposit $26,035.87, gross return 7.00%, target-date expense 0.50%, index expense 0.04%, 20 years: target-date ending $91,741.16 (net 6.50%), index ending $100,000.00 (net 6.96%), gap $8,258.83, index fund wins by $8,258.83
At the lower neighbor the figures are: Deposit $26,034.87, gross return 7.00%, target-date expense 0.50%, index expense 0.04%, 20 years: target-date ending $91,737.64 (net 6.50%), index ending $99,996.15 (net 6.96%), gap $8,258.51, index fund wins by $8,258.51
At the upper neighbor the figures are: Deposit $26,036.87, gross return 7.00%, target-date expense 0.50%, index expense 0.04%, 20 years: target-date ending $91,744.69 (net 6.50%), index ending $100,003.84 (net 6.96%), gap $8,259.15, index fund wins by $8,259.15
Reverse verdict: CONTINUOUS
Edge: 0 years: Deposit $10,000.00, gross return 7.00%, target-date expense 0.50%, index expense 0.04%, 0 years: target-date ending $10,000.00 (net 6.50%), index ending $10,000.00 (net 6.96%), gap $0.00, Tie
Edge: Deposit $0: Deposit $0.00, gross return 7.00%, target-date expense 0.50%, index expense 0.04%, 20 years: target-date ending $0.00 (net 6.50%), index ending $0.00 (net 6.96%), gap $0.00, Tie
Edge: Gross return 0%: Deposit $10,000.00, gross return 0.00%, target-date expense 0.50%, index expense 0.04%, 20 years: target-date ending $9,046.10 (net -0.50%), index ending $9,920.30 (net -0.04%), gap $874.20, index fund wins by $874.20
Edge: 40 years: Deposit $10,000.00, gross return 7.00%, target-date expense 0.50%, index expense 0.04%, 40 years: target-date ending $124,160.75 (net 6.50%), index ending $147,521.65 (net 6.96%), gap $23,360.91, index fund wins by $23,360.91
Edge: Target-date expense 0.04%: Deposit $10,000.00, gross return 7.00%, target-date expense 0.04%, index expense 0.04%, 20 years: target-date ending $38,408.55 (net 6.96%), index ending $38,408.55 (net 6.96%), gap $0.00, Tie
Edge: Deposit $1,000,000: Deposit $1,000,000.00, gross return 7.00%, target-date expense 0.50%, index expense 0.04%, 20 years: target-date ending $3,523,645.06 (net 6.50%), index ending $3,840,854.76 (net 6.96%), gap $317,209.70, index fund wins by $317,209.70
30 years: Deposit $10,000.00, gross return 7.00%, target-date expense 0.50%, index expense 0.04%, 30 years: target-date ending $66,143.66 (net 6.50%), index ending $75,273.45 (net 6.96%), gap $9,129.79, index fund wins by $9,129.79.
10 years: Deposit $10,000.00, gross return 7.00%, target-date expense 0.50%, index expense 0.04%, 10 years: target-date ending $18,771.37 (net 6.50%), index ending $19,598.10 (net 6.96%), gap $826.72, index fund wins by $826.72.
Deposit $50,000: Deposit $50,000.00, gross return 7.00%, target-date expense 0.50%, index expense 0.04%, 20 years: target-date ending $176,182.25 (net 6.50%), index ending $192,042.74 (net 6.96%), gap $15,860.48, index fund wins by $15,860.48.
Target-date expense 0.15%: Deposit $10,000.00, gross return 7.00%, target-date expense 0.15%, index expense 0.04%, 20 years: target-date ending $37,626.21 (net 6.85%), index ending $38,408.55 (net 6.96%), gap $782.33, index fund wins by $782.33.
Index expense 0.10%: Deposit $10,000.00, gross return 7.00%, target-date expense 0.50%, index expense 0.10%, 20 years: target-date ending $35,236.45 (net 6.50%), index ending $37,979.93 (net 6.90%), gap $2,743.47, index fund wins by $2,743.47.
Gross return 5%: Deposit $10,000.00, gross return 5.00%, target-date expense 0.50%, index expense 0.04%, 20 years: target-date ending $24,117.14 (net 4.50%), index ending $26,331.55 (net 4.96%), gap $2,214.41, index fund wins by $2,214.41.
Target-date expense 0.75%: Deposit $10,000.00, gross return 7.00%, target-date expense 0.75%, index expense 0.04%, 20 years: target-date ending $33,618.53 (net 6.25%), index ending $38,408.55 (net 6.96%), gap $4,790.01, index fund wins by $4,790.01.
Reverse: the deposit for a $5,000.00 gap is $15,762.44 (exact 15762.4437); at $15,762.44 the gap is $5,000.00 — verdict: CONTINUOUS. The target-date expense for an exact tie is 0.04% (exact 0.0400%); at 0.04% the gap is $0.00 — verdict: CONTINUOUS. The years for the gap to reach $5,000 are 25 years; at 25 years the gap is $5,492.37; 24 years gives $4,940.02 — verdict: STEP. The gross return for a $50,000.00 target-date ending is 8.88% (exact 8.8798%); at 8.88% the target-date ending is $50,001.49; 8.87% gives $49,909.30 — verdict: CONTINUOUS. The index expense for a $1,000.00 gap is 0.35% (exact 0.3509%); at 0.35% the gap is $1,005.97; 0.36% gives $938.07 — verdict: CONTINUOUS. The deposit for a $100,000.00 index ending is $26,035.87 (exact 26035.8712); at $26,035.87 the index ending is $100,000.00 — verdict: CONTINUOUS.
Edges: 0 years gives Deposit $10,000.00, gross return 7.00%, target-date expense 0.50%, index expense 0.04%, 0 years: target-date ending $10,000.00 (net 6.50%), index ending $10,000.00 (net 6.96%), gap $0.00, Tie. A deposit of $0 gives Deposit $0.00, gross return 7.00%, target-date expense 0.50%, index expense 0.04%, 20 years: target-date ending $0.00 (net 6.50%), index ending $0.00 (net 6.96%), gap $0.00, Tie. A gross return of 0% gives Deposit $10,000.00, gross return 0.00%, target-date expense 0.50%, index expense 0.04%, 20 years: target-date ending $9,046.10 (net -0.50%), index ending $9,920.30 (net -0.04%), gap $874.20, index fund wins by $874.20. 40 years gives Deposit $10,000.00, gross return 7.00%, target-date expense 0.50%, index expense 0.04%, 40 years: target-date ending $124,160.75 (net 6.50%), index ending $147,521.65 (net 6.96%), gap $23,360.91, index fund wins by $23,360.91. A target-date expense of 0.04% gives Deposit $10,000.00, gross return 7.00%, target-date expense 0.04%, index expense 0.04%, 20 years: target-date ending $38,408.55 (net 6.96%), index ending $38,408.55 (net 6.96%), gap $0.00, Tie. A deposit of $1,000,000.00 gives Deposit $1,000,000.00, gross return 7.00%, target-date expense 0.50%, index expense 0.04%, 20 years: target-date ending $3,523,645.06 (net 6.50%), index ending $3,840,854.76 (net 6.96%), gap $317,209.70, index fund wins by $317,209.70.