Current Investments from Statements |
Cash | Total Bonds | Total Equity | Current Value by Fund | ||||||||||||||||||
Total Domestic | Total International | |||||||||||||||||||||
Short Term | Intermediate | Long Term | Total Value | Total Growth | Total Value | Total Growth | ||||||||||||||||
Accounts | Funds | High Grade | High Grade | High Yield | High Grade | Large Cap | Mid Cap | Small Cap | Large Cap | Mid Cap | Small Cap | Large Cap | Mid Cap | Small Cap | Large Cap | Mid Cap | Small Cap | |||||
Qualified | IRA | MM Fund | 1,975 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | 1,975 | ||
Fund 1 | - | 3,125 | 3,125 | |||||||||||||||||||
Fund 2 | - | 2,356 | 2,356 | |||||||||||||||||||
401(k) | 55 | 1,589 | 1,644 | |||||||||||||||||||
Non-Qualified | MM Fund | 2,430 | 2,430 | |||||||||||||||||||
Fund 1 | - | 2,739 | 2,739 | |||||||||||||||||||
Fund 2 | - | 2,815 | 3,450 | 3,450 | 9,715 | |||||||||||||||||
Fund 3 | - | 1,928 | 4,820 | 6,748 | ||||||||||||||||||
Fund 4 | - | 2,895 | 2,895 | |||||||||||||||||||
Current Amt by Category | 4,460 | 5,940 | 0 | 2,356 | 1,928 | 5,039 | 2,739 | 0 | 3,450 | 4,820 | 0 | 0 | 0 | 0 | 2,895 | 0 | 0 | 33,627 | ||||
Current Funds | Bonds | Equity | Current Funds | |||||||||||||||||||
18,943 | ||||||||||||||||||||||
Domestic | International | |||||||||||||||||||||
Total: 33,627 | 10,993 | 16,048 | 2,895 | 33,627 | ||||||||||||||||||
Short Term | Intermediate | Long Term | Value | Growth | Value | Growth | ||||||||||||||||
5,940 | 3,125 | 1,928 | 7,778 | 8,270 | 0 | 2,895 | ||||||||||||||||
Cash | High Grade | High Grade | High Yield | High Grade | Large Cap | Mid Cap | Small Cap | Large Cap | Mid Cap | Small Cap | Large Cap | Mid Cap | Small Cap | Large Cap | Mid Cap | Small Cap | ||||||
Qualified Funds | 2,030 | 3,125 | 0 | 2,356 | 0 | 1,589 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9,100 | ||||
Non-Qualified Funds | 2,430 | 2,815 | 0 | 0 | 1,928 | 3,450 | 2,739 | 0 | 3,450 | 4,820 | 0 | 0 | 0 | 0 | 2,895 | 0 | 0 | 24,527 | ||||
Current Allocation | 13.3% | 17.7% | 0.0% | 7.0% | 5.7% | 15.0% | 8.1% | 0.0% | 10.3% | 14.3% | 0.0% | 0.0% | 0.0% | 0.0% | 8.6% | 0.0% | 0.0% | 100% | ||||
Current Age: | 55 | Bonds | Equity | Totals by Row | ||||||||||||||||||
65.0% | ||||||||||||||||||||||
Allocation for an Age is Entered in Yellow Cells (from Allocation Charts) | Domestic | International | ||||||||||||||||||||
28.0% | 76.0% | 24.0% | ||||||||||||||||||||
Short Term | Intermediate | Long Term | Value | Growth | Value | Growth | ||||||||||||||||
42.0% | 42.5% | 15.5% | 40.0% | 60.0% | 40.0% | 60.0% | ||||||||||||||||
Cash | High Grade | High Grade | High Yield | High Grade | Large Cap | Mid Cap | Small Cap | Large Cap | Mid Cap | Small Cap | Large Cap | Mid Cap | Small Cap | Large Cap | Mid Cap | Small Cap | ||||||
7.0% | 100.0% | 88.0% | 12.0% | 100.0% | 52.5% | 35.5% | 12.0% | 52.5% | 35.5% | 12.0% | 52.5% | 35.5% | 12.0% | 52.5% | 35.5% | 12.0% | ||||||
Subcategory Allocation (1) | 7.0% | 11.8% | 10.5% | 1.4% | 4.3% | 10.4% | 7.0% | 2.4% | 15.6% | 10.5% | 3.6% | 3.3% | 2.2% | 0.7% | 4.9% | 3.3% | 1.1% | 100% | ||||
Subcategory Target Amt (2) | 2,354 | 3,955 | 3,521 | 480 | 1,459 | 3,488 | 2,359 | 797 | 5,233 | 3,538 | 1,196 | 1,102 | 745 | 252 | 1,652 | 1,117 | 378 | 33,627 | ||||
Subcategory Net Change (3) | -2,106 | -1,985 | +3,521 | -1,876 | -469 | -1,551 | -380 | +797 | +1,783 | -1,282 | +1,196 | +1,102 | +745 | +252 | -1,243 | +1,117 | +378 | 0 | ||||
(1) Subcategory Allocation is calculated by multiplying the values in the investment hierarchy. Example: Target Investment for Large Cap Growth Domestic Equity = 0.525 x 0.60 x 0.76 x 0.65 = 0.15561 (shown as 15.6%) | ||||||||||||||||||||||
(2) Subcategory Target Amount is calculated by multiplying the Subcategory Allocation times the Total Investment of the Portfolio. Example: Target Amount for Large Cap Growth Domestic Equity = 0.15561 x 33,627 = 5,232.69747 (shown as 5,233) | ||||||||||||||||||||||
(3) Subcategory Net Change is calculated by subtracting the Current Amount from the Target Value. Example: Net Change for Large Cap Growth Domestic Equity = 5,232.69747 - 3,450 = 1,782.69747 (shown as +1,783) | ||||||||||||||||||||||