FINANCE REPORT 10 pages
lion321
ppwif-arbios_xhuti.xlsxHigh PE Portfolio
| Name: | Arbios Xhuti | |||||||||||
| FIRST WEEK: | ||||||||||||
| Netflix | Amazon | |||||||||||
| Stock | Daily | Total | Stock | Daily | Total | Stock | Daily | Total | Stock | Daily | Total | |
| Date | Price | Change | Change | Price | Change | Change | Price | Change | Change | Price | Change | Change |
| 3/30/15 | $422.57 | $374.59 | $83.20 | $255.08 | ||||||||
| 3/31/15 | $416.69 | ($5.88) | ($5.88) | $372.10 | ($2.49) | ($2.49) | $82.22 | ($0.98) | ($0.98) | $250.17 | ($4.91) | ($4.91) |
| 4/1/15 | $413.12 | ($3.57) | ($9.45) | $370.26 | ($1.84) | ($4.33) | $81.67 | ($0.55) | ($1.53) | $247.89 | ($2.28) | ($7.19) |
| 4/2/15 | $414.08 | $0.96 | ($8.49) | $370.50 | $0.24 | ($4.09) | $82.25 | $0.58 | ($0.95) | $249.71 | $1.82 | ($5.37) |
| 4/3/15 | $413.50 | ($0.58) | ($9.07) | $372.25 | $1.75 | ($2.34) | $81.56 | ($0.69) | ($1.64) | $248.82 | ($0.89) | ($6.26) |
| Weekly Gain/Loss: | ($1,360.50) | Weekly Gain/Loss: | ($117.00) | Weekly Gain/Loss: | ($165.64) | Weekly Gain/Loss: | ($231.62) | |||||
| Weekly Transaction Summary | ||||||||||||
| Transaction Fee for Purchase: | $0.05 | Transaction Fee forSales: | $0.10 | |||||||||
| SHARES | PURCHSING | SHARES | SELLING | |||||||||
| BUY | PRICE DR KISEOK NAM: Monday price | TOTAL DR KISEOK NAM: Price*Shares | FEE DR KISEOK NAM: Shares*$0.05 | HOLD | SELL DR KISEOK NAM: Buying Shares-Holding Shares | PRICE DR KISEOK NAM: Use IF command: If zero shares are sold, do nothing, otherwise, put Friday price. | TOTAL DR KISEOK NAM: Use IF command: If zero shares are sold, do nothing, otherwise, Friday price*Shares. | FEE DR KISEOK NAM: Use IF command: If zero shares are sold, do nothing, otherwise, Shares*$0.10. |
||||
| Netflix | 150 | $422.57 | $63,385.50 | $7.50 | 150 | 0 | ||||||
| Amazon | 50 | $374.59 | $18,729.50 | $2.50 | 50 | 0 | ||||||
| 101 | $83.20 | $8,403.20 | $5.05 | 101 | 0 | |||||||
| 37 | $255.08 | $9,437.96 | $1.85 | 37 | 0 | |||||||
| Total Fee: | $16.90 DR KISEOK NAM: Sum of fees | Total Fee: | $0.00 DR KISEOK NAM: Sum of Fees |
|||||||||
| Total Purchase: | $99,956 DR KISEOK NAM: Sum of purchases | Total Sales | $0 DR KISEOK NAM: Sum of Sales |
|||||||||
| TOTAL PURCHASE: Week 1 | $99,973 DR KISEOK NAM: Use IF Command: if The sum of total purchase and total fee exceeds $100,000, then put "Oh-No!", otherwise, put the sum. | Terminal Value of Portfolio: Week 1 | $98,081 DR KISEOK NAM: SUM of Shares*Friday Price |
|||||||||
| Excess Money DR KISEOK NAM: Make it less than $100 | $27 | |||||||||||
| Weekly Capital Gain/Loss: | ($1,875) DR KISEOK NAM: Sum of Capital Gain/Loss | Week 1 Total Fees: | $16.90 | |||||||||
| Weekly Rate of Return: | -1.8922% | Money Available for Week 2 Investment: | $27 DR KISEOK NAM: Total Sales-Total Fees+Excess Money |
|||||||||
| SECOND WEEK: | ||||||||||||
| Netflix | Amazon | J. C. Penney Company | ||||||||||
| Stock | Daily | Total | Stock | Daily | Total | Stock | Daily | Total | Stock | Daily | Total | |
| Date | Price | Change | Change | Price | Change | Change | Price | Change | Change | Price | Change | Change |
| 4/6/15 | $422.53 | $9.03 | $9.03 | $377.28 | $5.03 | $5.03 | $9.29 | $249.27 | $0.45 | $0.45 | ||
| 4/7/15 | $423.46 | $0.93 | $0.93 | $374.41 | ($2.87) | ($2.87) | $8.89 | ($0.40) | ($0.40) | $249.80 | $0.53 | $0.53 |
| 4/8/15 | $441.47 | $18.01 | $18.94 | $381.10 | $6.69 | $3.82 | $9.07 | $0.18 | ($0.22) | $252.09 | $2.29 | $2.82 |
| 4/9/15 | $439.50 | ($1.97) | $16.97 | $383.54 | $2.44 | $6.26 | $9.20 | $0.13 | ($0.09) | $256.34 | $4.25 | $7.07 |
| 4/10/15 | $454.57 | $15.07 | $32.04 | $382.65 | ($0.89) | $5.37 | $9.22 | $0.02 | ($0.07) | $265.35 | $9.01 | $16.08 |
| Weekly Gain/Loss: | $6,160.50 | Weekly Gain/Loss: | $468.00 | Weekly Gain/Loss: | ($0.14) | Weekly Gain/Loss: | $611.61 | |||||
| Weekly Transaction Summary | ||||||||||||
| Transaction Fee for Purchase: | $0.05 | Transaction Fee forSales: | $0.10 | |||||||||
| OLD | SHARES | PURCHSING | SHARES | SELLING | ||||||||
| HOLD | BUY | PRICE | TOTAL | FEE | HOLD | SELL | PRICE | TOTAL | FEE | |||
| Netflix | 150 | 0 | 100 | 50 | $454.57 | $22,728.50 | $5.00 | |||||
| Amazon | 45 | 0 | 40 | 5 | $382.65 | $1,913.25 | $0.50 | |||||
| J. C. Penney Company | 0 | 2 | $9.29 | $18.58 | $0.10 | 2 | 0 | |||||
| 37 | 0 | 37 | 0 | |||||||||
| Total Fee: | $0.10 | Total Fee: | $5.50 | |||||||||
| Money Available: | $27 | Total Purchase: | $19 | Total Sales | $24,642 | |||||||
| TOTAL PURCHASE: Week 2 | $19 DR KISEOK NAM: Use IF Command: if The sum of total purchase and total fee exceeds Money available, then put "Oh-No!", otherwise, put the sum. |
|||||||||||
| Excess Money | $8 | |||||||||||
| Initial Value of Portfolio: Week 2 | $89,599 DR KISEOK NAM: Sum of: (Old Shares + Shares buy)*Monday Price | Terminal Value of Portfolio: Week 2 | $95,241 | |||||||||
| Weekly Capital Gain/Loss: | $7,239.97 | Week 2 Total Fee: | $5.60 | |||||||||
| Weekly Rate of Return: | 8.0742% DR KISEOK NAM: (Gain or Loss-All Fees)/E78 | Two-Week Total Fee: | $22.50 | |||||||||
| Two-Week Capital Gain/Loss: | $5,365.21 | |||||||||||
| Two-Week Rate of Return: | 5.3441% DR KISEOK NAM: (Two weeks total gain or loss-two weeks fees)/E32 | Money Available for Week 3 Investment | $24,645 | |||||||||
| THIRD WEEK: | ||||||||||||
| Netflix | Amazon | J. C. Penney Company | ||||||||||
| Stock | Daily | Total | Stock | Daily | Total | Stock | Daily | Total | Stock | Daily | Total | |
| Date | Price | Change | Change | Price | Change | Change | Price | Change | Change | Price | Change | Change |
| 4/13/15 | $477.75 | $23.18 | $23.18 | $381.89 | ($0.76) | ($0.76) | $9.38 | $0.16 | $0.16 | $263.75 | ($1.60) | ($1.60) |
| 4/14/15 | $478.71 | $0.96 | $0.96 | $385.11 | $3.22 | $3.22 | $9.15 | ($0.23) | ($0.23) | $257.49 | ($6.26) | ($6.26) |
| 4/15/15 | $475.46 | ($3.25) | ($2.29) | $383.43 | ($1.68) | $1.54 | $8.93 | ($0.22) | ($0.45) | $257.11 | ($0.38) | ($6.64) |
| 4/16/15 | $562.06 | $86.60 | $84.31 | $386.04 | $2.61 | $4.15 | $8.69 | ($0.24) | ($0.69) | $256.98 | ($0.13) | ($6.77) |
| 4/17/15 | $571.55 | $9.49 | $93.80 | $375.06 | ($10.98) | ($6.83) | $8.71 | $0.02 | ($0.67) | $253.74 | ($3.24) | ($10.01) |
| Weekly Gain/Loss: | $0.00 | Weekly Gain/Loss: | $0.00 | Weekly Gain/Loss: | $0.00 | Weekly Gain/Loss: | $0.00 | |||||
| Weekly Transaction Summary | ||||||||||||
| Transaction Fee for Purchase: | $0.05 | Transaction Fee forSales: | $0.10 | |||||||||
| OLD | SHARES | PURCHSING | SHARES | SELLING | ||||||||
| HOLD | BUY | PRICE | TOTAL | FEE | HOLD | SELL | PRICE | TOTAL | FEE | |||
| Netflix | 0 | 0 | 0 | 0 | $571.55 | $0.00 | $0.00 | |||||
| Amazon | 0 | 0 | 0 | 0 | $375.06 | $0.00 | $0.00 | |||||
| J. C. Penney Company | 0 | 0 | 0 | 0 | $8.71 | $0.00 | $0.00 | |||||
| 0 | 0 | 0 | 0 | $253.74 | $0.00 | $0.00 | ||||||
| Total Fee: | $0 | Total Fee: | $0 | |||||||||
| Money Available: | $24,645 | Total Purchase: | $0 | Total Sales | $0 | |||||||
| TOTAL PURCHASE: Week 3 | $0 | |||||||||||
| Excess Money | $24,645 | |||||||||||
| Initial Value of Portfolio: Week 3 | $0 | Terminal Value of Portfolio: Week 2 | $24,645 | |||||||||
| Weekly Capital Gain/Loss: | $0.00 | Week3 Total Fee: | $0.00 | |||||||||
| Weekly Rate of Return: | ERROR:#DIV/0! | |||||||||||
| Three-Week Capital Gain/Loss: | $5,365.21 | Three-Week Total Fees: | $22.50 | |||||||||
| Three-Week Rate of Return: | 29.9872% DR KISEOK NAM: Don't forget the Excess Money |
|||||||||||
Low PE Portfolio
| Name: | Arbios Xhuti | |||||||||||
| FIRST WEEK: | ||||||||||||
| Goldman Sachs | American Realty Investors | Lihua | Vodafone | |||||||||
| Stock | Daily | Total | Stock | Daily | Total | Stock | Daily | Total | Stock | Daily | Total | |
| Date | Price | Change | Change | Price | Change | Change | Price | Change | Change | Price | Change | Change |
| 3/30/15 | $190.91 | $5.17 | $0.01 | $33.22 | ||||||||
| 3/31/15 | $188.15 | ($2.76) | ($2.76) | $5.39 | $0.22 | $0.22 | $0.01 | $0.00 | $0.00 | $32.68 | ($0.54) | ($0.54) |
| 4/1/15 | $192.26 | $4.11 | $1.35 | $5.50 | $0.11 | $0.33 | $0.01 | $0.00 | $0.00 | $32.71 | $0.03 | ($0.51) |
| 4/2/15 | $191.73 | ($0.53) | $0.82 | $5.41 | ($0.09) | $0.24 | $0.01 | $0.00 | $0.00 | $32.72 | $0.01 | ($0.50) |
| 4/3/15 | $191.55 | ($0.18) | $0.64 | $5.27 | ($0.14) | $0.10 | $0.02 | $0.01 | $0.01 | $32.89 | $0.17 | ($0.33) |
| Weekly Gain/Loss: | $288.00 | Weekly Gain/Loss: | $12.00 | Weekly Gain/Loss: | $16.00 | Weekly Gain/Loss: | ($132.33) | |||||
| Weekly Transaction Summary | ||||||||||||
| Transaction Fee for Purchase: | $0.05 | Transaction Fee forSales: | $0.10 | |||||||||
| SHARES | PURCHSING | SHARES | SELLING | |||||||||
| BUY | PRICE DR KISEOK NAM: Monday price | TOTAL DR KISEOK NAM: Price*Shares | FEE DR KISEOK NAM: Shares*$0.05 | HOLD | SELL DR KISEOK NAM: Buying Shares-Holding Shares | PRICE DR KISEOK NAM: Use IF command: If zero shares are sold, do nothing, otherwise, put Friday price. | TOTAL DR KISEOK NAM: Use IF command: If zero shares are sold, do nothing, otherwise, Friday price*Shares. | FEE DR KISEOK NAM: Use IF command: If zero shares are sold, do nothing, otherwise, Shares*$0.10. |
||||
| Goldman Sachs | 450 | $190.91 | $85,909.50 | $22.50 | 450 | 0 | ||||||
| American Realty Investors | 120 | $5.17 | $620.40 | $6.00 | 120 | 0 | ||||||
| Lihua | 1600 | $0.01 | $16.00 | $80.00 | 1600 | 0 | ||||||
| Vodafone | 401 | $33.22 | $13,321.22 | $20.05 | 401 | 0 | ||||||
| Total Fee: | $128.55 DR KISEOK NAM: Sum of fees | Total Fee: | $0.00 DR KISEOK NAM: Sum of Fees |
|||||||||
| Total Purchase: | $99,867 DR KISEOK NAM: Sum of purchases | Total Sales | $0 DR KISEOK NAM: Sum of Sales |
|||||||||
| TOTAL PURCHASE: Week 1 | $99,996 DR KISEOK NAM: Use IF Command: if The sum of total purchase and total fee exceeds $100,000, then put "Oh-No!", otherwise, put the sum. | Terminal Value of Portfolio: Week 1 | $100,051 DR KISEOK NAM: SUM of Shares*Friday Price |
|||||||||
| Excess Money DR KISEOK NAM: Make it less than $100 | $4 | |||||||||||
| Weekly Capital Gain/Loss: | $184 DR KISEOK NAM: Sum of Capital Gain/Loss | Week 1 Total Fees: | $128.55 | |||||||||
| Weekly Rate of Return: | 0.0551% | Money Available for Week 2 Investment: | $4 DR KISEOK NAM: Total Sales-Total Fees+Excess Money |
|||||||||
| SECOND WEEK: | ||||||||||||
| Goldman Sachs | Goodyear Tire & Rubber Co. | Lihua | Vodafone | |||||||||
| Stock | Daily | Total | Stock | Daily | Total | Stock | Daily | Total | Stock | Daily | Total | |
| Date | Price | Change | Change | Price | Change | Change | Price | Change | Change | Price | Change | Change |
| 4/6/15 | $192.02 | $0.47 | $0.47 | $27.30 | $0.01 | ($0.01) | ($0.01) | $33.03 | $0.14 | $0.14 | ||
| 4/7/15 | $192.40 | $0.38 | $0.38 | $27.00 | ($0.30) | ($0.30) | $0.01 | $0.00 | $0.00 | $33.17 | $0.14 | $0.14 |
| 4/8/15 | $192.49 | $0.09 | $0.47 | $27.42 | $0.42 | $0.12 | $0.01 | $0.00 | $0.00 | $33.20 | $0.03 | $0.17 |
| 4/9/15 | $194.93 | $2.44 | $2.91 | $27.72 | $0.30 | $0.42 | $0.01 | $0.00 | $0.00 | $33.22 | $0.02 | $0.19 |
| 4/10/15 | $195.64 | $0.71 | $3.62 | $27.71 | ($0.01) | $0.41 | $0.01 | $0.00 | $0.00 | $33.53 | $0.31 | $0.50 |
| Weekly Gain/Loss: | $1,840.50 | Weekly Gain/Loss: | $0.00 | Weekly Gain/Loss: | ($16.00) | Weekly Gain/Loss: | $256.64 | |||||
| Weekly Transaction Summary | ||||||||||||
| Transaction Fee for Purchase: | $0.05 | Transaction Fee forSales: | $0.10 | |||||||||
| OLD | SHARES | PURCHSING | SHARES | SELLING | ||||||||
| HOLD | BUY | PRICE | TOTAL | FEE | HOLD | SELL | PRICE | TOTAL | FEE | |||
| Goldman Sachs | 450 | 0 | 400 | 50 | $195.64 | $9,782.00 | $5.00 | |||||
| Goodyear Tire & Rubber Co. | 0 | 0 | 0 | 0 | ||||||||
| Lihua | 1600 | 0 | 1600 | 0 | ||||||||
| Vodafone | 401 | 0 | 399 | 2 | $33.53 | $67.06 | $0.20 | |||||
| Total Fee: | $0.00 | Total Fee: | $5.20 | |||||||||
| Money Available: | $4 | Total Purchase: | $0 | Total Sales | $9,849 | |||||||
| TOTAL PURCHASE: Week 2 | $0 DR KISEOK NAM: Use IF Command: if The sum of total purchase and total fee exceeds Money available, then put "Oh-No!", otherwise, put the sum. |
|||||||||||
| Excess Money | $4 | |||||||||||
| Initial Value of Portfolio: Week 2 | $99,670 DR KISEOK NAM: Sum of: (Old Shares + Shares buy)*Monday Price | Terminal Value of Portfolio: Week 2 | $101,500 | |||||||||
| Weekly Capital Gain/Loss: | $2,081.14 | Week 2 Total Fee: | $5.20 | |||||||||
| Weekly Rate of Return: | 2.0828% DR KISEOK NAM: (Gain or Loss-All Fees)/E78 | Two-Week Total Fee: | $133.75 | |||||||||
| Two-Week Capital Gain/Loss: | $2,264.81 | |||||||||||
| Two-Week Rate of Return: | 2.1312% DR KISEOK NAM: (Two weeks total gain or loss-two weeks fees)/E32 | Money Available for Week 3 Investment | $9,848 | |||||||||
| THIRD WEEK: | ||||||||||||
| Goldman Sachs | Goodyear Tire & Rubber Co. | Lihua | Vodafone | |||||||||
| Stock | Daily | Total | Stock | Daily | Total | Stock | Daily | Total | Stock | Daily | Total | |
| Date | Price | Change | Change | Price | Change | Change | Price | Change | Change | Price | Change | Change |
| 4/13/15 | $196.05 | $0.41 | $0.41 | $27.66 | ($0.05) | ($0.05) | $0.01 | $0.00 | $0.00 | $33.46 | ($0.07) | ($0.07) |
| 4/14/15 | $197.74 | $1.69 | $1.69 | $27.16 | ($0.50) | ($0.50) | $0.01 | $0.00 | $0.00 | $33.94 | $0.48 | $0.48 |
| 4/15/15 | $201.65 | $3.91 | $5.60 | $27.26 | $0.10 | ($0.40) | $0.01 | $0.00 | $0.00 | $33.81 | ($0.13) | $0.35 |
| 4/16/15 | $200.36 | ($1.29) | $4.31 | $27.06 | ($0.20) | ($0.60) | $0.01 | $0.00 | $0.00 | $33.96 | $0.15 | $0.50 |
| 4/17/15 | $197.17 | ($3.19) | $1.12 | $27.23 | $0.17 | ($0.43) | $0.01 | $0.00 | $0.00 | $33.89 | ($0.07) | $0.43 |
| Weekly Gain/Loss: | $0.00 | Weekly Gain/Loss: | $0.00 | Weekly Gain/Loss: | $0.00 | Weekly Gain/Loss: | $0.00 | |||||
| Weekly Transaction Summary | ||||||||||||
| Transaction Fee for Purchase: | $0.05 | Transaction Fee forSales: | $0.10 | |||||||||
| OLD | SHARES | PURCHSING | SHARES | SELLING | ||||||||
| HOLD | BUY | PRICE | TOTAL | FEE | HOLD | SELL | PRICE | TOTAL | FEE | |||
| Goldman Sachs | 0 | 0 | 0 | 0 | $197.17 | $0.00 | $0.00 | |||||
| Goodyear Tire & Rubber Co. | 0 | 0 | 0 | 0 | $27.23 | $0.00 | $0.00 | |||||
| Lihua | 0 | 0 | 0 | 0 | $0.01 | $0.00 | $0.00 | |||||
| Vodafone | 0 | 0 | 0 | 0 | $33.89 | $0.00 | $0.00 | |||||
| Total Fee: | $0 | Total Fee: | $0 | |||||||||
| Money Available: | $9,848 | Total Purchase: | $0 | Total Sales | $0 | |||||||
| TOTAL PURCHASE: Week 3 | $0 | |||||||||||
| Excess Money | $9,848 | |||||||||||
| Initial Value of Portfolio: Week 3 | $0 | Terminal Value of Portfolio: Week 2 | $9,848 | |||||||||
| Weekly Capital Gain/Loss: | $0.00 | Week3 Total Fee: | $0.00 | |||||||||
| Weekly Rate of Return: | ERROR:#DIV/0! | |||||||||||
| Three-Week Capital Gain/Loss: | $2,264.81 | Three-Week Total Fees: | $133.75 | |||||||||
| Three-Week Rate of Return: | 11.9793% DR KISEOK NAM: Don't forget the Excess Money |
|||||||||||
Growth Portfolio
| Name: | Arbios Xhuti | |||||||||||
| FIRST WEEK: | ||||||||||||
| Starbucks | McDonald’s | AT&T | ||||||||||
| Stock | Daily | Total | Stock | Daily | Total | Stock | Daily | Total | Stock | Daily | Total | |
| Date | Price | Change | Change | Price | Change | Change | Price | Change | Change | Price | Change | Change |
| 3/30/15 | $95.98 | $97.87 | $32.99 | $552.03 | ||||||||
| 3/31/15 | $94.70 | ($1.28) | ($1.28) | $97.49 | ($0.38) | ($0.38) | $32.66 | ($0.33) | ($0.33) | $548.00 | ($4.03) | ($4.03) |
| 4/1/15 | $92.76 | ($1.94) | ($3.22) | $96.34 | ($1.15) | ($1.53) | $32.88 | $0.22 | ($0.11) | $542.26 | ($5.74) | ($9.77) |
| 4/2/15 | $93.42 | $0.66 | ($2.56) | $95.96 | ($0.38) | ($1.91) | $32.90 | $0.02 | ($0.09) | $540.85 | ($1.41) | ($11.18) |
| 4/3/15 | $94.39 | $0.97 | ($1.59) | $95.83 | ($0.13) | ($2.04) | $33.13 | $0.23 | $0.14 | $535.53 | ($5.32) | ($16.50) |
| Weekly Gain/Loss: | ($246.45) | Weekly Gain/Loss: | ($408.00) | Weekly Gain/Loss: | $29.68 | Weekly Gain/Loss: | ($1,749.00) | |||||
| Weekly Transaction Summary | ||||||||||||
| Transaction Fee for Purchase: | $0.05 | Transaction Fee forSales: | $0.10 | |||||||||
| SHARES | PURCHSING | SHARES | SELLING | |||||||||
| BUY | PRICE DR KISEOK NAM: Monday price | TOTAL DR KISEOK NAM: Price*Shares | FEE DR KISEOK NAM: Shares*$0.05 | HOLD | SELL DR KISEOK NAM: Buying Shares-Holding Shares | PRICE DR KISEOK NAM: Use IF command: If zero shares are sold, do nothing, otherwise, put Friday price. | TOTAL DR KISEOK NAM: Use IF command: If zero shares are sold, do nothing, otherwise, Friday price*Shares. | FEE DR KISEOK NAM: Use IF command: If zero shares are sold, do nothing, otherwise, Shares*$0.10. |
||||
| Starbucks | 155 | $95.98 | $14,876.90 | $7.75 | 155 | 0 | ||||||
| McDonald’s | 200 | $97.87 | $19,574.00 | $10.00 | 200 | 0 | ||||||
| AT&T | 212 | $32.99 | $6,993.88 | $10.60 | 212 | 0 | ||||||
| 106 | $552.03 | $58,515.18 | $5.30 | 106 | 0 | |||||||
| Total Fee: | $33.65 DR KISEOK NAM: Sum of fees | Total Fee: | $0.00 DR KISEOK NAM: Sum of Fees |
|||||||||
| Total Purchase: | $99,960 DR KISEOK NAM: Sum of purchases | Total Sales | $0 DR KISEOK NAM: Sum of Sales |
|||||||||
| TOTAL PURCHASE: Week 1 | $99,994 DR KISEOK NAM: Use IF Command: if The sum of total purchase and total fee exceeds $100,000, then put "Oh-No!", otherwise, put the sum. | Terminal Value of Portfolio: Week 1 | $97,586 DR KISEOK NAM: SUM of Shares*Friday Price |
|||||||||
| Excess Money DR KISEOK NAM: Make it less than $100 | $6 | |||||||||||
| Weekly Capital Gain/Loss: | ($2,374) DR KISEOK NAM: Sum of Capital Gain/Loss | Week 1 Total Fees: | $33.65 | |||||||||
| Weekly Rate of Return: | -2.4076% | Money Available for Week 2 Investment: | $6 DR KISEOK NAM: Total Sales-Total Fees+Excess Money |
|||||||||
| SECOND WEEK: | ||||||||||||
| General Finance Corporation | McDonald’s | AT&T | ||||||||||
| Stock | Daily | Total | Stock | Daily | Total | Stock | Daily | Total | Stock | Daily | Total | |
| Date | Price | Change | Change | Price | Change | Change | Price | Change | Change | Price | Change | Change |
| 4/6/15 | $8.25 | $96.36 | $0.53 | $0.53 | $33.31 | $0.18 | $0.18 | $536.19 | $0.66 | $0.66 | ||
| 4/7/15 | $8.22 | ($0.03) | ($0.03) | $96.33 | ($0.03) | ($0.03) | $33.16 | ($0.15) | ($0.15) | $537.02 | $0.83 | $0.83 |
| 4/8/15 | $8.16 | ($0.06) | ($0.09) | $96.82 | $0.49 | $0.46 | $32.65 | ($0.51) | ($0.66) | $541.32 | $4.30 | $5.13 |
| 4/9/15 | $7.92 | ($0.24) | ($0.33) | $96.54 | ($0.28) | $0.18 | $32.70 | $0.05 | ($0.61) | $540.15 | ($1.17) | $3.96 |
| 4/10/15 | $7.73 | ($0.19) | ($0.52) | $97.80 | $1.26 | $1.44 | $32.77 | $0.07 | ($0.54) | $540.01 | ($0.14) | $3.82 |
| Weekly Gain/Loss: | $0.00 | Weekly Gain/Loss: | $394.00 | Weekly Gain/Loss: | ($76.32) | Weekly Gain/Loss: | $474.88 | |||||
| Weekly Transaction Summary | ||||||||||||
| Transaction Fee for Purchase: | $0.05 | Transaction Fee forSales: | $0.10 | |||||||||
| OLD | SHARES | PURCHSING | SHARES | SELLING | ||||||||
| HOLD | BUY | PRICE | TOTAL | FEE | HOLD | SELL | PRICE | TOTAL | FEE | |||
| General Finance Corporation | 0 | 0 | 0 | 0 | ||||||||
| McDonald’s | 200 | 0 | 180 | 20 | $97.80 | $1,956.00 | $2.00 | |||||
| AT&T | 212 | 0 | 200 | 12 | $32.77 | $393.24 | $1.20 | |||||
| 106 | 0 | 100 | 6 | $540.01 | $3,240.06 | $0.60 | ||||||
| Total Fee: | $0.00 | Total Fee: | $3.80 | |||||||||
| Money Available: | $6 | Total Purchase: | $0 | Total Sales | $5,589 | |||||||
| TOTAL PURCHASE: Week 2 | $0 DR KISEOK NAM: Use IF Command: if The sum of total purchase and total fee exceeds Money available, then put "Oh-No!", otherwise, put the sum. |
|||||||||||
| Excess Money | $6 | |||||||||||
| Initial Value of Portfolio: Week 2 | $83,170 DR KISEOK NAM: Sum of: (Old Shares + Shares buy)*Monday Price | Terminal Value of Portfolio: Week 2 | $83,748 | |||||||||
| Weekly Capital Gain/Loss: | $792.56 | Week 2 Total Fee: | $3.80 | |||||||||
| Weekly Rate of Return: | 0.9484% DR KISEOK NAM: (Gain or Loss-All Fees)/E78 | Two-Week Total Fee: | $37.45 | |||||||||
| Two-Week Capital Gain/Loss: | ($1,581.21) | |||||||||||
| Two-Week Rate of Return: | -1.6188% DR KISEOK NAM: (Two weeks total gain or loss-two weeks fees)/E32 | Money Available for Week 3 Investment | $5,592 | |||||||||
| THIRD WEEK: | ||||||||||||
| General Finance Corporation | McDonald’s | AT&T | ||||||||||
| Stock | Daily | Total | Stock | Daily | Total | Stock | Daily | Total | Stock | Daily | Total | |
| Date | Price | Change | Change | Price | Change | Change | Price | Change | Change | Price | Change | Change |
| 4/13/15 | $7.78 | $0.05 | $0.05 | $97.54 | ($0.26) | ($0.26) | $33.01 | $0.24 | $0.24 | $541.35 | $1.34 | $1.34 |
| 4/14/15 | $7.64 | ($0.14) | ($0.14) | $97.57 | $0.03 | $0.03 | $32.68 | ($0.33) | ($0.33) | $530.39 | ($10.96) | ($10.96) |
| 4/15/15 | $7.96 | $0.32 | $0.18 | $96.41 | ($1.16) | ($1.13) | $32.87 | $0.19 | ($0.14) | $532.53 | $2.14 | ($8.82) |
| 4/16/15 | $7.84 | ($0.12) | $0.06 | $95.64 | ($0.77) | ($1.90) | $32.76 | ($0.11) | ($0.25) | $533.80 | $1.27 | ($7.55) |
| 4/17/15 | $7.85 | $0.01 | $0.07 | $94.89 | ($0.75) | ($2.65) | $32.50 | ($0.26) | ($0.51) | $524.05 | ($9.75) | ($17.30) |
| Weekly Gain/Loss: | $0.00 | Weekly Gain/Loss: | $0.00 | Weekly Gain/Loss: | $0.00 | Weekly Gain/Loss: | $0.00 | |||||
| Weekly Transaction Summary | ||||||||||||
| Transaction Fee for Purchase: | $0.05 | Transaction Fee forSales: | $0.10 | |||||||||
| OLD | SHARES | PURCHSING | SHARES | SELLING | ||||||||
| HOLD | BUY | PRICE | TOTAL | FEE | HOLD | SELL | PRICE | TOTAL | FEE | |||
| General Finance Corporation | 0 | 0 | 0 | 0 | $7.85 | $0.00 | $0.00 | |||||
| McDonald’s | 0 | 0 | 0 | 0 | $94.89 | $0.00 | $0.00 | |||||
| AT&T | 0 | 0 | 0 | 0 | $32.50 | $0.00 | $0.00 | |||||
| 0 | 0 | 0 | 0 | $524.05 | $0.00 | $0.00 | ||||||
| Total Fee: | $0 | Total Fee: | $0 | |||||||||
| Money Available: | $5,592 | Total Purchase: | $0 | Total Sales | $0 | |||||||
| TOTAL PURCHASE: Week 3 | $0 | |||||||||||
| Excess Money | $5,592 | |||||||||||
| Initial Value of Portfolio: Week 3 | $0 | Terminal Value of Portfolio: Week 2 | $5,592 | |||||||||
| Weekly Capital Gain/Loss: | $0.00 | Week3 Total Fee: | $0.00 | |||||||||
| Weekly Rate of Return: | ERROR:#DIV/0! | |||||||||||
| Three-Week Capital Gain/Loss: | ($1,581.21) | Three-Week Total Fees: | $37.45 | |||||||||
| Three-Week Rate of Return: | 3.9732% DR KISEOK NAM: Don't forget the Excess Money |
|||||||||||
Value Portfolio
| Name: | Arbios Xhuti | |||||||||||
| FIRST WEEK: | ||||||||||||
| AnnTaylor | Cincinnati Bell | Macy's | Walter Industries | |||||||||
| Stock | Daily | Total | Stock | Daily | Total | Stock | Daily | Total | Stock | Daily | Total | |
| Date | Price | Change | Change | Price | Change | Change | Price | Change | Change | Price | Change | Change |
| 3/30/15 | $41.15 | $3.60 | $64.43 | $0.74 | ||||||||
| 3/31/15 | $41.04 | ($0.11) | ($0.11) | $3.51 | ($0.09) | ($0.09) | $64.88 | $0.45 | $0.45 | $0.64 | ($0.10) | ($0.10) |
| 4/1/15 | $40.64 | ($0.40) | ($0.51) | $3.64 | $0.13 | $0.04 | $65.45 | $0.57 | $1.02 | $0.64 | $0.00 | ($0.10) |
| 4/2/15 | $40.87 | $0.23 | ($0.28) | $3.64 | $0.00 | $0.04 | $65.52 | $0.07 | $1.09 | $0.67 | $0.03 | ($0.07) |
| 4/3/15 | $40.89 | $0.02 | ($0.26) | $3.68 | $0.04 | $0.08 | $67.85 | $2.33 | $3.42 | $0.69 | $0.02 | ($0.05) |
| Weekly Gain/Loss: | ($260.00) | Weekly Gain/Loss: | $800.00 | Weekly Gain/Loss: | $1,111.50 | Weekly Gain/Loss: | ($85.00) | |||||
| Weekly Transaction Summary | ||||||||||||
| Transaction Fee for Purchase: | $0.05 | Transaction Fee forSales: | $0.10 | |||||||||
| SHARES | PURCHSING | SHARES | SELLING | |||||||||
| BUY | PRICE DR KISEOK NAM: Monday price | TOTAL DR KISEOK NAM: Price*Shares | FEE DR KISEOK NAM: Shares*$0.05 | HOLD | SELL DR KISEOK NAM: Buying Shares-Holding Shares | PRICE DR KISEOK NAM: Use IF command: If zero shares are sold, do nothing, otherwise, put Friday price. | TOTAL DR KISEOK NAM: Use IF command: If zero shares are sold, do nothing, otherwise, Friday price*Shares. | FEE DR KISEOK NAM: Use IF command: If zero shares are sold, do nothing, otherwise, Shares*$0.10. |
||||
| AnnTaylor | 1000 | $41.15 | $41,150.00 | $50.00 | 1000 | 0 | ||||||
| Cincinnati Bell | 10000 | $3.60 | $36,000.00 | $500.00 | 10000 | 0 | ||||||
| Macy's | 325 | $64.43 | $20,939.75 | $16.25 | 325 | 0 | ||||||
| Walter Industries | 1700 | $0.74 | $1,258.00 | $85.00 | 1700 | 0 | ||||||
| Total Fee: | $651.25 DR KISEOK NAM: Sum of fees | Total Fee: | $0.00 DR KISEOK NAM: Sum of Fees |
|||||||||
| Total Purchase: | $99,348 DR KISEOK NAM: Sum of purchases | Total Sales | $0 DR KISEOK NAM: Sum of Sales |
|||||||||
| TOTAL PURCHASE: Week 1 | $99,999 DR KISEOK NAM: Use IF Command: if The sum of total purchase and total fee exceeds $100,000, then put "Oh-No!", otherwise, put the sum. | Terminal Value of Portfolio: Week 1 | $100,914 DR KISEOK NAM: SUM of Shares*Friday Price |
|||||||||
| Excess Money DR KISEOK NAM: Make it less than $100 | $1 | |||||||||||
| Weekly Capital Gain/Loss: | $1,567 DR KISEOK NAM: Sum of Capital Gain/Loss | Week 1 Total Fees: | $651.25 | |||||||||
| Weekly Rate of Return: | 0.9153% | Money Available for Week 2 Investment: | $1 DR KISEOK NAM: Total Sales-Total Fees+Excess Money |
|||||||||
| SECOND WEEK: | ||||||||||||
| AnnTaylor | T. Rowe Price Value | Macy's | Walter Industries | |||||||||
| Stock | Daily | Total | Stock | Daily | Total | Stock | Daily | Total | Stock | Daily | Total | |
| Date | Price | Change | Change | Price | Change | Change | Price | Change | Change | Price | Change | Change |
| 4/6/15 | $40.29 | ($0.60) | ($0.60) | $82.14 | $68.16 | $0.31 | $0.31 | $0.73 | $0.04 | $0.04 | ||
| 4/7/15 | $40.16 | ($0.13) | ($0.13) | $79.05 | ($3.09) | ($3.09) | $68.07 | ($0.09) | ($0.09) | $0.71 | ($0.02) | ($0.02) |
| 4/8/15 | $40.15 | ($0.01) | ($0.14) | $80.58 | $1.53 | ($1.56) | $69.81 | $1.74 | $1.65 | $0.70 | ($0.01) | ($0.03) |
| 4/9/15 | $39.63 | ($0.52) | ($0.66) | $81.70 | $1.12 | ($0.44) | $68.00 | ($1.81) | ($0.16) | $0.70 | $0.00 | ($0.03) |
| 4/10/15 | $39.83 | $0.20 | ($0.46) | $80.98 | ($0.72) | ($1.16) | $69.16 | $1.16 | $1.00 | $0.62 | ($0.08) | ($0.11) |
| Weekly Gain/Loss: | ($1,060.00) | Weekly Gain/Loss: | $0.00 | Weekly Gain/Loss: | $425.75 | Weekly Gain/Loss: | ($119.00) | |||||
| Weekly Transaction Summary | ||||||||||||
| Transaction Fee for Purchase: | $0.05 | Transaction Fee forSales: | $0.10 | |||||||||
| OLD | SHARES | PURCHSING | SHARES | SELLING | ||||||||
| HOLD | BUY | PRICE | TOTAL | FEE | HOLD | SELL | PRICE | TOTAL | FEE | |||
| AnnTaylor | 1000 | 0 | 1000 | 0 | ||||||||
| T. Rowe Price Value | 0 | 0 | 0 | 0 | ||||||||
| Macy's | 325 | 0 | 325 | 0 | ||||||||
| Walter Industries | 1700 | 0 | 1700 | 0 | ||||||||
| Total Fee: | $0.00 | Total Fee: | $0.00 | |||||||||
| Money Available: | $1 | Total Purchase: | $0 | Total Sales | $0 | |||||||
| TOTAL PURCHASE: Week 2 | $0 DR KISEOK NAM: Use IF Command: if The sum of total purchase and total fee exceeds Money available, then put "Oh-No!", otherwise, put the sum. |
|||||||||||
| Excess Money | $1 | |||||||||||
| Initial Value of Portfolio: Week 2 | $63,683 DR KISEOK NAM: Sum of: (Old Shares + Shares buy)*Monday Price | Terminal Value of Portfolio: Week 2 | $63,361 | |||||||||
| Weekly Capital Gain/Loss: | ($753.25) | Week 2 Total Fee: | $0.00 | |||||||||
| Weekly Rate of Return: | -1.1828% DR KISEOK NAM: (Gain or Loss-All Fees)/E78 | Two-Week Total Fee: | $651.25 | |||||||||
| Two-Week Capital Gain/Loss: | $813.25 | |||||||||||
| Two-Week Rate of Return: | 0.1620% DR KISEOK NAM: (Two weeks total gain or loss-two weeks fees)/E32 | Money Available for Week 3 Investment | $1 | |||||||||
| THIRD WEEK: | ||||||||||||
| AnnTaylor | T. Rowe Price Value | Macy's | Walter Industries | |||||||||
| Stock | Daily | Total | Stock | Daily | Total | Stock | Daily | Total | Stock | Daily | Total | |
| Date | Price | Change | Change | Price | Change | Change | Price | Change | Change | Price | Change | Change |
| 4/13/15 | $40.13 | $0.30 | $0.30 | $81.72 | $0.74 | $0.74 | $69.17 | $0.01 | $0.01 | $0.69 | $0.07 | $0.07 |
| 4/14/15 | $39.25 | ($0.88) | ($0.88) | $82.07 | $0.35 | $0.35 | $68.02 | ($1.15) | ($1.15) | $0.65 | ($0.04) | ($0.04) |
| 4/15/15 | $39.30 | $0.05 | ($0.83) | $82.97 | $0.90 | $1.25 | $69.70 | $1.68 | $0.53 | $0.64 | ($0.01) | ($0.05) |
| 4/16/15 | $38.50 | ($0.80) | ($1.63) | $83.06 | $0.09 | $1.34 | $67.66 | ($2.04) | ($1.51) | $0.63 | ($0.01) | ($0.06) |
| 4/17/15 | $38.11 | ($0.39) | ($2.02) | $82.10 | ($0.96) | $0.38 | $66.47 | ($1.19) | ($2.70) | $0.63 | $0.00 | ($0.06) |
| Weekly Gain/Loss: | $0.00 | Weekly Gain/Loss: | $0.00 | Weekly Gain/Loss: | $0.00 | Weekly Gain/Loss: | $0.00 | |||||
| Weekly Transaction Summary | ||||||||||||
| Transaction Fee for Purchase: | $0.05 | Transaction Fee forSales: | $0.10 | |||||||||
| OLD | SHARES | PURCHSING | SHARES | SELLING | ||||||||
| HOLD | BUY | PRICE | TOTAL | FEE | HOLD | SELL | PRICE | TOTAL | FEE | |||
| AnnTaylor | 0 | 0 | 0 | 0 | $38.11 | $0.00 | $0.00 | |||||
| T. Rowe Price Value | 0 | 0 | 0 | 0 | $82.10 | $0.00 | $0.00 | |||||
| Macy's | 0 | 0 | 0 | 0 | $66.47 | $0.00 | $0.00 | |||||
| Walter Industries | 0 | 0 | 0 | 0 | $0.63 | $0.00 | $0.00 | |||||
| Total Fee: | $0 | Total Fee: | $0 | |||||||||
| Money Available: | $1 | Total Purchase: | $0 | Total Sales | $0 | |||||||
| TOTAL PURCHASE: Week 3 | $0 | |||||||||||
| Excess Money | $1 | |||||||||||
| Initial Value of Portfolio: Week 3 | $0 | Terminal Value of Portfolio: Week 2 | $1 | |||||||||
| Weekly Capital Gain/Loss: | $0.00 | Week3 Total Fee: | $0.00 | |||||||||
| Weekly Rate of Return: | ERROR:#DIV/0! | |||||||||||
| Three-Week Capital Gain/Loss: | $813.25 | Three-Week Total Fees: | $651.25 | |||||||||
| Three-Week Rate of Return: | 0.1630% DR KISEOK NAM: Don't forget the Excess Money |
|||||||||||
YOUR OWN PORTFOLIO
| Name: | Arbio Xhuti | |||||||||||
| FIRST WEEK: | ||||||||||||
| Vertex Pharmaceuticals Incorporated | General Motors Company | Ford Motor Company | ||||||||||
| Stock | Daily | Total | Stock | Daily | Total | Stock | Daily | Total | Stock | Daily | Total | |
| Date | Price | Change | Change | Price | Change | Change | Price | Change | Change | Price | Change | Change |
| 3/30/15 | $121.25 | $552.03 | $37.68 | $16.19 | ||||||||
| 3/31/15 | $117.97 | ($3.28) | ($3.28) | $548.00 | ($4.03) | ($4.03) | $37.50 | ($0.18) | ($0.18) | $16.15 | ($0.04) | ($0.04) |
| 4/1/15 | $116.43 | ($1.54) | ($4.82) | $542.26 | ($5.74) | ($9.77) | $36.73 | ($0.77) | ($0.95) | $15.92 | ($0.23) | ($0.27) |
| 4/2/15 | $115.85 | ($0.58) | ($5.40) | $540.85 | ($1.41) | ($11.18) | $36.61 | ($0.12) | ($1.07) | $15.93 | $0.01 | ($0.26) |
| 4/3/15 | $117.23 | $1.38 | ($4.02) | $535.53 | ($5.32) | ($16.50) | $36.50 | ($0.11) | ($1.18) | $16.03 | $0.10 | ($0.16) |
| Weekly Gain/Loss: | ($655.26) | Weekly Gain/Loss: | ($1,815.00) | Weekly Gain/Loss: | ($354.00) | Weekly Gain/Loss: | ($80.48) | |||||
| Weekly Transaction Summary | ||||||||||||
| Transaction Fee for Purchase: | $0.05 | Transaction Fee forSales: | $0.10 | |||||||||
| SHARES | PURCHSING | SHARES | SELLING | |||||||||
| BUY | PRICE DR KISEOK NAM: Monday price | TOTAL DR KISEOK NAM: Price*Shares | FEE DR KISEOK NAM: Shares*$0.05 | HOLD | SELL DR KISEOK NAM: Buying Shares-Holding Shares | PRICE DR KISEOK NAM: Use IF command: If zero shares are sold, do nothing, otherwise, put Friday price. | TOTAL DR KISEOK NAM: Use IF command: If zero shares are sold, do nothing, otherwise, Friday price*Shares. | FEE DR KISEOK NAM: Use IF command: If zero shares are sold, do nothing, otherwise, Shares*$0.10. |
||||
| Vertex Pharmaceuticals Incorporated | 163 | $121.25 | $19,763.75 | $8.15 | 163 | 0 | ||||||
| 110 | $552.03 | $60,723.30 | $5.50 | 110 | 0 | |||||||
| General Motors Company | 300 | $37.68 | $11,304.00 | $15.00 | 300 | 0 | ||||||
| Ford Motor Company | 503 | $16.19 | $8,143.57 | $25.15 | 503 | 0 | ||||||
| Total Fee: | $53.80 DR KISEOK NAM: Sum of fees | Total Fee: | $0.00 DR KISEOK NAM: Sum of Fees |
|||||||||
| Total Purchase: | $99,935 DR KISEOK NAM: Sum of purchases | Total Sales | $0 DR KISEOK NAM: Sum of Sales |
|||||||||
| TOTAL PURCHASE: Week 1 | $99,988 DR KISEOK NAM: Use IF Command: if The sum of total purchase and total fee exceeds $100,000, then put "Oh-No!", otherwise, put the sum. | Terminal Value of Portfolio: Week 1 | $97,030 DR KISEOK NAM: SUM of Shares*Friday Price |
|||||||||
| Excess Money DR KISEOK NAM: Make it less than $100 | $12 | |||||||||||
| Weekly Capital Gain/Loss: | ($2,905) DR KISEOK NAM: Sum of Capital Gain/Loss | Week 1 Total Fees: | $53.80 | |||||||||
| Weekly Rate of Return: | -2.9589% | Money Available for Week 2 Investment: | $12 DR KISEOK NAM: Total Sales-Total Fees+Excess Money |
|||||||||
| SECOND WEEK: | ||||||||||||
| Vertex Pharmaceuticals Incorporated | General Motors Company | Goldman Sachs | ||||||||||
| Stock | Daily | Total | Stock | Daily | Total | Stock | Daily | Total | Stock | Daily | Total | |
| Date | Price | Change | Change | Price | Change | Change | Price | Change | Change | Price | Change | Change |
| 4/6/15 | $118.25 | $1.02 | $1.02 | $536.19 | $0.66 | $0.66 | $36.66 | $0.16 | $0.16 | $192.02 | ||
| 4/7/15 | $120.47 | $2.22 | $2.22 | $537.02 | $0.83 | $0.83 | $35.72 | ($0.94) | ($0.94) | $192.40 | $0.38 | $0.38 |
| 4/8/15 | $123.86 | $3.39 | $5.61 | $541.32 | $4.30 | $5.13 | $36.12 | $0.40 | ($0.54) | $192.49 | $0.09 | $0.47 |
| 4/9/15 | $125.64 | $1.78 | $7.39 | $540.15 | ($1.17) | $3.96 | $36.26 | $0.14 | ($0.40) | $194.93 | $2.44 | $2.91 |
| 4/10/15 | $128.47 | $2.83 | $10.22 | $540.01 | ($0.14) | $3.82 | $36.57 | $0.31 | ($0.09) | $195.64 | $0.71 | $3.62 |
| Weekly Gain/Loss: | $1,832.12 | Weekly Gain/Loss: | $492.80 | Weekly Gain/Loss: | $21.00 | Weekly Gain/Loss: | $0.00 | |||||
| Weekly Transaction Summary | ||||||||||||
| Transaction Fee for Purchase: | $0.05 | Transaction Fee forSales: | $0.10 | |||||||||
| OLD | SHARES | PURCHSING | SHARES | SELLING | ||||||||
| HOLD | BUY | PRICE | TOTAL | FEE | HOLD | SELL | PRICE | TOTAL | FEE | |||
| Vertex Pharmaceuticals Incorporated | 163 | 0 | 160 | 3 | $128.47 | $385.41 | $0.30 | |||||
| 110 | 0 | 100 | 10 | $540.01 | $5,400.10 | $1.00 | ||||||
| General Motors Company | 300 | 0 | 250 | 50 | $36.57 | $1,828.50 | $5.00 | |||||
| Goldman Sachs | 0 | 0 | 0 | 0 | ||||||||
| Total Fee: | $0.00 | Total Fee: | $6.30 | |||||||||
| Money Available: | $12 | Total Purchase: | $0 | Total Sales | $7,614 | |||||||
| TOTAL PURCHASE: Week 2 | $0 DR KISEOK NAM: Use IF Command: if The sum of total purchase and total fee exceeds Money available, then put "Oh-No!", otherwise, put the sum. |
|||||||||||
| Excess Money | $12 | |||||||||||
| Initial Value of Portfolio: Week 2 | $89,254 DR KISEOK NAM: Sum of: (Old Shares + Shares buy)*Monday Price | Terminal Value of Portfolio: Week 2 | $91,313 | |||||||||
| Weekly Capital Gain/Loss: | $2,345.92 | Week 2 Total Fee: | $6.30 | |||||||||
| Weekly Rate of Return: | 2.6213% DR KISEOK NAM: (Gain or Loss-All Fees)/E78 | Two-Week Total Fee: | $60.10 | |||||||||
| Two-Week Capital Gain/Loss: | ($558.82) | |||||||||||
| Two-Week Rate of Return: | -0.6190% DR KISEOK NAM: (Two weeks total gain or loss-two weeks fees)/E32 | Money Available for Week 3 Investment | $7,619 | |||||||||
| THIRD WEEK: | ||||||||||||
| Vertex Pharmaceuticals Incorporated | General Motors Company | Goldman Sachs | ||||||||||
| Stock | Daily | Total | Stock | Daily | Total | Stock | Daily | Total | Stock | Daily | Total | |
| Date | Price | Change | Change | Price | Change | Change | Price | Change | Change | Price | Change | Change |
| 4/13/15 | $128.27 | ($0.20) | ($0.20) | $541.35 | $1.34 | $1.34 | $36.46 | ($0.11) | ($0.11) | $196.05 | $0.41 | $0.41 |
| 4/14/15 | $128.73 | $0.46 | $0.46 | $530.39 | ($10.96) | ($10.96) | $36.50 | $0.04 | $0.04 | $197.74 | $1.69 | $1.69 |
| 4/15/15 | $129.14 | $0.41 | $0.87 | $532.53 | $2.14 | ($8.82) | $37.07 | $0.57 | $0.61 | $201.65 | $3.91 | $5.60 |
| 4/16/15 | $128.94 | ($0.20) | $0.67 | $533.80 | $1.27 | ($7.55) | $37.08 | $0.01 | $0.62 | $200.36 | ($1.29) | $4.31 |
| 4/17/15 | $124.92 | ($4.02) | ($3.35) | $524.05 | ($9.75) | ($17.30) | $36.62 | ($0.46) | $0.16 | $197.17 | ($3.19) | $1.12 |
| Weekly Gain/Loss: | $0.00 | Weekly Gain/Loss: | $0.00 | Weekly Gain/Loss: | $0.00 | Weekly Gain/Loss: | $0.00 | |||||
| Weekly Transaction Summary | ||||||||||||
| Transaction Fee for Purchase: | $0.05 | Transaction Fee forSales: | $0.10 | |||||||||
| OLD | SHARES | PURCHSING | SHARES | SELLING | ||||||||
| HOLD | BUY | PRICE | TOTAL | FEE | HOLD | SELL | PRICE | TOTAL | FEE | |||
| Vertex Pharmaceuticals Incorporated | 0 | 0 | 0 | 0 | $124.92 | $0.00 | $0.00 | |||||
| 0 | 0 | 0 | 0 | $524.05 | $0.00 | $0.00 | ||||||
| General Motors Company | 0 | 0 | 0 | 0 | $36.62 | $0.00 | $0.00 | |||||
| Goldman Sachs | 0 | 0 | 0 | 0 | $197.17 | $0.00 | $0.00 | |||||
| Total Fee: | $0 | Total Fee: | $0 | |||||||||
| Money Available: | $7,619 | Total Purchase: | $0 | Total Sales | $0 | |||||||
| TOTAL PURCHASE: Week 3 | $0 | |||||||||||
| Excess Money | $7,619 | |||||||||||
| Initial Value of Portfolio: Week 3 | $0 | Terminal Value of Portfolio: Week 2 | $7,619 | |||||||||
| Weekly Capital Gain/Loss: | $0.00 | Week3 Total Fee: | $0.00 | |||||||||
| Weekly Rate of Return: | ERROR:#DIV/0! | |||||||||||
| Three-Week Capital Gain/Loss: | ($558.82) | Three-Week Total Fees: | $60.10 | |||||||||
| Three-Week Rate of Return: | 7.0004% DR KISEOK NAM: Don't forget the Excess Money |
|||||||||||
Portfolio Rt
| Portfolio Returns for 3-weeks | |||||||||||||
| 63.41% | 18.74% | 8.41% | 9.44% | Date | High P/E | Low P/E | Growth | Value | YourOwn | ||||
| -1.401% | -0.667% | -1.185% | -1.944% | -0.889% | -0.125% | -0.100% | -0.184% | 3/31/15 | -1.297% | -1.445% | -0.775% | -1.065% | -1.062% |
| -0.860% | -0.496% | -0.671% | -0.916% | -0.546% | -0.093% | -0.056% | -0.086% | 4/1/15 | -0.781% | 1.884% | -1.110% | 1.097% | -1.251% |
| 0.232% | 0.065% | 0.708% | 0.732% | 0.147% | 0.012% | 0.059% | 0.069% | 4/2/15 | 0.288% | -0.244% | -0.120% | 0.314% | -0.289% |
| -0.140% | 0.471% | -0.842% | -0.357% | -0.089% | 0.088% | -0.071% | -0.034% | 4/3/15 | -0.105% | -0.017% | -0.403% | 1.190% | -0.350% |
| 4/6/15 | -9.046% | -0.381% | -15.985% | -46.035% | -8.354% | ||||||||
| 70.74% | 18.95% | 0.02% | 10.29% | 4/7/15 | 0.032% | 0.228% | 0.060% | -0.305% | 0.184% | ||||
| 0.220% | -0.764% | -4.401% | 0.212% | 0.156% | -0.145% | -0.001% | 0.022% | 4/8/15 | 3.376% | 0.053% | 0.531% | 0.835% | 1.264% |
| 4.165% | 1.771% | 2.005% | 0.913% | 2.946% | 0.336% | 0.000% | 0.094% | 4/9/15 | -0.023% | 1.100% | -0.202% | -1.739% | 0.213% |
| -0.447% | 0.638% | 1.423% | 1.672% | -0.316% | 0.121% | 0.000% | 0.172% | 4/10/15 | 2.696% | 0.439% | 0.301% | 0.670% | 0.569% |
| 3.371% | -0.232% | 0.217% | 3.455% | 2.385% | -0.044% | 0.000% | 0.356% | 4/13/15 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| 4/14/15 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||
| ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | 4/15/15 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||
| 0.201% | 0.840% | -2.483% | -2.402% | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | 4/16/15 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| -0.681% | -0.437% | -2.434% | -0.148% | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | 4/17/15 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| 16.733% | 0.678% | -2.724% | -0.051% | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| 1.674% | -2.885% | 0.230% | -1.269% | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| 86.02% | 0.62% | 0.02% | 13.34% | ||||||||||
| -1.456% | 4.167% | 0.000% | -1.639% | -1.253% | 0.026% | 0.000% | -0.219% | ||||||
| 2.161% | 2.020% | 0.000% | 0.092% | 1.859% | 0.013% | 0.000% | 0.012% | ||||||
| -0.276% | -1.650% | 0.000% | 0.031% | -0.237% | -0.010% | 0.000% | 0.004% | ||||||
| -0.094% | -2.622% | 69.315% | 0.518% | -0.081% | -0.016% | 0.011% | 0.069% | ||||||
| 86.70% | 0.00% | 0.02% | 13.29% | ||||||||||
| 0.198% | -1.105% | 0.000% | 0.423% | 0.171% | 0.000% | 0.000% | 0.056% | ||||||
| 0.047% | 1.544% | 0.000% | 0.090% | 0.041% | 0.000% | 0.000% | 0.012% | ||||||
| 1.260% | 1.088% | 0.000% | 0.060% | 1.092% | 0.000% | 0.000% | 0.008% | ||||||
| 0.364% | -0.036% | 0.000% | 0.929% | 0.315% | 0.000% | 0.000% | 0.123% | ||||||
| ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||
| 0.858% | -1.824% | 0.000% | 1.424% | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| 1.958% | 0.368% | 0.000% | -0.384% | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| -0.642% | -0.736% | 0.000% | 0.443% | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| -1.605% | 0.626% | 0.000% | -0.206% | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| 14.88% | 19.58% | 7.00% | 58.54% | ||||||||||
| -1.343% | -0.389% | -1.005% | -0.733% | -0.200% | -0.076% | -0.070% | -0.429% | ||||||
| -2.070% | -1.187% | 0.671% | -1.053% | -0.308% | -0.232% | 0.047% | -0.616% | ||||||
| 0.709% | -0.395% | 0.061% | -0.260% | 0.106% | -0.077% | 0.004% | -0.152% | ||||||
| 1.033% | -0.136% | 0.697% | -0.989% | 0.154% | -0.027% | 0.049% | -0.579% | ||||||
| 0.00% | 23.17% | 8.49% | 68.34% | ||||||||||
| -0.364% | -0.031% | -0.451% | 0.155% | 0.000% | -0.007% | -0.038% | 0.106% | ||||||
| -0.733% | 0.507% | -1.550% | 0.798% | 0.000% | 0.118% | -0.132% | 0.545% | ||||||
| -2.985% | -0.290% | 0.153% | -0.216% | 0.000% | -0.067% | 0.013% | -0.148% | ||||||
| -2.428% | 1.297% | 0.214% | -0.026% | 0.000% | 0.300% | 0.018% | -0.018% | ||||||
| ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||
| -1.816% | 0.031% | -1.005% | -2.045% | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| 4.103% | -1.196% | 0.580% | 0.403% | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| -1.519% | -0.802% | -0.335% | 0.238% | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| 0.127% | -0.787% | -0.797% | -1.843% | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| 41.42% | 36.24% | 21.08% | 1.27% | ||||||||||
| -0.268% | -2.532% | 0.696% | -14.518% | -0.111% | -0.917% | 0.147% | -0.1838% | ||||||
| -0.979% | 3.637% | 0.875% | 0.000% | -0.406% | 1.318% | 0.184% | 0.000% | ||||||
| 0.564% | 0.000% | 0.107% | 4.581% | 0.234% | 0.000% | 0.023% | 0.058% | ||||||
| 0.049% | 1.093% | 3.494% | 2.941% | 0.020% | 0.396% | 0.737% | 0.037% | ||||||
| 63.27% | 0.00% | 34.78% | 1.95% | ||||||||||
| -0.323% | -3.834% | -0.132% | -2.778% | -0.204% | 0.000% | -0.046% | -0.054% | ||||||
| -0.025% | 1.917% | 2.524% | -1.418% | -0.016% | 0.000% | 0.878% | -0.028% | ||||||
| -1.304% | 1.380% | -2.627% | 0.000% | -0.825% | 0.000% | -0.914% | 0.000% | ||||||
| 0.503% | -0.885% | 1.691% | -12.136% | 0.318% | 0.000% | 0.588% | -0.236% | ||||||
| ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||
| -2.217% | 0.427% | -1.677% | -5.972% | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | |||||
| 0.127% | 1.091% | 2.440% | -1.550% | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | |||||
| -2.057% | 0.108% | -2.971% | -1.575% | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | |||||
| -1.018% | -1.163% | -1.774% | 0.000% | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | |||||
| 19.78% | 60.76% | 11.31% | 8.15% | ||||||||||
| -2.742% | -0.733% | -0.479% | -0.247% | -0.5424% | -0.4452% | -0.0542% | -0.0202% | ||||||
| -1.314% | -1.053% | -2.075% | -1.434% | -0.2599% | -0.6398% | -0.2347% | -0.1169% | ||||||
| -0.499% | -0.260% | -0.327% | 0.063% | -0.0988% | -0.1582% | -0.0370% | 0.0051% | ||||||
| 1.184% | -0.989% | -0.301% | 0.626% | 0.2342% | -0.6006% | -0.0340% | 0.0510% | ||||||
| 21.60% | 66.08% | 12.32% | 0.00% | ||||||||||
| 1.860% | 0.155% | -2.598% | 0.198% | 0.4017% | 0.1022% | -0.3201% | 0.0000% | ||||||
| 2.775% | 0.798% | 1.114% | 0.047% | 0.5993% | 0.5270% | 0.1372% | 0.0000% | ||||||
| 1.427% | -0.216% | 0.387% | 1.260% | 0.3081% | -0.1430% | 0.0477% | 0.0000% | ||||||
| 2.227% | -0.026% | 0.851% | 0.364% | 0.4810% | -0.0171% | 0.1049% | 0.0000% | ||||||
| ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||
| 0.358% | -2.045% | 0.110% | 0.858% | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| 0.318% | 0.403% | 1.550% | 1.958% | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| -0.155% | 0.238% | 0.027% | -0.642% | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| -3.167% | -1.843% | -1.248% | -1.605% | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
