Part II
pandrews190823
Sample_Stock_Ledger-1.xlsxSheet5
Log_1
| Company Name | Sym-bol | Status | # of Shares | Date | $ share | Value | Buy | Sell |
| Electronic Arts | ERTS | OWN | 100 | 1/7 | $15.00 | $1,500.00 | $1,500.00 | |
| OWN | 100 | 1/29 | $0.00 | |||||
| OWN | 100 | 2/19 | $0.00 | |||||
| OWN | 100 | 3/11 | $0.00 | |||||
| SOLD | 100 | 4/1 | $0.00 | $0.00 | ||||
| OWN | 0 | 4/1 | $0.00 | |||||
| Anheuser-Busch | BUD | OWN | 70 | 1/7 | $51.38 | $3,596.60 | $3,596.60 | |
| OWN | 70 | 1/29 | $0.00 | |||||
| OWN | 70 | 2/19 | $0.00 | |||||
| OWN | 70 | 3/11 | $0.00 | |||||
| SOLD | 70 | 4/1 | $0.00 | $0.00 | ||||
| OWN | 0 | 4/1 | $0.00 | |||||
| Coca-Cola | COKE | OWN | 150 | 1/7 | $30.67 | $4,600.50 | $4,600.50 | |
| OWN | 150 | 1/29 | $0.00 | |||||
| OWN | 150 | 2/19 | $0.00 | |||||
| OWN | 150 | 3/11 | $0.00 | |||||
| SOLD | 150 | 4/1 | $0.00 | $0.00 | ||||
| OWN | 0 | 4/1 | $0.00 | |||||
| Cash reserves | BUY | IN | INIT | $10,000.00 | ||||
| 1/7 | $302.90 | |||||||
| 1/29 | ||||||||
| 2/19 | ||||||||
| 3/11 | ||||||||
| CASH | OUT | 4/1 | ||||||
| Portfolio value | 1/7 | $10,000.00 | ||||||
| 1/29 | $0.00 | |||||||
| 2/19 | $0.00 | |||||||
| 3/11 | $0.00 | |||||||
| 4/1 | $0.00 | |||||||
| Return on Investment | ($10,000.00) |
Stock Portfolio for (your name here)
Log_2
| Company Name | Symbol | Status | Shares | Date | $ Share | Value | Buy | Sell |
| Electronic Arts | ERTS | OWN | 100 | 1/7 | $15.00 | $1,500.00 | $1,500.00 | |
| OWN | 100 | 1/29 | $15.09 | $1,509.00 | ||||
| OWN | 100 | 2/19 | $0.00 | |||||
| OWN | 100 | 3/11 | $0.00 | |||||
| SOLD | 100 | 4/1 | $0.00 | $0.00 | ||||
| OWN | 0 | 4/1 | $0.00 | |||||
| Anheuser-Busch | BUD | OWN | 70 | 1/7 | $51.38 | $3,596.60 | $3,596.60 | |
| OWN | 70 | 1/29 | $52.51 | $3,675.70 | ||||
| OWN | 70 | 2/19 | $0.00 | |||||
| OWN | 70 | 3/11 | $0.00 | |||||
| SOLD | 70 | 4/1 | $0.00 | $0.00 | ||||
| OWN | 0 | 4/1 | $0.00 | |||||
| Coca-Cola | COKE | OWN | 150 | 1/7 | $30.67 | $4,600.50 | $4,600.50 | |
| OWN | 150 | 1/29 | $30.05 | $4,507.50 | ||||
| OWN | 150 | 2/19 | $0.00 | |||||
| OWN | 150 | 3/11 | $0.00 | |||||
| SOLD | 150 | 4/1 | $0.00 | $0.00 | ||||
| OWN | 0 | 4/1 | $0.00 | |||||
| Cash Reserves | BUY | IN | INIT | $10,000.00 | ||||
| 1/7 | $302.90 | |||||||
| 1/29 | $302.90 | |||||||
| 2/19 | ||||||||
| 3/11 | ||||||||
| CASH | OUT | 4/1 | ||||||
| Portfolio Value | 1/7 | $10,000.00 | ||||||
| 1/29 | $9,995.10 | |||||||
| 2/19 | $0.00 | |||||||
| 3/11 | $0.00 | |||||||
| 4/1 | $0.00 | |||||||
| Return on Investment | ($10,000.00) |
Log_3
| Company Name | Sym-bol | Status | Shares | Date | $ share | Value | Buy | Sell |
| Electronic Arts | ERTS | OWN | 100 | 1/7 | $15.00 | $1,500.00 | $1,500.00 | |
| OWN | 100 | 1/29 | $15.09 | $1,509.00 | ||||
| OWN | 100 | 2/19 | $12.71 | $1,271.00 | ||||
| OWN | 100 | 3/11 | $0.00 | |||||
| SOLD | 100 | 4/1 | $0.00 | $0.00 | ||||
| OWN | 0 | 4/1 | $0.00 | |||||
| Anheuser-Busch | BUD | OWN | 70 | 1/7 | $51.38 | $3,596.60 | $3,596.60 | |
| OWN | 70 | 1/29 | $52.51 | $3,675.70 | ||||
| OWN | 70 | 2/19 | $48.99 | $3,429.30 | ||||
| OWN | 70 | 3/11 | $0.00 | |||||
| SOLD | 70 | 4/1 | $0.00 | $0.00 | ||||
| OWN | 0 | 4/1 | $0.00 | |||||
| Coca-Cola | COKE | OWN | 150 | 1/7 | $30.67 | $4,600.50 | $4,600.50 | |
| OWN | 150 | 1/29 | $30.05 | $4,507.50 | ||||
| OWN | 150 | 2/19 | $29.33 | $4,399.50 | ||||
| OWN | 150 | 3/11 | $0.00 | |||||
| SOLD | 150 | 4/1 | $0.00 | $0.00 | ||||
| OWN | 0 | 4/1 | $0.00 | |||||
| Cash reserves | BUY | IN | INIT | $10,000.00 | ||||
| 1/7 | $302.90 | |||||||
| 1/29 | $302.90 | |||||||
| 2/19 | $302.90 | |||||||
| 3/11 | ||||||||
| CASH | OUT | 4/1 | ||||||
| Portfolio Value | 1/7 | $10,000.00 | ||||||
| 1/29 | $9,995.10 | |||||||
| 2/19 | $9,402.70 | |||||||
| 3/11 | $0.00 | |||||||
| 4/1 | $0.00 | |||||||
| Return on Investment | ($10,000.00) |
Log_4
| Company Name | Sym-bol | Status | Shares | Date | $ share | Value | Buy | Sell |
| Electronic Arts | ERTS | OWN | 100 | 1/7 | $15.00 | $1,500.00 | $1,500.00 | |
| OWN | 100 | 1/29 | $15.09 | $1,509.00 | ||||
| OWN | 100 | 2/19 | $12.71 | $1,271.00 | ||||
| OWN | 100 | 3/11 | $14.75 | $1,475.00 | ||||
| SOLD | 100 | 4/1 | $0.00 | $0.00 | ||||
| OWN | 0 | 4/1 | $0.00 | |||||
| Anheuser-Busch | BUD | OWN | 70 | 1/7 | $51.38 | $3,596.60 | $3,596.60 | |
| OWN | 70 | 1/29 | $52.51 | $3,675.70 | ||||
| OWN | 70 | 2/19 | $48.99 | $3,429.30 | ||||
| OWN | 70 | 3/11 | $49.71 | $3,479.70 | ||||
| SOLD | 70 | 4/1 | $0.00 | $0.00 | ||||
| OWN | 0 | 4/1 | $0.00 | |||||
| Coca-Cola | COKE | OWN | 150 | 1/7 | $30.67 | $4,600.50 | $4,600.50 | |
| OWN | 150 | 1/29 | $30.05 | $4,507.50 | ||||
| OWN | 150 | 2/19 | $29.33 | $4,399.50 | ||||
| OWN | 150 | 3/11 | $31.74 | $4,761.00 | ||||
| SOLD | 150 | 4/1 | $0.00 | $0.00 | ||||
| OWN | 0 | 4/1 | $0.00 | |||||
| Cash reserves | BUY | IN | INIT | $10,000.00 | ||||
| 1/7 | $302.90 | |||||||
| 1/29 | $302.90 | |||||||
| 2/19 | $302.90 | |||||||
| 3/11 | $302.90 | |||||||
| CASH | OUT | 4/1 | ||||||
| Portfolio Value | 1/7 | $10,000.00 | ||||||
| 1/29 | $9,995.10 | |||||||
| 2/19 | $9,402.70 | |||||||
| 3/11 | $10,018.60 | |||||||
| 4/1 | $0.00 | |||||||
| Return on Investment | ($10,000.00) |
Log_5
| Company Name | Sym-bol | Status | Shares | Date | $ share | Value | Buy | Sell | Profit/ Loss on Stock |
| Electronic Arts | ERTS | OWN | 100 | 1/7 | $15.00 | $1,500.00 | $1,500.00 | ||
| OWN | 100 | 1/29 | $15.09 | $1,509.00 | |||||
| OWN | 100 | 2/19 | $12.71 | $1,271.00 | |||||
| OWN | 100 | 3/11 | $14.75 | $1,475.00 | |||||
| SOLD | 100 | 4/1 | $15.01 | $1,501.00 | $1,501.00 | $1.00 | |||
| OWN | 0 | 4/1 | $0.00 | ||||||
| Anheuser-Busch | BUD | OWN | 70 | 1/7 | $51.38 | $3,596.60 | $3,596.60 | ||
| *Any time you have | OWN | 70 | 1/29 | $52.51 | $3,675.70 | ||||
| a sold row for a date, | OWN | 70 | 2/19 | $48.99 | $3,429.30 | ||||
| you must also have an | OWN | 70 | 3/11 | $49.71 | $3,479.70 | ||||
| own row for it - that way | SOLD | 70 | 4/1 | $51.21 | $3,584.70 | $3,584.70 | ($11.90) | ||
| you will not be confused | OWN | 0 | 4/1 | $0.00 | |||||
| about what is still owned | |||||||||
| Coca-Cola | COKE | OWN | 150 | 1/7 | $30.67 | $4,600.50 | $4,600.50 | ||
| OWN | 150 | 1/29 | $30.05 | $4,507.50 | |||||
| OWN | 150 | 2/19 | $29.33 | $4,399.50 | |||||
| OWN | 150 | 3/11 | $31.74 | $4,761.00 | |||||
| SOLD | 150 | 4/1 | $32.88 | $4,932.00 | $4,932.00 | $331.50 | |||
| OWN | 0 | 4/1 | $0.00 | ||||||
| Cash reserves | BUY | IN | INIT | $10,000.00 | |||||
| 1/7 | $302.90 | ||||||||
| 1/29 | $302.90 | *Cash reserves should be equal to previous | |||||||
| 2/19 | $302.90 | if no stocks were sold that week! | |||||||
| 3/11 | $302.90 | ||||||||
| CASH | OUT | 4/1 | $10,320.60 | ||||||
| Portfolio Value | 1/7 | $10,000.00 | *Note, no SOLD stocks appear in PV | ||||||
| 1/29 | $9,995.10 | only OWN stocks. | |||||||
| **Note on this date (2/19)** | 2/19 | $9,402.70 | |||||||
| the market substantially | 3/11 | $10,018.60 | |||||||
| dropped; this person chose | 4/1 | $0.00 | Since all stocks are sold on 4/1, PV | ||||||
| to ride it out rather than selling | equals $0 on this date as it has been sold | ||||||||
| Return on Investment | $320.60 |
Advanced_Log
| Company Name | Sym-bol | Status | Shares | Date | $ share | Value | Buy | Sell | Profit/ Loss on Stock |
| Motorola | MOT | OWN | 100 | 1/7 | $15.00 | $1,500.00 | $1,500.00 | ||
| SOLD | 60 | 1/29 | $17.19 | $1,031.40 | $1,031.40 | ||||
| *Any time you have | OWN | 40 | 1/29 | $17.19 | $687.60 | ||||
| a sold row for a date, | OWN | 40 | 2/19 | $14.90 | $596.00 | ||||
| you must also have an | SOLD | 40 | 3/11 | $19.29 | $771.60 | $771.60 | $303.00 | ||
| own row for it - that way | OWN | 0 | 3/11 | $0.00 | |||||
| you will not be confused | OWN | 0 | 4/1 | $0.00 | |||||
| about what is still owned | OWN | 0 | 4/1 | $0.00 | |||||
| Home Depot | HD | OWN | 70 | 1/7 | $35.41 | $2,478.70 | $2,478.70 | ||
| OWN | 70 | 1/29 | $35.43 | $2,480.10 | |||||
| OWN | 70 | 2/19 | $33.25 | $2,327.50 | |||||
| OWN | 70 | 3/11 | $36.05 | $2,523.50 | |||||
| SOLD | 70 | 4/1 | $36.35 | $2,544.50 | $2,544.50 | $65.80 | |||
| OWN | 0 | 4/1 | $0.00 | ||||||
| USANA Health | USNA | OWN | 177 | 1/7 | $28.10 | $4,973.70 | $4,973.70 | ||
| SOLD | 177 | 1/29 | $32.90 | $5,823.30 | $5,823.30 | $849.60 | |||
| OWN | 0 | 1/29 | $0.00 | ||||||
| OWN | 0 | 2/19 | $0.00 | ||||||
| OWN | 0 | 3/11 | $0.00 | ||||||
| OWN | 0 | 4/1 | $0.00 | ||||||
| OWN | 0 | 4/1 | $0.00 | ||||||
| Action Performance | ACTN | OWN | 0 | 1/7 | $0.00 | ||||
| OWN | 400 | 1/29 | $14.45 | $5,780.00 | $5,780.00 | ||||
| OWN | 400 | 2/19 | $12.63 | $5,052.00 | |||||
| OWN | 400 | 3/11 | $14.10 | $5,640.00 | |||||
| SOLD | 400 | 4/1 | $13.95 | $5,580.00 | $5,580.00 | ($200.00) | |||
| OWN | 0 | 4/1 | $0.00 | ||||||
| Sportsline USA | SPLN | OWN | 0 | 1/7 | $0.00 | ||||
| OWN | 0 | 1/29 | $0.00 | ||||||
| OWN | 0 | 2/19 | $0.00 | ||||||
| OWN | 2159 | 3/11 | $1.34 | $2,893.06 | $2,893.06 | ||||
| SOLD | 2159 | 4/1 | $1.37 | $2,957.83 | $2,957.83 | $64.77 | |||
| OWN | 0 | 4/1 | $0.00 | ||||||
| Cash reserves | BUY | IN | INIT | $10,000.00 | |||||
| 1/7 | $1,047.60 | ||||||||
| 1/29 | $2,122.30 | ||||||||
| 2/19 | $2,122.30 | *Cash reserves should be equal to previous | |||||||
| 3/11 | $0.84 | if no stocks were sold that week! | |||||||
| CASH | OUT | 4/1 | $11,083.17 | ||||||
| Portfolio Value | 1/7 | $10,000.00 | *Note, no SOLD stocks appear in PV | ||||||
| 1/29 | $11,070.00 | only OWN stocks. | |||||||
| **Note on this date (2/19)** | 2/19 | $10,097.80 | |||||||
| the market substantially | 3/11 | $11,057.40 | |||||||
| dropped; this person chose | 4/1 | $0.00 | *Since all stocks are sold on 4/1, PV | ||||||
| to ride it out rather than selling | equals $0 on this date as it has been sold | ||||||||
| Return on Investment | $1,083.17 |
