Account | Domestic stocks | REITs | International stocks | Bonds | Total |
---|---|---|---|---|---|
Taxable | - | - | $14,000 | - | $14,000 |
Roth IRA | - | $9,000 | $9,000 | - | $18,000 |
401(k) | $49,000 | - | - | $19,000 | $68,000 |
Total | $49,000 | $9,000 | $23,000 | $19,000 | $100,000 |
Desired | $48,000 | $8,000 | $24,000 | $20,000 | $100,000 |
Difference | ($1,000) | ($1,000) | $1,000 | $1,000 | - |
Cell | Heading | Enter | Notes |
---|---|---|---|
A2 | Shares | 100 | Enter the number of shares you have in the Collective Index Trust (CIT). As you add or subtract shares from contributions, withdrawals or exchanges, you'll need to periodically update this amount. |
B2 | Closing Price | 23.6602 | Enter the CIT's closing price. You'll need to look this up in your plan. |
C2 | Close Date | 01/03/2014 | Enter the closing date on which you got the 'Closing Price' of the CIT in B2. Make sure you enter the date and closing price are in sync, and be sure that the closing price has been updated in case there is a lag between the market close and the posting of the closing prices. |
D2 | Proxy Fund | VINIX | Enter the ticker of a fund that is similar to your CIT. |
E2 | Proxy Price | =INDEX(GoogleFinance(D2, 'close', C2); 2; 2 ) | This returns the closing price of the proxy fund you selected in D2, on the date C2, which is the same date you recorded the closing price of the CIT. |
F2 | Multiplier | =E2/B2 | This is the ratio of the Proxy Fund's Price divided by your CIT's price, on the same date. |
G2 | Proxy Fund Current Price | =GoogleFinance(D2, 'price') | The current price of your proxy fund |
H2 | CIT Approx Price | =G2/F2 | This is the approximate calculated share price of the CIT |
I2 | Balance | =H2*A2 | The approximate balance you hold in the CIT. This is the approximated price of the CIT multiplied by the number of shares you hold in the CIT. |
Date bought | Amount invested | Share price | Shares | Date sold | Share price | Amount received | Capital gain |
---|---|---|---|---|---|---|---|
2/1/08 | $5000 | $20.00 | 250.000 | 10/31/08 | $15.00 | $3750 | -$1250 |
5/1/08 | $5000 | $18.00 | 277.778 | - | - | - | - |
7/1/10 | $10000 | $30.00 | 333.333 | 2/1/11 | $33.00 | $11000 | $1000 |
|
|