| | | FIN567 Poject Investment Portfolio |
| EQUITIES | | | | | | Value of Equities===> | | 0 |
| | | | | Approx Value | Current | Number of | Round to | Current |
| Company | Symbol | Industry | Date Added | of Position | Share Price | Shares | Nearest 100 | Value |
| 3M | MMM | Conglomerate | 8/9/76 | $50,000.00 |
| Alcoa | AA | Aluminum | 6/1/59 | $50,000.00 | | | ` |
| American Express | AXP | Consumer finance | 8/30/82 | $50,000.00 |
| AT&T | T | Telecommunications | 11/1/99 | $50,000.00 |
| Bank of America | BAC | Banking | 2/19/08 | $50,000.00 |
| Boeing | BA | Aerospace and defense | 3/12/87 | $50,000.00 |
| Caterpillar | CAT | Construction + mining equip | 5/6/91 | $50,000.00 |
| Chevron Corporation | CVX | Oil & gas | 2/19/08 | $50,000.00 |
| Cisco Systems | CSCO | Computer networking | 6/8/09 | $50,000.00 |
| Coca-Cola | KO | Beverages | 3/12/87 | $50,000.00 |
| DuPont | DD | Chemical industry | 11/20/35 | $50,000.00 |
| ExxonMobil | XOM | Oil & gas | 10/1/1928 | $50,000.00 |
| General Electric | GE | Conglomerate | 11/7/07 | $50,000.00 |
| Hewlett-Packard | HPQ | Technology | 3/17/97 | $50,000.00 |
| The Home Depot | HD | Home improvement retailer | 11/1/99 | $50,000.00 |
| Intel | INTC | Semiconductors | 11/1/99 | $50,000.00 |
| IBM | IBM | Computers and technology | 6/29/79 | $50,000.00 |
| Johnson & Johnson | JNJ | Pharmaceuticals | 3/17/97 | $50,000.00 |
| JPMorgan Chase | JPM | Banking | 5/6/91 | $50,000.00 |
| Kraft Foods | KFT | Food processing | 9/22/08 | $50,000.00 |
| McDonald's | MCD | Fast food | 10/30/85 | $50,000.00 |
| Merck | MRK | Pharmaceuticals | 6/29/79 | $50,000.00 |
| Microsoft | MSFT | Software | 11/1/99 | $50,000.00 |
| Pfizer | PFE | Pharmaceuticals | 4/8/04 | $50,000.00 |
| Procter & Gamble | PG | Consumer goods | 5/26/32 | $50,000.00 |
| Travelers | TRV | Insurance | 6/8/09 | $50,000.00 |
| United Technologies Corp | UTX | Conglomerate | 3/14/39 | $50,000.00 |
| Verizon Communications | VZ | Telecommunication | 4/8/04 | $50,000.00 |
| Wal-Mart | WMT | Retail | 3/17/97 | $50,000.00 |
| Walt Disney | DIS | Broadcasting + entertainment | 5/6/91 | $50,000.00 |
| Notes: |
| 1. Select any 10 issues. |
| 2. Enter their current prices in the column marked Current Share Price. |
| 3. The rest of the data will appear automatically as will the total. |
| FIXED INCOME |
| Bonds/Notes | Qty | Maturity | Price | Current | Coupon | Yield to |
| | | | | Value | | Maturity |
| US Treasury Note | 1000 |
| US Treasury Note | 1000 |
| US Treasury Note | 1000 |
| US Treasury Note | 1000 |
| Total Market Value of Bonds/Notes | | | | 0 |
| Money Market | | | | 500,000 |
| Portfolio Value | | | | 500,000 |
| Notes: |
| 1. Select 4 issues ranging from two to five years (approximately) in maturity. |
| 2. Fill in the required data in the spreadsheet and compute the current value of each issue. |
| 3. The spreadsheet will sum up your portfolio value. |
Kpetewoma11
FIN567ProjectSpreadsheet.xls
