gloria_the_investor.xlsx
Sheet1
| Risk Free Rate | | 4.30% |
| Return Bond Market | | 11.90% |
| Stock Price | | Total 2003 Dividends | | | | | | | | 5 year Dividend growth | Beta |
| $12.05 | | $0.95 | | | | | | | | 0.0065 | 0.65 |
| $28.02 | | $0.00 | | | | | | | | -1 | 2.3 |
| $17.75 | | $0.00 | | | | | | | | 0 | 1.89 |
| $92.43 | | $1.30 | | | | | | | | 0.0623 | 1.2 |
| $63.79 | | $0.75 | | | | | | | | 0.0095 | 1.35 |
| 71.11 | | $6.00 | | | | | | | | 0.05 | 0.67 |
| $10.00 | | $0.00 | | | | | | | | 0 | 1.78 |
| $49.51 | | $0.68 | | | | | | | | 0.0075 | 0.95 |
| $101.00 | | $5.00 | | | | | | | | 0.0038 | 0.92 |
| $39.78 | | $0.00 | | | | | | | | -0.9 | 1.5 |
| $29.75 | | $2.00 | | | | | | | | 0.0225 | 0.85 |
| $73.09 | | $0.00 | | | | | | | | -0.01 | 0.38 |
| $20.39 | | $6.00 | | | | | | | | 0.0525 | 0.71 |
| $18.25 | | $1.00 | | | | | | | | 0.08 | 1 |
| $7.00 | | $1.35 | | | | | | | | 0.0885 | 0.73 |
| CAPM Return | | 9.24% | | Constant Growth | 1.26% | | | Value |
| | | 21.78% | | | 21.78% |
| | | 18.66% | | | 18.66% |
| | | 13.42% | | | 11.85% |
| | | 14.56% | | | 13.23% |
| | | 9.39% | | | 0.88% |
| | | 17.83% | | | 17.83% |
| | | 11.52% | | | 10.01% |
| | | 11.29% | | | 6.04% |
| | | 15.70% | | | 15.70% |
| | | 10.76% | | | 3.78% |
| | | 7.19% | | | 7.19% |
| | | 9.70% | | | -15.24% |
| | | 11.90% | | | 6.09% |
| | | 9.85% | | | -7.91% |
adatre
