Random Stock Portfolio
mahirgupta
TableTemplate.xlsxSheet1
| Random Portfolio (example) | |||||||
| Jodi's Cupcakes, Inc | Bil's Auto Parts, Inc. | Lumbering Jack's Sports, Inc. | Idiot Corp | Mindful Wellness Centers, Inc. | |||
| Ticker | JOCC | BAPI | LJS | IDIOT | MWC | ||
| Exchange | NASDAQ | NASDAQ | NYSE | NASDAQ | NYSE | ||
| Sector | Consumer Discretionary | Industrial | Consumer Discretionary | Technology | Healthcare | ||
| Industry | Food retail | Autoparts | Sports Retail | Software | Outpatient | ||
| Principal Competitor | Cakes R US | Parts R Us | Sports R Us | Tech IS Us | Health IS Us | ||
| Price 1/15 | $15.25 | $23.35 | $9.15 | $6.54 | $38.25 | ||
| Median Price Target | $13.00 | $25.00 | $15.00 | $4.25 | $33.25 | ||
| EPS TTM Gary Porter: Gary Porter: Example criteria | $1.25 | $0.59 | $2.63 | $0.23 | $1.25 | ||
| Forward Earnings | $1.28 | $0.75 | $2.75 | $0.54 | $1.67 | ||
| Forward P/E | 11.9 | 31.1 | 3.5 | 12.1 | 22.9 | ||
| Beta | 0.45 | 1.25 | 1.15 | 2.54 | 1.11 | ||
| Market Cap ($bil) | $0.256 | $1.350 | $4.540 | $0.750 | $125.564 | ||
| PEG Ratio | 1.30 | 0.75 | 2.10 | 0.35 | 1.00 | ||
| S&P 500 | 2535.25 | ||||||
| 90 day t-bill | 1.350% | ||||||
| THIS FORMAT SHOULD BE USED FOR THE RANDOM, VALUE AND TOP DOWN PORTFOIOS. | |||||||
| THIS EXAMPLE IS UNIQUE TO THE RANDOM PORTFOLIO. | |||||||
| ALTER THE CONTENT OF THE ROWS TO REFLECT CRITERIA UNIQUE TO EACH PORTFOLIO. | |||||||
| NOTE THAT LARGE VALUES ARE STATED IN BILLIONS, WITH A MAXIMUM OF 3 DECIMAL PLACES. | |||||||
