please bid if you can deliver quality work, otherwise don't. I will ask for refund
ArshadHussain
4-FIN567ProjectSpreadsheet31.xlsSheet1
| Example of How to Record Your | ||||||||
| FI567 Poject Investment Portfolio | ||||||||
| Value of Equities==========> | 512,891 | |||||||
| 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 | $39.66 | 1,260.72 | 1300 | 51,558 |
| Alcoa | AA | Aluminum | 6/1/59 | $50,000.00 | $139.24 | 359.09 | 400 | 55,696 |
| American Express | AXP | Consumer finance | 8/30/82 | $50,000.00 | $30.07 | 1,662.79 | 1700 | 51,119 |
| AT&T | T | Telecommunication | 11/1/99 | $50,000.00 | $65.79 | 759.99 | 800 | 52,632 |
| Bank of America | BAC | Banking | 2/19/08 | $50,000.00 | $55.89 | 894.61 | 900 | 50,301 |
| Boeing | BA | Aerospace and defense | 3/12/87 | $50,000.00 | $23.99 | 2,084.20 | 2100 | 50,379 |
| Caterpillar | CAT | Construction and mining equipment | 5/6/91 | $50,000.00 | $19.27 | 2,594.71 | 2600 | 50,102 |
| Chevron Corporation | CVX | Oil & gas | 2/19/08 | $50,000.00 | $65.85 | 759.30 | 800 | 52,680 |
| Cisco Systems | CSCO | Computer networking | 6/8/09 | $50,000.00 | $100.31 | 498.45 | 500 | 50,155 |
| Coca-Cola | KO | Beverages | 3/12/87 | $50,000.00 | $37.13 | 1,346.62 | 1300 | 48,269 |
| 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 Corporation | 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 and entertainment | 5/6/91 | $50,000.00 |
Sheet2
| 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. |
Sheet3
| FIN567 Poject Investment Portfolio | ||||||||
| EQUITIES | Value of Equities===> | $492,808 | ||||||
| Company | Symbol | Industry | Date Added | Approx Value of Position | Current Share Price | Number of Shares | Round to Nearest 100 | Current Value |
| 3M | MMM | Conglomerate | 8/9/76 | $50,000.00 | $233.16 | 214.45 | 200 | 46632.00 |
| American Express | AXP | Consumer finance | 8/30/82 | $50,000.00 | $93.93 | 532.31 | 500 | 46965.00 |
| Cisco Systems | CSCO | Computer networking | 6/8/09 | $50,000.00 | $36.31 | 1,377.03 | 1400 | 50834.00 |
| Coca-Cola | KO | Beverages | 3/12/87 | $50,000.00 | $45.66 | 1,095.05 | 1100 | 50226.00 |
| ExxonMobil | XOM | Oil & gas | 10/1/1928 | $50,000.00 | $80.54 | 620.81 | 600 | 48324.00 |
| General Electric | GE | Conglomerate | 11/7/07 | $50,000.00 | $17.90 | 2,793.30 | 2800 | 50120.00 |
| The Home Depot | HD | Home improvement retailer | 11/1/99 | $50,000.00 | $170.46 | 293.32 | 300 | 51,138.00 |
| JPMorgan Chase | JPM | Banking | 5/6/91 | $50,000.00 | $98.99 | 505.10 | 500 | 49495.00 |
| Microsoft | MSFT | Software | 11/1/99 | $50,000.00 | $82.50 | 606.06 | 600 | 49500.00 |
| Pfizer | PFE | Pharmaceuticals | 4/8/04 | $50,000.00 | $35.41 | 1,412.03 | 1400 | 49574.00 |
