| Portfolio Risk Analysis-SAMPLE 1(DETAILED)YOU COULD DO A SIMPLER ONE BASED ON YOUR SELECTION OF SECURITIES |
| My Required Rate of Return is 3%. There are no constrains and I take an aggressive or high risk investment approach with a passive management strategy. |
| Stocks 85% of Portfolio. All stocks chosen are large-cap stocks. |
| Name of Stock | | Wal-Mart, Inc. | Apple, Inc | Aetna, Inc | Bank of America | Bed, Bath, and Beyond | BlackRock, Inc. | Comcast Corp. |
| Proportion of 100% | | 14.28% | 14.28% | 14.28% | 14.28% | 14.28% | 14.28% | 14.28% |
| Dollar value invested | | $1,214.28 | $1,214.28 | $1,214.28 | $1,214.28 | $1,214.28 | $1,214.28 | $1,214.28 |
| Price |
| Date | Jan-11 | $54.58 | $339.32 | $32.43 | $13.66 | $48.00 | $192.14 | $21.02 |
| | Feb-11 | $50.59 | $353.21 | $36.78 | $14.22 | $48.15 | $197.93 | $23.84 |
| | Mar-11 | $51.02 | $348.51 | $36.85 | $13.28 | $48.27 | $196.40 | $22.77 |
| | Apr-11 | $53.89 | $350.13 | $40.91 | $12.23 | $56.13 | $191.45 | $24.19 |
| | May-11 | $54.48 | $347.83 | $43.18 | $11.70 | $53.89 | $200.84 | $23.20 |
| | Jun-11 | $52.43 | $335.67 | $43.58 | $10.92 | $58.37 | $188.71 | $23.87 |
| | Jul-11 | $52.01 | $390.48 | $41.16 | $9.68 | $58.49 | $175.58 | $23.10 |
| | Aug-11 | $52.86 | $384.83 | $39.71 | $8.15 | $56.86 | $163.43 | $20.93 |
| | Sep-11 | $51.58 | $381.32 | $36.05 | $6.11 | $57.31 | $146.83 | $20.51 |
| | Oct-11 | $56.37 | $404.78 | $39.60 | $6.82 | $61.84 | $156.53 | $22.89 |
| | Nov-11 | $58.53 | $382.20 | $41.65 | $5.44 | $60.51 | $170.66 | $22.25 |
| | Dec-11 | $59.76 | $387.93 | $42.02 | $5.56 | $57.97 | $178.24 | $23.56 |
| Dollar Gain/Loss Per Share |
| after 1 year | | 5.18 | 48.61 | 9.59 | -8.1 | 9.97 | -13.9 | 2.54 |
| Number of shares | | 22.25 | 3.58 | 37.44 | 88.89 | 25.28 | 6.32 | 57.76 |
| Stock Value At End of Year | | $1,329.66 | $1,388.79 | $1,573.23 | $494.23 | $1,465.48 | $1,126.48 | $1,360.83 |
| | Total Dollar Amount Invested In Stocks | | | $8,500.00 |
| | Total Value of Stocks At End of Year | | | $8,738.70 |
| | Dollar Gain At End of Year | | | $238.70 |
| | Gain/Loss As A Percentage | | | 2.80% |
| BONDS 12% of Portfolio | | | | | | Cash or Cash Equivalents 3% of Portfolio |
| NAME: ILLINOIS HSG DEV MULTI-FARM REV BOND 30 YEAR BOND | | | | | | Name: State Farm Certificate of Deposit |
| Purchase Date | | 2/25/12 | | | | Purchase Date | | 2/24/12 |
| COUPON RATE | | 5% | | | | Interest Rate | | 0.45% |
| Maturity Date | | 1/1/42 | | | | Maturity Date | | 2/24/13 |
| Purchase Price | | $100 | | | | Purchase Price | | $300 |
| Yield To Maturity | | 4.90% | | | | Interest Payment at Maturity | | $13.50 |
| Current Yield | | 4.93% | | | | Total Dollar Value in 1 Yr | | $313.50 |
| Rating by S&P | | AA |
| Quantitiy Purchased | | 6 |
| Payment Frequency | | Semiannual |
| Interest Payment Amount | | $15 |
| Name: US Treasury 30 Year Bond |
| Purchase Date | | 2/25/12 | | | | Return on portfolio |
| Coupon Rate | | 3.125 | | | | Stocks | 8738.7 |
| Maturity Date | | 2/15/42 | | | | Bonds | 1248.75 |
| Purchase Price | | $100 | | | | Cash and cash equivalents | 313.5 |
| Quantity Purchased | | 6 |
| Payment Frequency | | Semiannual | | | | Total Dollar Value | 10300.95 |
| Interest payment amount | | $9.38 | | | | Percentage gain/loss | 3% |
| | Total Dollar Amount Invested In Bonds | | | $1,200.00 |
| | Total Interest Paid from Bonds in 1 Yr | | | $48.75 |
| | Gain As A Percentage | | | 4.06% |
| My Initial Investment was an amount of $10,000.00. I chose to invest in 10 different securities. At the end of a one |
| year period, the total value of my portfolio is $10,300.95 which represents a 3% gain. This gain meets my |
| requirement for a minimum 3% return on my investement. However, although my required return was met |
| I have to change my investment approach if I seek to maximize my profits as an aggressive investor. |
barkersbaseball
fin340_spreadsheet-sample_1.xlsx
