You input in the expense ratio of the advisory portfolio. (.05 -.17% is current range)
Stair Step Breakdown
Company
Tier Range
Rate (%)
Amount in Tier ($)
Fee for Tier ($)
EdwardJones
$0 - $49,999
1.35
$49,999.00
$674.99
EdwardJones
$50,000 - $99,999
1.35
$49,999.00
$674.99
EdwardJones
$100,000 - $249,999
1.35
$149,999.00
$2,024.99
EdwardJones
$250,000 - $499,999
1.30
$249,999.00
$3,249.99
EdwardJones
$500,000 - $749,999
1.25
$249,999.00
$3,124.99
EdwardJones
$750,000 - $999,999
1.25
$0.00
$0.00
EdwardJones
$1,000,000 - $1,999,999
1
$0.00
$0.00
EdwardJones
$2,000,000 - $2,499,999
1
$0.00
$0.00
EdwardJones
$2,500,000 - $4,999,999
0.80
$0.00
$0.00
EdwardJones
$5,000,000 - $9,999,999
0.60
$0.00
$0.00
EdwardJones
$10,000,000 - $inf
0.50
$0.00
$0.00
Total
$9,749.93
CharlesSchwab
$0 - $49,999
0.90
$49,999.00
$449.99
CharlesSchwab
$50,000 - $99,999
0.90
$49,999.00
$449.99
CharlesSchwab
$100,000 - $249,999
0.75
$149,999.00
$1,124.99
CharlesSchwab
$250,000 - $499,999
0.75
$249,999.00
$1,874.99
CharlesSchwab
$500,000 - $749,999
0.65
$249,999.00
$1,624.99
CharlesSchwab
$750,000 - $999,999
0.65
$0.00
$0.00
CharlesSchwab
$1,000,000 - $1,999,999
0.50
$0.00
$0.00
CharlesSchwab
$2,000,000 - $2,499,999
0.50
$0.00
$0.00
CharlesSchwab
$2,500,000 - $4,999,999
0.50
$0.00
$0.00
CharlesSchwab
$5,000,000 - $9,999,999
0.50
$0.00
$0.00
CharlesSchwab
$10,000,000 - $inf
0.50
$0.00
$0.00
Total
$5,524.96
Fidelity
$0 - $49,999
1.50
$49,999.00
$749.99
Fidelity
$50,000 - $99,999
1.50
$49,999.00
$749.99
Fidelity
$100,000 - $249,999
1.50
$149,999.00
$2,249.99
Fidelity
$250,000 - $499,999
1.50
$249,999.00
$3,749.99
Fidelity
$500,000 - $749,999
1.10
$249,999.00
$2,749.99
Fidelity
$750,000 - $999,999
1.10
$0.00
$0.00
Fidelity
$1,000,000 - $1,999,999
0.90
$0.00
$0.00
Fidelity
$2,000,000 - $2,499,999
0.70
$0.00
$0.00
Fidelity
$2,500,000 - $4,999,999
0.70
$0.00
$0.00
Fidelity
$5,000,000 - $9,999,999
0.50
$0.00
$0.00
Fidelity
$10,000,000 - $inf
0.50
$0.00
$0.00
Total
$10,249.93
RaymondJames
$0 - $49,999
2.25
$49,999.00
$1,124.98
RaymondJames
$50,000 - $99,999
2.25
$49,999.00
$1,124.98
RaymondJames
$100,000 - $249,999
2.25
$149,999.00
$3,374.98
RaymondJames
$250,000 - $499,999
2.25
$249,999.00
$5,624.98
RaymondJames
$500,000 - $749,999
2.25
$249,999.00
$5,624.98
RaymondJames
$750,000 - $999,999
2.25
$0.00
$0.00
RaymondJames
$1,000,000 - $1,999,999
2
$0.00
$0.00
RaymondJames
$2,000,000 - $2,499,999
1.75
$0.00
$0.00
RaymondJames
$2,500,000 - $4,999,999
1.75
$0.00
$0.00
RaymondJames
$5,000,000 - $9,999,999
1.50
$0.00
$0.00
RaymondJames
$10,000,000 - $inf
1.50
$0.00
$0.00
Total
$16,874.89
Custom Stair Step Input
Enter your investment amount:
$50,000,000.00
Key:
***If you are dealing with a firm not on our spreadsheet, but you know their tiers, simply input them in this column and it calculate for you. Make sure you have the tiers correlated with rate.
Start ($)
End ($)
Rate (%)
Amount in Tier ($)
Fee for Tier ($)
Expense Ratio (%)
Operating Expense Fee ($)
***This is the expense ratio of their current mutual funds. They usually own more than just one fund, so you would usually just add these together. This number applies to all dollars, and is not tiered.